Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 863F3632A33 for ; Thu, 26 Feb 2009 14:15:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69242-08 for ; Thu, 26 Feb 2009 14:15:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.int.journyx.com (mail.journyx.com [66.219.41.227]) by mail.postgresql.org (Postfix) with ESMTP id 021086326D9 for ; Thu, 26 Feb 2009 14:15:14 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id 3B1757E41C6 for ; Thu, 26 Feb 2009 12:15:13 -0600 (CST) X-Virus-Scanned: amavisd-new at zimbra.int.journyx.com Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id hoInSs3a8o+p for ; Thu, 26 Feb 2009 12:15:11 -0600 (CST) Received: from whitneys (dhcp-100-188.int.journyx.com [192.168.100.188]) by mail.int.journyx.com (Postfix) with ESMTP id 753757E41C4 for ; Thu, 26 Feb 2009 12:15:11 -0600 (CST) From: "Scott Whitney" To: Subject: max_connections from database Date: Thu, 26 Feb 2009 12:17:02 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 Thread-Index: AcmYPmwL8DEqQzf8Qx+qxzWvcS00UQ== Message-Id: <20090226181511.753757E41C4@mail.int.journyx.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/245 X-Sequence-Number: 31466 So, I got pretty close to my max_connections setting, and I had to up it last night. I did so, and I issued a pg_ctl reload. Everything _seems_ happy. However, the script I use to monitor this has the number hard-coded in it (well, it looks it up from the conf file, anyway), and I'd rather get the current runtime parameter from the db. Anyone know where that bad boy lives?