Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cXPrd-0000er-6L for pgsql-performance@arkaria.postgresql.org; Sat, 28 Jan 2017 10:04:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cXPrb-0003LJ-Bu for pgsql-performance@arkaria.postgresql.org; Sat, 28 Jan 2017 10:04:07 +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 1cXPra-0003L6-O5 for pgsql-performance@postgresql.org; Sat, 28 Jan 2017 10:04:06 +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 1cXPrT-0007k6-CP for pgsql-performance@postgresql.org; Sat, 28 Jan 2017 10:04:05 +0000 Received: from localhost (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 6481492BF03; Sat, 28 Jan 2017 11:03:56 +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 tWgnIbqRVh7z; Sat, 28 Jan 2017 11:03:56 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id 1248892BF2E; Sat, 28 Jan 2017 11:03:56 +0100 (CET) DKIM-Filter: OpenDKIM Filter v2.9.2 webmail.os-ux.com 1248892BF2E DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=os-ux.com; s=8262FE2E-C2B5-11E2-BC5C-8AEC8B26ED38; t=1485597836; bh=T5Y/DIzvRHga4HBOWAmOkokGMj8kh1e5HIs2X+1zLGA=; h=Date:From:To:Message-ID:Subject:MIME-Version:Content-Type; b=JL8bxjwYm07O4HyLZdqO2RRl/jHy44SvxJJY1LEy8qKggqoHUSAq7cx5wR0L4NzwF 1zd2zjUGM1ZTA8uqG55fVx3X/y5PY3ntGEwumBv7EnoHQZF0zvXsDm4gp/8dMmTh1L aNoOlV8+I5c1thiHGBuJfEsLK0FowdQL4by5HvWw= 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 c0na2FCX_3dP; Sat, 28 Jan 2017 11:03:55 +0100 (CET) Received: from webmail.os-ux.com (localhost [127.0.0.1]) by webmail.os-ux.com (Postfix) with ESMTP id C9E5B92BF03; Sat, 28 Jan 2017 11:03:55 +0100 (CET) Date: Sat, 28 Jan 2017 11:03:55 +0100 (CET) From: Vucomir Ianculov To: Tom Lane Cc: pgsql-performance@postgresql.org Message-ID: <1533063486.1591.1485597833654.JavaMail.vukomir@DESKTOP-9I7P6HN> In-Reply-To: <5265.1485350128@sss.pgh.pa.us> References: <199526991.862.1485336217892.JavaMail.vukomir@DESKTOP-9I7P6HN> <5265.1485350128@sss.pgh.pa.us> Subject: Re: pgsql connection timeone MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1590_1680042000.1485597833653" 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: zC48he7ZUyAYeRsR3QezcHCeODYT1w== X-Pg-Spam-Score: -5.2 (-----) 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_1590_1680042000.1485597833653 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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_1590_1680042000.1485597833653 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 Tom,

this is the entry from pg_hba.conf
host all        =      all        = ;     0.0.0.0/0      &nbs= p;        md5

i needed to restart= postgres service to be able to accept new connection, witch it strange bec= ouse there was no load on the server and it head a lot of free ram.

=

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

Vucomir Ianculov <vukom= ir@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
> 20= 17-01-25 11:10:17 EET [6902-1] xxx@YYY FATAL: canceling authentication due = to timeout

So ... what authentication method are you using?

=             &nb= sp;           regard= s, tom lane

------=_Part_1590_1680042000.1485597833653--