Обсуждение: Query on Patch and Upgrade History in PostgreSQL
Dear All,
How do I find the date and time of applied minor patches and upgrades in a PostgreSQL database level?
Thanks.
Regards,
Loganathan P
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
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