pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedquestion on pg_ctl
3+ messages / 2 participants
[nested] [flat]
* question on pg_ctl
@ 2008-09-22 17:49 Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Tena Sakai @ 2008-09-22 17:49 UTC (permalink / raw)
To: pgsql-admin
Hi Everybody,
I want to change a line in postgresql.conf (shared_buffers)
and then issue a command:
pg_ctl reload
This forces the postmaster process to reread the configuration
file with new shared_buffer value. And the postgres process
that comes to life from this point on will execute with the
newly specified value. Correct?
I have jobs that have been running more than a week. Can somebody
please tell me what happens to these processes? Ie., (a) will they
keep running in the current mode? (b) will the postmaster assign
more memory while they are running?
Thank you.
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: question on pg_ctl
@ 2008-09-22 18:21 Scott Marlowe <scott.marlowe@gmail.com>
parent: Tena Sakai <tsakai@gallo.ucsf.edu>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Marlowe @ 2008-09-22 18:21 UTC (permalink / raw)
To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: pgsql-admin
On Mon, Sep 22, 2008 at 11:49 AM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> Hi Everybody,
>
> I want to change a line in postgresql.conf (shared_buffers)
> and then issue a command:
> pg_ctl reload
>
> This forces the postmaster process to reread the configuration
> file with new shared_buffer value. And the postgres process
> that comes to life from this point on will execute with the
> newly specified value. Correct?
To quote the postgresql.conf file:
shared_buffers = 150MB # min 128kB or max_connections*16kB
# (change requires restart)
So it requires a complete restart. Note that for the things you can
reload on, there's no real effect on running queries or connections
(at least no detrimental ones I can think of.)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: question on pg_ctl
@ 2008-09-22 18:40 Tena Sakai <tsakai@gallo.ucsf.edu>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Tena Sakai @ 2008-09-22 18:40 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin
Many thanks, Scott!
Tena
-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Mon 9/22/2008 11:21 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] question on pg_ctl
On Mon, Sep 22, 2008 at 11:49 AM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> Hi Everybody,
>
> I want to change a line in postgresql.conf (shared_buffers)
> and then issue a command:
> pg_ctl reload
>
> This forces the postmaster process to reread the configuration
> file with new shared_buffer value. And the postgres process
> that comes to life from this point on will execute with the
> newly specified value. Correct?
To quote the postgresql.conf file:
shared_buffers = 150MB # min 128kB or max_connections*16kB
# (change requires restart)
So it requires a complete restart. Note that for the things you can
reload on, there's no real effect on running queries or connections
(at least no detrimental ones I can think of.)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-09-22 18:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-22 17:49 question on pg_ctl Tena Sakai <tsakai@gallo.ucsf.edu>
2008-09-22 18:21 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-22 18:40 ` Tena Sakai <tsakai@gallo.ucsf.edu>
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