Re: user connection not recorded?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: user connection not recorded?
Дата
Msg-id 19871.1438266075@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: user connection not recorded?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: user connection not recorded?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 07/30/2015 06:42 AM, Melvin Davidson wrote:
>> I can understand that the host is not available in nslookup, but why is
>> the user not being recorded?

> A quick look at the source shows that Postgres system process can have NULL username:

Well, the real point is that that message comes out before we've collected
the startup packet, so we don't *have* a username yet.  All we know is
that somebody's opened a TCP connection.  The later "connection
authorized" message will tell you what database user name they gave.

If you see lots more "connection received" than "connection authorized"
then somebody is connecting to your postmaster and failing to
authenticate, which is usually a good thing to investigate.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: [ADMIN] How Many PG_Locks are considered too many
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: user connection not recorded?