Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ufsn3-0006aL-Aw for pgsql-bugs@arkaria.postgresql.org; Fri, 24 May 2013 14:16:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Ufsn2-0005uB-OI for pgsql-bugs@arkaria.postgresql.org; Fri, 24 May 2013 14:16:16 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ufsn1-0005ts-Sl for pgsql-bugs@postgresql.org; Fri, 24 May 2013 14:16:16 +0000 Received: from mim-2.aetna.com ([206.213.251.45] helo=aetna.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ufsmu-0008UB-RP for pgsql-bugs@postgresql.org; Fri, 24 May 2013 14:16:14 +0000 Received: from ([167.69.207.193]) by midpironmail2.aetna.com with ESMTP id 4SV4JL1.141688874; Fri, 24 May 2013 10:16:05 -0400 Received: from ([167.69.37.19]) by MIDP-MAIL-900.aetna.com with ESMTP id 8GHMLL1.46535404; Fri, 24 May 2013 10:16:02 -0400 Received: from WVMP-HUB-100.aeth.aetna.com (167.69.246.23) by WINP-MSG-901.aeth.aetna.com (167.69.79.63) with Microsoft SMTP Server (TLS) id 8.3.298.1; Fri, 24 May 2013 10:16:02 -0400 Received: from WINPMBXD101.aeth.aetna.com ([169.254.1.28]) by WVMP-HUB-100.aeth.aetna.com ([167.69.246.23]) with mapi id 14.02.0342.003; Fri, 24 May 2013 10:16:02 -0400 From: "Krawetzky, Peter J" To: "pgsql-bugs@postgresql.org" Subject: Re: Error Thread-Topic: [BUGS] Error Thread-Index: AQHOWIel6DhhSfg8FkGwsEQsdlKrhpkUYV2A Date: Fri, 24 May 2013 14:16:00 +0000 Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.2.4.120824 x-originating-ip: [167.69.142.46] MIME-Version: 1.0 X-CFilter-Loop: Forwarded Content-Type: multipart/alternative; boundary="_000_CDC4EDE66895KrawetzkyPJaetnacom_" X-Pg-Spam-Score: -5.3 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org --_000_CDC4EDE66895KrawetzkyPJaetnacom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Are you using persistent connections from your application? This would hol= d the connection to the database=2E So I think you have 2 choices:=0D=0A1= =2E Disable persistent connections=0D=0A2=2E Increaes MAX_CONNECTIONS in = postgresql=2Econf=0D=0A=0D=0A=0D=0AFrom: Bakyaraj K >=0D=0ADate: Friday, May 24, 2013= 4:40 AM=0D=0ATo: "pgsql-bugs@postgresql=2Eorg" >= =0D=0ASubject: [BUGS] Error=0D=0A=0D=0AHi,=0D=0A I am facing this issues = when i use postgresql database=2E=0D=0A=0D=0A=0D=0A FATAL: remaining conne= ction slots are reserved for non-replication superuser connections=0D=0A=0D= =0APostgresql 9=2E2 version=2E=0D=0A=0D=0ACould you help me and how to reso= lve the issue=2E=0D=0A=0D=0A--=0D=0AThanks=2E,=0D=0ABakyaraj K=0D=0ALinux S= erver Administrator=0D=0ASedin Technologies=0D=0ASkype id : bakyaraj=2Erail= sfactory=0D=0A=0D=0A=0D=0AThis e-mail= may contain confidential or privileged information=2E If=0D=0Ayou think yo= u have received this e-mail in error, please advise the=0D=0Asender by repl= y e-mail and then delete this e-mail immediately=2E=0D=0AThank you=2E Aetna= --_000_CDC4EDE66895KrawetzkyPJaetnacom_ Content-Type: text/html; charset="us-ascii" Content-ID: Content-Transfer-Encoding: quoted-printable =0D=0A=0D=0A=0D=0A=0D=0A=0D= =0A
=0D=0A
Are you using persistent connections from your applicati= on?  This would hold the connection to the database=2E  So I thin= k you have 2 choices:
=0D=0A
1=2E  Disable persistent connect= ions
=0D=0A
2=2E  Increaes MAX_CONNECTIONS in postgresql=2Eco= nf
=0D=0A
=0D=0A

=0D=0A
=0D=0A
=0D=0A
=0D= =0A

=0D=0A
=0D=0A=0D=0A
=0D=0AFrom: Bakyaraj K <bakyaraj@railsfactory=2Eorg>
=0D=0ADate: Friday, May 24, 2013 4:40 AM
=0D=0ATo: "pgsql-bugs@postgresql=2Eorg" <pgsql-bugs@postgresql=2Eorg>
=0D=0ASubject: [BUGS] Error
=0D=0A
=0D=0A=

=0D=0A
=0D=0A
=0D=0A
=0D=0A
=0D=0A=0D=0AHi,
=0D=0A
=0D=0A   I am f= acing this issues when i use postgresql database=2E
=0D=0A
=0D=0A
=0D=0A
=0D=0A
=0D=0A
=0D=0A
=0D= =0A
=0D=0A
=0D=0A
=0D=0A
=0D= =0A FATAL:  remaining connection slots are reserved for non-repli= cation superuser connections
=0D=0A
=0D=0A

=0D=0A=0D=0A
=0D=0A
=0D=0APostgresql 9=2E2 version=2E
= =0D=0A
=0D=0A
=0D=0A
=0D=0A
=0D=0ACou= ld you help me and how to resolve the issue=2E
=0D=0A
=0D=0A
= =0D=0A--
=0D=0A
=0D=0A
T= hanks=2E,
=0D=0A
Bakyaraj K
=0D=0A
Linux Server Administrat= or
=0D=0A
Sedin Technologies 
=0D=0A=0D=0A
Skype id :=0D=0Abakyaraj=2Erailsfact= ory
=0D=0A
=0D=0A
=0D=0A
=0D=0A=0D=0A
=0D=0A
=0D=0A=0D=0A=0D=0A=0D=0AThis e-mail= may contain confidential or privileged information=2E If you think you hav= e received this e-mail in error, please advise the sender by reply e-mail a= nd then delete this e-mail immediately=2E Thank you=2E Aetna --_000_CDC4EDE66895KrawetzkyPJaetnacom_--