Re: pgsql connection timeone

[Vucomir Ianculov <vukomir@xxxxxxxxx>]

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" <tgl@xxxxxxxxxxxxx>
To: "Vucomir Ianculov" <vukomir@xxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx
Sent: Wednesday, January 25, 2017 3:15:28 PM
Subject: Re: pgsql connection timeone

Vucomir Ianculov <vukomir@xxxxxxxxx> 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