Re: Clarification on warning when connecting to 'pgbouncer' database via Pgbouncer - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Clarification on warning when connecting to 'pgbouncer' database via Pgbouncer
Date
Msg-id CAKFQuwYHTOyN435-ARCNRJpCy0aDi2isvy-3W1r20mWq8WFu+A@mail.gmail.com
Whole thread Raw
In response to Re: Clarification on warning when connecting to 'pgbouncer' database via Pgbouncer  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Clarification on warning when connecting to 'pgbouncer' database via Pgbouncer
List pgsql-hackers
On Tue, May 27, 2025 at 3:08 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> psql has zero awareness of pgbouncer or any other non-PostgreSQL server you
> might be able to point it to and establish a successful connection.  The
> lack of a warning previously is probably more incorrect than its presence
> now.

Yeah.  I'd say the fundamental problem is that pgbouncer is abusing
the server_version parameter, which will break plenty of things
besides psql --- pg_dump for instance

They proxy over the real server information during actual bouncer work - it's just their local administrative database connection - one that isn't proxied - that is at issue here.


Anyway, I'm minus quite a lot on silencing this warning, because
it is telling you about real problems you are likely to hit.


How about the false-negative that was happening for years when this warning didn't appear even though you were connected to pgbouncer and not PostgreSQL?

David J.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Clarification on warning when connecting to 'pgbouncer' database via Pgbouncer
Next
From: Tom Lane
Date:
Subject: Re: Clarification on warning when connecting to 'pgbouncer' database via Pgbouncer