| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Allen Landsidel <all(at)biosys(dot)net> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_ctl vs full restart |
| Date: | 2003-10-30 14:47:00 |
| Message-ID: | Pine.LNX.4.33.0310300745120.23153-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Guest | 2003-10-30 14:51:32 | formatting of SQL sent by PHP to postgres |
| Previous Message | scott.marlowe | 2003-10-30 14:38:29 | Re: Automatic auditing suggestion |