From: | Vucomir Ianculov <vukomir(at)os-ux(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: pgsql connection timeone |
Date: | 2017-01-28 10:03:55 |
Message-ID: | 1533063486.1591.1485597833654.JavaMail.vukomir@DESKTOP-9I7P6HN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vucomir Ianculov" <vukomir(at)os-ux(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Sent: Wednesday, January 25, 2017 3:15:28 PM
Subject: Re: [PERFORM] pgsql connection timeone
Vucomir Ianculov <vukomir(at)os-ux(dot)com> writes:
> i'm seeing a lot of connection time out in postgresql log
> 2017-01-25 11:09:47 EET [6897-1] XXX(at)YYY FATAL: canceling authentication due to timeout
> 2017-01-25 11:10:15 EET [6901-1] XXX(at)YYY FATAL: canceling authentication due to timeout
> 2017-01-25 11:10:17 EET [6902-1] xxx(at)YYY FATAL: canceling authentication due to timeout
So ... what authentication method are you using?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Philippe Ivaldi | 2017-01-30 08:24:11 | Re: Chaotic query planning ? |
Previous Message | Tom Lane | 2017-01-25 13:15:28 | Re: pgsql connection timeone |