Re: Online PostgreSQL version() updates - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Online PostgreSQL version() updates
Date
Msg-id 9A9D654D-A666-4943-B1FC-1E086AAC68C0@yandex-team.ru
Whole thread Raw
In response to Online PostgreSQL version() updates  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Responses Re: Online PostgreSQL version() updates
List pgsql-hackers

> On 1 Apr 2026, at 15:48, Matthias van de Meent <boekewurm+postgres@gmail.com> wrote:
>
> Attached is a patch that allows superusers to update the version() of
> their running system with a simple SQL call: SELECT
> pg_update_version(version_num, 'version_short', 'the full version()
> outout')

While I find this proposal very useful, I think the interface can be improved.

Consider SELECT pg_update_version(commit_hash) so we can do stuff like
SELECT pg_update_version('REL_18_2') or SELECT pg_update_version('HEAD~10000').
In future we can even create a bisect facility, so when user encounters a bug in their production they can iterate over
severalcommits to trace root cause. 


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Better shared data structure management and resizable shared data structures
Next
From: Alexander Korotkov
Date:
Subject: Re: POC: Parallel processing of indexes in autovacuum