Re: Switching timeline over streaming replication

Josh Berkus <josh@agliodbs.com>

From: Joshua Berkus <josh@agliodbs.com>
To: Heikki Linnakangas <hlinnakangas@vmware.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>, Thom Brown <thom@linux.com>
Date: 2012-12-20T22:12:45Z
Lists: pgsql-hackers

> I just committed a patch that should make the "requested WAL segment
> 000000020000000000000003 has already been removed" errors go away.
> The
> trick was for walsenders to not switch to the new timeline until at
> least one record has been replayed on it. That closes the window
> where
> the walsender already considers the new timeline to be the latest,
> but
> the WAL file has not been created yet.

OK, I'll download the snapshot in a couple days and make sure this didn't breaks something else.

--Josh