Re: Query on Patch and Upgrade History in PostgreSQL

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Query on Patch and Upgrade History in PostgreSQL
Дата
Msg-id CANzqJaAXndhtNnmXLwApqS74Jnsv2KdtR0JJsK_M76kJ6s5auw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query on Patch and Upgrade History in PostgreSQL  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления: