pg_ctl vs full restart

[Allen Landsidel]

Here's maybe a silly question, but I haven't seen it asked or answered
so.. For those settings in the .conf file that say "this doesn't take
effect until the database is restarted".. does that mean that "pg_ctl
reload" also does not reload them?

I imagine the statement is specific, and means what it says, but I'm
curious anyway..

s'all for now.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[scott.marlowe]

On Wed, 29 Oct 2003, Allen Landsidel wrote:

Here's maybe a silly question, but I haven't seen it asked or answered
so.. For those settings in the .conf file that say "this doesn't take
effect until the database is restarted".. does that mean that "pg_ctl
reload" also does not reload them?

I imagine the statement is specific, and means what it says, but I'm
curious anyway..

Yep, a restart trumps a reload. I.e. things that need reloading will get
changed at restart as well, but things that need a restart won't get
changed during a reload.

Some things can only be set on the startup of the postmaster. i.e.
restart
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)