Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] pgsql connection timeone - Mailing list pgsql-performance

From Vucomir Ianculov
Subject Re: [PERFORM] pgsql connection timeone
Date
Msg-id 1859642671.2159.1485953516113.JavaMail.vukomir@DESKTOP-9I7P6HN
Whole thread Raw
In response to Re: [PERFORM] pgsql connection timeone  (Vucomir Ianculov <vukomir@os-ux.com>)
Responses Re: [PERFORM] pgsql connection timeone
List pgsql-performance
Tree view
can anyone help me with my problem?
i'm really don't know from when the problem can be.



From: "Vucomir Ianculov" <vukomir@os-ux.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Sent: Saturday, January 28, 2017 12:03:55 PM
Subject: Re: [PERFORM] pgsql connection timeone

p { margin: 0; }
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@sss.pgh.pa.us>
To: "Vucomir Ianculov" <vukomir@os-ux.com>
Cc: pgsql-performance@postgresql.org
Sent: Wednesday, January 25, 2017 3:15:28 PM
Subject: Re: [PERFORM] pgsql connection timeone

Vucomir Ianculov <vukomir@os-ux.com> 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 by date:

Previous
From: Merlin Moncure
Date:
Subject: [PERFORM] PSA: upgrade your extensions
Next
From: Daniel Blanch Bataller
Date:
Subject: Re: [PERFORM] PSA: upgrade your extensions