Re: [PERFORM] pgsql connection timeone

От: Vucomir Ianculov
Тема: Re: [PERFORM] pgsql connection timeone
Дата: ,
Msg-id: 1533063486.1591.1485597833654.JavaMail.vukomir@DESKTOP-9I7P6HN
(см: обсуждение, исходный текст)
Ответ на: Re: [PERFORM] pgsql connection timeone  (Tom Lane)
Ответы: Re: [PERFORM] pgsql connection timeone  (Vucomir Ianculov)
Список: pgsql-performance

Скрыть дерево обсуждения

[PERFORM] pgsql connection timeone  (Vucomir Ianculov, )
 Re: [PERFORM] pgsql connection timeone  (Vucomir Ianculov, )
 Re: [PERFORM] pgsql connection timeone  (Tom Lane, )
  Re: [PERFORM] pgsql connection timeone  (Vucomir Ianculov, )
   Re: [PERFORM] pgsql connection timeone  (Vucomir Ianculov, )
    Re: [PERFORM] pgsql connection timeone  (Vitalii Tymchyshyn, )
     Re: [PERFORM] pgsql connection timeone  (Vucomir Ianculov, )
      Re: [PERFORM] pgsql connection timeone  (Vitalii Tymchyshyn, )
       Re: [PERFORM] pgsql connection timeone  (Vucomir Ianculov, )

Hi Tom,

this is the entry from pg_hba.conf
host all             all             0.0.0.0/0               md5

i needed to restart postgres service to be able to accept new connection, witch it strange becouse there was no load on the server and it head a lot of free ram.





From: "Tom Lane" <>
To: "Vucomir Ianculov" <>
Cc:
Sent: Wednesday, January 25, 2017 3:15:28 PM
Subject: Re: [PERFORM] pgsql connection timeone

Vucomir Ianculov <> writes:
> i'm seeing a lot of connection time out in postgresql log

> 2017-01-25 11:09:47 EET [6897-1] XXX@YYY FATAL: canceling authentication due to timeout
> 2017-01-25 11:10:15 EET [6901-1] XXX@YYY FATAL: canceling authentication due to timeout
> 2017-01-25 11:10:17 EET [6902-1] xxx@YYY FATAL: canceling authentication due to timeout

So ... what authentication method are you using?

                        regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Vucomir Ianculov
Дата:
Сообщение: Re: [PERFORM] pgsql connection timeone
От: Philippe Ivaldi
Дата:
Сообщение: Re: [PERFORM] Chaotic query planning ?