Query on Patch and Upgrade History in PostgreSQL

On Wed, 2025-09-24 at 13:47 +0530, loganathan P wrote:

How do I find the date and time of applied minor patches and upgrades in a PostgreSQL database level?

This information is not stored inside the database.
A minor upgrade just means replacing the files and restarting the server.

If you are using a package manager, perhaps you can find the information there.

Yours,
Laurenz Albe

On Wed, Sep 24, 2025 at 6:37 AM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:

On Wed, 2025-09-24 at 13:47 +0530, loganathan P wrote:

How do I find the date and time of applied minor patches and upgrades in

a PostgreSQL database level?

This information is not stored inside the database.
A minor upgrade just means replacing the files and restarting the server.

If you are using a package manager, perhaps you can find the information
there.

On PM-based systems, you can.

$ rpm -q --last postgresql17
postgresql17-17.6-1PGDG.rhel8.x86_64 Sun 24 Aug 2025 08:57:02 AM
EDT

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

On 9/24/25 01:17, loganathan P wrote:

Dear All,

How do I find the date and time of applied minor patches and upgrades in
a PostgreSQL database level?

In addition to looking at package information, as others have mentioned,
there is:

https://git.postgresql.org/gitweb/?p=postgresql.git

Click on a tag name for when the tag was created.

If you click on the shortlog or log links next to
the tag you get a list of the commits.

Thanks.

Regards,
Loganathan P

--
Adrian Klaver
adrian.klaver@aklaver.com