Date: Wed, 4 Jan 2017 12:03:00 +0100 (CET)
From: Vucomir Ianculov <vukomir@os-ux.com>
To: Andreas Kretschmer <akretschmer@spamfence.net>
Cc: pgsql-performance@postgresql.org
Message-ID: <1772714872.854.1483527774431.JavaMail.vukomir@DESKTOP-9I7P6HN>
In-Reply-To: <20170104091223.GA5751@tux>
References: <1587952740.561.1483437295901.JavaMail.vukomir@DESKTOP-9I7P6HN>
 <1796991063.571.1483437640199.JavaMail.vukomir@DESKTOP-9I7P6HN>
 <20170104091223.GA5751@tux>
Subject: Re: Unable to connect to server
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_853_442946271.1483527774430"
Thread-Topic: Unable to connect to server
Thread-Index: kSBI0UDGrbOF8P+ba+AcohwqJQxA0A==
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

------=_Part_853_442946271.1483527774430
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

HI Andreas, 

thanks for your replay, i have checked connection number for the last 3 mouths and maximum number of connection was 300, so i can reduce this is it's cousin the issue. 
during this error server was 99% idle, the only thing is that there was a pg_dump running on one of the DB, can this cause this error, also i have restarted pg server 2 days before because of server cert update. 


Thanks. 


----- Original Message -----

From: "Andreas Kretschmer" <akretschmer@spamfence.net> 
To: pgsql-performance@postgresql.org 
Sent: Wednesday, January 4, 2017 11:12:23 AM 
Subject: Re: [PERFORM] Unable to connect to server 

Vucomir Ianculov <vukomir@os-ux.com> wrote: 

> Hi, 
> 
> today i head a issue with pgsql 9.3, a lot of clients complained that they are 
> unable to connect to the server. 
> when i have checked the logs i sow a lot of 
> FATAL: canceling authentication due to timeout 

you can increase authentication_timeout, default is 1 minute. How many 
clients do you have, do you really needs 1000 connections? If yes, 
please consider a connection pooler like pgbouncer. 


Regards, Andreas Kretschmer 
-- 
Andreas Kretschmer 
http://www.2ndQuadrant.com/ 
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services 


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) 
To make changes to your subscription: 
http://www.postgresql.org/mailpref/pgsql-performance 


------=_Part_853_442946271.1483527774430
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D'text/css'>p { margin: 0; }</style></head><body><=
div style=3D'font-family: arial,helvetica,sans-serif; font-size: 10pt; colo=
r: #000000'>HI Andreas,<br><br>thanks for your replay, i have checked conne=
ction number for the last 3 mouths and maximum number of connection was 300=
, so i can reduce this is it's cousin the issue.<br>during this error serve=
r was 99% idle, the only thing is that there was a pg_dump running on one o=
f the DB, can this cause this error, also i have restarted pg server 2 days=
 before because of server cert update.<br><br><span size=3D"1" data-mce-sty=
le=3D"font-size: xx-small;" style=3D"font-size: xx-small;"><span><span clas=
s=3D"Object" id=3D"OBJ_PREFIX_DWT202"><span class=3D"Object" id=3D"OBJ_PREF=
IX_DWT152_com_zimbra_url"><span class=3D"Object" id=3D"OBJ_PREFIX_DWT2295_c=
om_zimbra_url"></span></span></span></span></span><div><span name=3D"x"></s=
pan>Thanks.<br><br><br></div><hr id=3D"zwchr"><div style=3D"color: rgb(0, 0=
, 0); font-weight: normal; font-style: normal; text-decoration: none; font-=
family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Andreas=
 Kretschmer" &lt;akretschmer@spamfence.net&gt;<br><b>To: </b>pgsql-performa=
nce@postgresql.org<br><b>Sent: </b>Wednesday, January 4, 2017 11:12:23 AM<b=
r><b>Subject: </b>Re: [PERFORM] Unable to connect to server<br><br>Vucomir =
Ianculov &lt;vukomir@os-ux.com&gt; wrote:<br><br>&gt; Hi,<br>&gt; <br>&gt; =
today i head a issue with pgsql 9.3, a lot of clients complained that they =
are<br>&gt; unable to connect to the server.<br>&gt; when i have checked th=
e logs i sow a lot of<br>&gt; FATAL: &nbsp;canceling authentication due to =
timeout<br><br>you can increase authentication_timeout, default is 1 minute=
. How many<br>clients do you have, do you really needs 1000 connections? If=
 yes,<br>please consider a connection pooler like pgbouncer.<br><br><br><br=
>Regards, Andreas Kretschmer<br>-- <br>Andreas Kretschmer<br>http://www.2nd=
Quadrant.com/<br>PostgreSQL Development, 24x7 Support, Remote DBA, Training=
 &amp; Services<br><br><br>-- <br>Sent via pgsql-performance mailing list (=
pgsql-performance@postgresql.org)<br>To make changes to your subscription:<=
br>http://www.postgresql.org/mailpref/pgsql-performance<br></div><br></div>=
</body></html>
------=_Part_853_442946271.1483527774430--