Re: max_connections from database

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Scott Whitney <swhitney(at)journyx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: max_connections from database
Date: 2009-02-26 18:29:50
Message-ID: 1235672990.3671.29.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fujii Masao 2009-02-26 18:30:18 Re: max_connections from database
Previous Message Scott Whitney 2009-02-26 18:17:02 max_connections from database