Re: [HACKERS] Adding connection id in the startup message

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: [HACKERS] Adding connection id in the startup message
Дата
Msg-id 20170615133837.GR1769@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: [HACKERS] Adding connection id in the startup message  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: [HACKERS] Disallowing multiple queries per PQexec()
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Making server name part of the startup message