From: Tom Lane <tgl@sss.pgh.pa.us>
To: Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
Cc: pgsql-admin@lists.postgresql.org, nc@gatewaynet.com, Achilleas Mantzios <itdev@gatewaynet.com>
Subject: Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0
Date: Fri, 08 Dec 2023 11:56:12 -0500
Message-ID: <1454680.1702054572@sss.pgh.pa.us> (raw)
In-Reply-To: <06bf30c8-371e-5575-e1cc-a6dc1140b8af@cloud.gatewaynet.com>
References: <e33e0231-77d7-4dd7-4b7c-97af1d0e091b@cloud.gatewaynet.com>
<1436714.1702046865@sss.pgh.pa.us>
<06bf30c8-371e-5575-e1cc-a6dc1140b8af@cloud.gatewaynet.com>
Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com> writes:
> I would very much like this to have been a pgbouncer issue but it is
> not. I was hoping I expressed the situation clearly, I am sorry if I
> didn't. This is not about any multiple values per session, I send a
> simple test below that reproduces the problem very easily (against *any*
> pgbouncer 1.18+). The behavior of pgsql 16.1 is that it does not report
> a SET application_name=... back to the client if the new value is the
> same as the current one. This wasn't the behavior in pgsql 10.
No, but it's been true since v14 (cf commit 2432b1a04). In any case,
the test case you're showing doesn't look like it'd exercise that
behavior, since the SET is installing a new value.
I did a bit of testing of the behavior of "application_name=" in the
connection string followed by an explicit SET, and AFAICS we do send
a ParameterStatus report from the SET, with no apparent change in
behavior from quite far back (I tried 9.5 for comparison). So I
continue to maintain that this is a pgbouncer problem. Maybe it
has not been updated for the no-duplicate-reports server behavior?
Although it's still hard to see why that would matter here.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, a.mantzios@cloud.gatewaynet.com, itdev@gatewaynet.com
Subject: Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0
In-Reply-To: <1454680.1702054572@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox