pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmax_connections from database
4+ messages / 4 participants
[nested] [flat]
* max_connections from database
@ 2009-02-26 18:17 Scott Whitney <swhitney@journyx.com>
0 siblings, 3 replies; 4+ messages in thread
From: Scott Whitney @ 2009-02-26 18:17 UTC (permalink / raw)
To: pgsql-admin
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?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: max_connections from database
@ 2009-02-26 18:29 Joshua D. Drake <jd@commandprompt.com>
parent: Scott Whitney <swhitney@journyx.com>
2 siblings, 0 replies; 4+ messages in thread
From: Joshua D. Drake @ 2009-02-26 18:29 UTC (permalink / raw)
To: Scott Whitney <swhitney@journyx.com>; +Cc: 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@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: max_connections from database
@ 2009-02-26 18:30 Fujii Masao <masao.fujii@gmail.com>
parent: Scott Whitney <swhitney@journyx.com>
2 siblings, 0 replies; 4+ messages in thread
From: Fujii Masao @ 2009-02-26 18:30 UTC (permalink / raw)
To: Scott Whitney <swhitney@journyx.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: max_connections from database
@ 2009-02-26 18:34 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Scott Whitney <swhitney@journyx.com>
2 siblings, 0 replies; 4+ messages in thread
From: Kevin Grittner @ 2009-02-26 18:34 UTC (permalink / raw)
To: Scott Whitney <swhitney@journyx.com>; 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2009-02-26 18:34 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-02-26 18:17 max_connections from database Scott Whitney <swhitney@journyx.com>
2009-02-26 18:29 ` Joshua D. Drake <jd@commandprompt.com>
2009-02-26 18:30 ` Fujii Masao <masao.fujii@gmail.com>
2009-02-26 18:34 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox