From: Vucomir Ianculov <vukomir@os-ux.com>
To: Vitalii Tymchyshyn <vit@tym.im>
Cc: pgsql-performance@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: pgsql connection timeone
Date: Sat, 4 Feb 2017 17:45:08 +0100 (CET)
Message-ID: <1836727777.268.1486226707980.JavaMail.vukomir@DESKTOP-9I7P6HN> (raw)
In-Reply-To: <CABWW-d0BPKAi4CfB07ZW1Fxb_piKP4qgXd2iGTUvGWs330xnhw@mail.gmail.com>
References: <199526991.862.1485336217892.JavaMail.vukomir@DESKTOP-9I7P6HN>
<5265.1485350128@sss.pgh.pa.us>
<1533063486.1591.1485597833654.JavaMail.vukomir@DESKTOP-9I7P6HN>
<1859642671.2159.1485953516113.JavaMail.vukomir@DESKTOP-9I7P6HN>
<CABWW-d0BPKAi4CfB07ZW1Fxb_piKP4qgXd2iGTUvGWs330xnhw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi Vitalii,
no, hove can i check it? searched but did not find any useful information .
Thanks,
Br,
Vuko
----- Original Message -----
From: "Vitalii Tymchyshyn" <vit@tym.im>
To: "Vucomir Ianculov" <vukomir@os-ux.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Sent: Wednesday, February 1, 2017 7:11:12 PM
Subject: Re: [PERFORM] pgsql connection timeone
Just a wild guess, but did you check your random source? We had similar problems in Oracle and had to switch to /dev/urandom. It can be done with a system variable setting.
On Wed, Feb 1, 2017, 7:52 AM Vucomir Ianculov < vukomir@os-ux.com > wrote:
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
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: vukomir@os-ux.com, vit@tym.im, tgl@sss.pgh.pa.us
Subject: Re: pgsql connection timeone
In-Reply-To: <1836727777.268.1486226707980.JavaMail.vukomir@DESKTOP-9I7P6HN>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox