Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 48DCA9F9B2A for ; Mon, 3 Sep 2007 04:04:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 73292-03 for ; Mon, 3 Sep 2007 04:04:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mx0.ifl.net (mx0.ifl.net [194.238.48.13]) by postgresql.org (Postfix) with ESMTP id 4D92A9F95E4 for ; Mon, 3 Sep 2007 04:04:22 -0300 (ADT) Received: from mail03.internal.rmplc.net (hercules.rmplc.co.uk [194.238.48.90]) by mx0.ifl.net (8.13.1/8.13.6) with ESMTP id l8374HV2028777; Mon, 3 Sep 2007 07:04:17 GMT X-MessageTextProcessor: DisclaimIt (2.00.200) on mail03.internal.rmplc.net Received: from EX-INDIA1.internal.rmplc.net ([172.25.8.14]) by mail03.internal.rmplc.net with Microsoft SMTPSVC(6.0.3790.1830); Mon, 3 Sep 2007 08:04:15 +0100 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2929 Subject: Re: FW: max_connections and shared_buffers Date: Mon, 3 Sep 2007 12:34:10 +0530 Message-ID: <772CDA49C515244FA14E34443F62E56402F17455@EX-INDIA1.internal.rmplc.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: FW: [ADMIN] max_connections and shared_buffers thread-index: Acft9j/UPO7pLEUbQB+vpDChoqpBjwAABzSw References: <772CDA49C515244FA14E34443F62E56402F173E0@EX-INDIA1.internal.rmplc.net> From: "Anoo Sivadasan Pillai" To: "Scott Marlowe" Cc: Importance: normal X-OriginalArrivalTime: 03 Sep 2007 07:04:15.0250 (UTC) FILETIME=[A367A720:01C7EDF8] X-TM-AS-Product-Ver: SMEX-7.0.0.1499-5.0.1021-15396.001 X-TM-AS-Result: No--14.123400-8.000000-31 X-IFL-MailScanner-Information: Please contact IFL support for more information X-IFL-MailScanner: Found to be clean X-IFL-MailScanner-From: aspillai@in.rm.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/11 X-Sequence-Number: 26772 Hi Scott,=20 We will be putting connection pooling, But as of now we have to find some cure before implementing pooling. Memory - 2GB Postgres - PostgreSQL 8.2.4 OS - Windows 2003 server installation: ( Service Pack 2 ) I am not sure how to get the number of connections while this happens. How this can be taken? Thanks and Regards, Anoo S -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@gmail.com]=20 Sent: 03 September 2007 12:17 To: Anoo Sivadasan Pillai Cc: pgsql-admin@postgresql.org Subject: Re: FW: [ADMIN] max_connections and shared_buffers On 9/3/07, Anoo Sivadasan Pillai wrote: > Hi Scott, > > Sorry for the long mail and Thank you for the quick response, > My problem is that our server shuts down unexpectedly, the settings are > max_connections=3D1024,shared_buffers =3D 32MB for the machine. The > following is the log snippet > 2007-08-15 15:44:10 LOG: could not receive data from client: No > connection could be made because the target machine actively refused it. > 2007-08-15 15:44:10 LOG: unexpected EOF on client connection > 2007-08-15 15:44:17 LOG: received fast shutdown request > 2007-08-15 15:44:17 LOG: aborting any active transactions > 2007-08-15 15:44:17 FATAL: terminating connection due to administrator > command > 2007-08-15 15:44:17 FATAL: the database system is shutting down > 2007-08-15 15:44:17 LOG: shutting down > > Any clues? Sounds like you're being hit by the Out of Memory (oom) killer in your kernel maybe? how many connections do you have when this happens? I think you might need to look at connection pooling. 1024 connections is a LOT of connections. How much memory does your server have, btw, and what version of pgsql and what os are you running this on? Visit our Website at http://www.rmesi.co.in This message is confidential. You should not copy it or disclose its = contents to anyone. You may use and apply the information for the = intended purpose only. Internet communications are not secure; = therefore, RMESI does not accept legal responsibility for the contents = of this message. Any views or opinions presented are those of the author = only and not of RMESI. If this email has come to you in error, please = delete it, along with any attachments. Please note that RMESI may = intercept incoming and outgoing email communications.=20 Freedom of Information Act 2000 This email and any attachments may contain confidential information = belonging to RMESI. Where the email and any attachments do contain = information of a confidential nature, including without limitation = information relating to trade secrets, special terms or prices these = shall be deemed for the purpose of the Freedom of Information Act 2000 = as information provided in confidence by RMESI and the disclosure of = which would be prejudicial to RMESI's commercial interests. This email has been scanned for viruses by Trend ScanMail.