Re: Query on Patch and Upgrade History in PostgreSQL - Mailing list pgsql-general

From Ron Johnson
Subject Re: Query on Patch and Upgrade History in PostgreSQL
Date
Msg-id CANzqJaAXndhtNnmXLwApqS74Jnsv2KdtR0JJsK_M76kJ6s5auw@mail.gmail.com
Whole thread Raw
In response to Re: Query on Patch and Upgrade History in PostgreSQL  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
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!

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Query on Patch and Upgrade History in PostgreSQL
Next
From: Adrian Klaver
Date:
Subject: Re: Query on Patch and Upgrade History in PostgreSQL