Re: Enabling archive_mode without restart - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Enabling archive_mode without restart
Date
Msg-id 490AE5C1.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Enabling archive_mode without restart  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Enabling archive_mode without restart
List pgsql-hackers
>>> "Joshua D. Drake" <jd@commandprompt.com> wrote: 
> It certainly makes more sense to do this:
> 
> archive_mode = on
> pg_ctl reload
> 
> archive_mode = off
> pg_ctl reload
> 
> versus
> 
> archive_command = '/path/to/really/long/archive/string'
> pg_ctl reload
> 
> archive_command = '/bin/true'
> pg_ctl reload
Hmmm...  If there's no significant performance difference between
archive_mode = on
archive_command = '/bin/true'
and
archive_mode = off
archive_command = '/archive/command/used/during/snapshot/backups'
I could live with diddling the command to control archiving.
It doesn't log anything extra when archive_mode is on?
Why is it safer to change archive_command to a no-op on the fly than
to turn off archive mode?
-Kevin


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Window Functions: patch for CommitFest:Nov.
Next
From: David Fetter
Date:
Subject: Re: Window Functions: patch for CommitFest:Nov.