Horton

Re: Streaming replication and WAL archive interactions

Robert Haas <robertmhaas@gmail.com>

View thread
From: Robert Haas <robertmhaas@gmail.com>
To: hlinnaka <hlinnaka@iki.fi>
Cc: Michael Paquier <michael.paquier@gmail.com>, Venkata Balaji N <nag1010@gmail.com>, Andres Freund <andres@anarazel.de>, Fujii Masao <masao.fujii@gmail.com>, Borodin Vladimir <root@simply.name>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2015-04-22T18:30:48Z
Lists: pgsql-hackers 
On Wed, Apr 22, 2015 at 2:17 AM, Heikki Linnakangas <hlinnaka@iki.fi> wrote:
> Note that it's a bit complicated to set up that scenario today. Archiving is
> never enabled in recovery mode, so you'll need to use a custom cron job or
> something to maintain the archive that C uses. The files will not
> automatically flow from B to the second archive. With the patch we're
> discussing, however, it would be easy: just set archive_mode='always' in B.

Hmm, I see.  But if C never replays the last, partial segment from the
old timeline, how does it follow the timeline switch?

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