Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ca3Sf-0005Hb-Sz for pgsql-performance@arkaria.postgresql.org; Sat, 04 Feb 2017 16:45:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ca3Sf-0003m3-9s for pgsql-performance@arkaria.postgresql.org; Sat, 04 Feb 2017 16:45:17 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ca3Se-0003lk-JL for pgsql-performance@postgresql.org; Sat, 04 Feb 2017 16:45:16 +0000 Received: from webmail.os-ux.com ([78.46.104.104]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ca3Sb-0008AG-2I for pgsql-performance@postgresql.org; Sat, 04 Feb 2017 16:45:15 +0000 Received: from localhost (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 83E643BDBC1; Sat, 4 Feb 2017 17:45:09 +0100 (CET) Received: from webmail.os-ux.com ([127.0.0.1]) by localhost (webmail.os-ux.com [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id oQue-siGN9fg; Sat, 4 Feb 2017 17:45:09 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 3A3553BDBC2; Sat, 4 Feb 2017 17:45:09 +0100 (CET) DKIM-Filter: OpenDKIM Filter v2.9.2 webmail.os-ux.com 3A3553BDBC2 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=os-ux.com; s=8262FE2E-C2B5-11E2-BC5C-8AEC8B26ED38; t=1486226709; bh=dUdHTuqrOuI3CoIqj1627TxKo4i9YH0V1081COzk7G8=; h=Date:From:To:Message-ID:Subject:MIME-Version:Content-Type; b=K9qGcMx6d4K7pxttT/4uVBpMChaMo1HLG4ii4LN+tk7YrXgFo4t7HmrEABPvFBL69 z474Aa0f6PD5FiQfAilAx5FWic6p8l0Cd92geRYIUctwAewHqohwmMSYkr0n6mBhu2 1l6L6oyJcMvgiR2HRe1imehXR0ThFlV8pBJw5fHU= X-Virus-Scanned: amavisd-new at os-ux.com Received: from webmail.os-ux.com ([127.0.0.1]) by localhost (webmail.os-ux.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id YQFs20dnhv-q; Sat, 4 Feb 2017 17:45:09 +0100 (CET) Received: from webmail.os-ux.com (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 06DFC3BDBC1; Sat, 4 Feb 2017 17:45:09 +0100 (CET) Date: Sat, 4 Feb 2017 17:45:08 +0100 (CET) From: Vucomir Ianculov To: Vitalii Tymchyshyn Cc: pgsql-performance@postgresql.org, Tom Lane Message-ID: <1836727777.268.1486226707980.JavaMail.vukomir@DESKTOP-9I7P6HN> In-Reply-To: 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> Subject: Re: pgsql connection timeone MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_267_12679229.1486226707976" X-Originating-IP: [78.46.104.104] X-Mailer: Zimbra 8.6.0_GA_1153 (Zimbra Desktop/7.2.8_12102_Windows) Thread-Topic: pgsql connection timeone Thread-Index: TOqqATKwSkloN96jESU89SMaoVvb7Q== X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org ------=_Part_267_12679229.1486226707976 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hi Vitalii, no, hove can i check it? searched but did not find any useful information . Thanks, Br, Vuko ----- Original Message ----- From: "Vitalii Tymchyshyn" To: "Vucomir Ianculov" , "Tom Lane" 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 ------=_Part_267_12679229.1486226707976 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: arial,helvetica,sans-serif; font-size: 10pt; colo= r: #000000'>Hi Vitalii,

no, hove can i check it? searched but did no= t find any useful information .

Thanks,

Br,
Vuko
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
Sen= t: Wednesday, February 1, 2017 7:11:12 PM
Subject: Re: [PERFO= RM] pgsql connection timeone

Just a wild guess, but did you check yo= ur random source? We had similar problems in Oracle and had to switch to /d= ev/urandom. It can be done with a system variable setting.

On Wed, Feb 1, 2017, 7:52 AM Vucomir Ian= culov <vukomir@os= -ux.com> wrote:
can anyone help me with my problem?
i'm really d= on'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

Subj= ect: Re: [PERFORM] pgsql connection timeone

Hi Tom,

this is the entry from pg_hba.conf
host all          &n= bsp;  all          &= nbsp;  0.0.0.0/0         &nbs= p;     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 lo= t of free ram.



<= /span>
From: "Tom Lane= " <tgl@sss.pgh.pa.us>
To: "Vucomir Ianculov" <vukomir@os-ux.com>
Cc: pgsql-performance@pos= tgresql.org
Sent: Wed= nesday, January 25, 2017 3:15:28 PM
Subject: Re: [PERFORM] pgsql connection timeone

Vucomir Ianculov <vukomir@os-ux.com&g= t; 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 du= e 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 authenti= cation due to timeout

So ..= . what authentication method are you using?

          = ;            &n= bsp; regards, tom lane


------=_Part_267_12679229.1486226707976--