Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYuOQ-0006b0-2e for pgsql-performance@arkaria.postgresql.org; Wed, 01 Feb 2017 12:52:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cYuOO-0006Uc-NR for pgsql-performance@arkaria.postgresql.org; Wed, 01 Feb 2017 12:52:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYuOO-0006UV-6D for pgsql-performance@postgresql.org; Wed, 01 Feb 2017 12:52:08 +0000 Received: from webmail.os-ux.com ([78.46.104.104]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYuOG-00038a-PI for pgsql-performance@postgresql.org; Wed, 01 Feb 2017 12:52:07 +0000 Received: from localhost (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 5C0263BDBC1; Wed, 1 Feb 2017 13:51:59 +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 AiGPa4CnQCQG; Wed, 1 Feb 2017 13:51:59 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 1809B3BDBC2; Wed, 1 Feb 2017 13:51:59 +0100 (CET) DKIM-Filter: OpenDKIM Filter v2.9.2 webmail.os-ux.com 1809B3BDBC2 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=os-ux.com; s=8262FE2E-C2B5-11E2-BC5C-8AEC8B26ED38; t=1485953519; bh=fdxSjl1lNCuJZlq/4zaFeUC3A6lvQn2OTliDypH6DZ0=; h=Date:From:To:Message-ID:Subject:MIME-Version:Content-Type; b=YBx2jim8aDtCfUTaiyBf0wLz1fiBq4/PqGHpQTL3QFiaogMsERmLJn71xmlQpH2uF 4YB6VcNtE5kIYS1SLfgoCUD1obxoZIb7ZpzuVnzB4mUalRKeIIvpcKoKUYRVUetoy1 Crt7S8CvBQ1XBBriz5RKoZtGfAJhb2Kx7eoqBIG4= 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 KLw76NvmIqmd; Wed, 1 Feb 2017 13:51:58 +0100 (CET) Received: from webmail.os-ux.com (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id CB7B63BDBC1; Wed, 1 Feb 2017 13:51:58 +0100 (CET) Date: Wed, 1 Feb 2017 13:51:58 +0100 (CET) From: Vucomir Ianculov To: Tom Lane Cc: pgsql-performance@postgresql.org Message-ID: <1859642671.2159.1485953516113.JavaMail.vukomir@DESKTOP-9I7P6HN> In-Reply-To: <1533063486.1591.1485597833654.JavaMail.vukomir@DESKTOP-9I7P6HN> References: <199526991.862.1485336217892.JavaMail.vukomir@DESKTOP-9I7P6HN> <5265.1485350128@sss.pgh.pa.us> <1533063486.1591.1485597833654.JavaMail.vukomir@DESKTOP-9I7P6HN> Subject: Re: pgsql connection timeone MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2158_9579340.1485953516110" 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: zC48he7ZUyAYeRsR3QezcHCeODYT18DuU/mb 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_2158_9579340.1485953516110 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit can anyone help me with my problem? i'm really don't know from when the problem can be. ----- Original Message ----- From: "Vucomir Ianculov" To: "Tom Lane" 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. ----- Original Message ----- From: "Tom Lane" To: "Vucomir Ianculov" Cc: pgsql-performance@postgresql.org Sent: Wednesday, January 25, 2017 3:15:28 PM Subject: Re: [PERFORM] pgsql connection timeone Vucomir Ianculov 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_2158_9579340.1485953516110 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'>can anyone help me with my problem?
i'm really don't know fr= om 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,

th= is is the entry from pg_hba.conf
host all  &= nbsp;          all  =            0.0.0.0/0 = ;            &n= bsp; md5

i needed to restart postgres service to be able to accept n= ew 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&g= t;
Cc: pgsql-performance@postgresql.org
Sent: Wednesday= , January 25, 2017 3:15:28 PM
Subject: Re: [PERFORM] pgsql connec= tion timeone

Vucomir Ianculov <vukomir@os-ux.com> writes:
&= gt; 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: cance= ling authentication due to timeout
> 2017-01-25 11:10:17 EET [6902-1= ] xxx@YYY FATAL: canceling authentication due to timeout

So ... wha= t authentication method are you using?

     = ;            &n= bsp;      regards, tom lane


------=_Part_2158_9579340.1485953516110--