Re: max_connections from database - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: max_connections from database
Date
Msg-id 49A68C4F.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to max_connections from database  ("Scott Whitney" <swhitney@journyx.com>)
List pgsql-admin
>>> "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

pgsql-admin by date:

Previous
From: Fujii Masao
Date:
Subject: Re: max_connections from database
Next
From: DM
Date:
Subject: Pgpool Issue-