Обсуждение: max_connections from database

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?

On Thu, 2009-02-26 at 12:17 -0600, Scott Whitney 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.
>
> 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

>
>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997

Hi,

On Fri, Feb 27, 2009 at 3:17 AM, 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.

max_connections can only be set at server start.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

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