Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id C89A2632A33
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 26 Feb 2009 14:34:37 -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 89413-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 26 Feb 2009 14:34:34 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by mail.postgresql.org (Postfix) with ESMTP id 5762D6326D9
	for <pgsql-admin@postgresql.org>; Thu, 26 Feb 2009 14:34:34 -0400 (AST)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Thu, 26 Feb 2009 12:34:33 -0600
Message-Id: <49A68C4F.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.3 
Date: Thu, 26 Feb 2009 12:34:23 -0600
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Scott Whitney" <swhitney@journyx.com>,
	<pgsql-admin@postgresql.org>
Subject: Re: max_connections from database
References: <20090226181511.753757E41C4@mail.int.journyx.com>
In-Reply-To: <20090226181511.753757E41C4@mail.int.journyx.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200902/248
X-Sequence-Number: 31469

>>> "Scott Whitney" <swhitney@journyx.com> wrote: 
> 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.
 
It's not.  Note the comment:
 
# (change requires restart)
 
> 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?
 
show max_connections;
 
-Kevin