[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] max_connections from database
From:       "Kevin Grittner" <Kevin.Grittner () wicourts ! gov>
Date:       2009-02-26 18:34:23
Message-ID: 49A68C4F.EE98.0025.0 () wicourts ! gov
[Download RAW message or body]

>>> "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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]