Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: [HACKERS] Adding connection id in the startup message
Date
Msg-id d06000f2-2acd-07a8-5ec6-874514f0763a@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] Adding connection id in the startup message  (Satyanarayana Narlapuram <Satyanarayana.Narlapuram@microsoft.com>)
Responses Re: [HACKERS] Adding connection id in the startup message  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tree view 
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.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] intermittent failures in Cygwin from select_parallel tests
Next
From: "Daniel Verite"
Date:
Subject: Re: [HACKERS] Disallowing multiple queries per PQexec()