Re: Enable WAL archiving even in standby - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Enable WAL archiving even in standby
Date
Msg-id CA+TgmoaK0-Pooip0SuEySYAS66Eau_urs0=AL1aj-wRB+DOEDw@mail.gmail.com
Whole thread Raw
In response to Enable WAL archiving even in standby  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Enable WAL archiving even in standby
List pgsql-hackers
On Wed, Aug 13, 2014 at 6:42 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> I'd propose the attached WIP patch which allows us to enable WAL archiving
> even in standby. The patch adds "always" as the valid value of archive_mode.
> If it's set to "always", the archiver is started when the server is in standby
> mode and all the WAL files that walreceiver wrote to the disk are archived by
> using archive_command. Then, even after the server is promoted to master,
> the archiver keeps archiving WAL files. The patch doesn't change the meanings
> of the setting values "on" and "off" of archive_mode.

I like the feature, but I don't much like this as a control mechanism.
Having archive_command and standby_archive_command, as you propose
further down, seems saner.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Immediate standby promotion
Next
From: Robert Haas
Date:
Subject: Re: ALTER TABLESPACE MOVE command tag tweak