Re: [HACKERS] Adding connection id in the startup message - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [HACKERS] Adding connection id in the startup message
Date
Msg-id 20170615133837.GR1769@tamriel.snowman.net
Whole thread Raw
In response to Re: [HACKERS] Adding connection id in the startup message  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
* Peter Eisentraut (peter.eisentraut@2ndquadrant.com) wrote:
> On 6/15/17 03:11, Satyanarayana Narlapuram wrote:
> > Client adds a connection id in the startup message and send it to the
> > server it is trying to connect to. Proxy logs the connection id
> > information in its logs, and passes it to the server. Server logs the
> > connection Id in the server log, and set it in the GUC variable
> > (ConnectionId).
>
> If you're using pgbouncer or similar, then it might reuse an already
> existing connection, so your connection ID wouldn't be passed on.

This tends to be what people (as pgbouncer does) use application_name
for.

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: [HACKERS] Disallowing multiple queries per PQexec()
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Making server name part of the startup message