Re: pgsql: libpq: Grease the protocol by default

Jacob Champion <jacob.champion@enterprisedb.com>

From: Jacob Champion <jacob.champion@enterprisedb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jelte Fennema-Nio <postgres@jeltef.nl>, pgsql-hackers@lists.postgresql.org, Andrew Dunstan <andrew@dunslane.net>, Nathan Bossart <nathandbossart@gmail.com>
Date: 2026-02-24T18:58:30Z
Lists: pgsql-hackers
On Tue, Feb 24, 2026 at 10:50 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Simple is good here.  I don't think we'd buy much by distinguishing
> minor versions of already-EOL servers.  Also, I suspect that
> pg_upgrade can't get the minor version except by starting the server
> and asking it --- we don't record anything but major version on-disk.

We do store (the major version part of) `pg_ctl --version` at some
point, which we could improve upon, but I agree that adding additional
complexity here doesn't actually give us any benefit.

--Jacob



Commits

  1. pg_upgrade: Use max_protocol_version=3.0 for older servers

  2. libpq: Grease the protocol by default

  3. libpq: Prepare for protocol grease during 19beta