Re: max_connections from database

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Scott Whitney" <swhitney(at)journyx(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: max_connections from database
Date: 2009-02-26 18:34:23
Message-ID: 49A68C4F.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>> "Scott Whitney" <swhitney(at)journyx(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message DM 2009-02-26 20:02:03 Pgpool Issue-
Previous Message Fujii Masao 2009-02-26 18:30:18 Re: max_connections from database