Re: Switching timeline over streaming replication

From: Joshua Berkus <josh(at)agliodbs(dot)com>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Thom Brown <thom(at)linux(dot)com>
Subject: Re: Switching timeline over streaming replication
Date: 2012-12-20 22:12:45
Message-ID: 1878073001.154713.1356041565895.JavaMail.root@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-12-20 22:17:25 Re: pg_top
Previous Message Andres Freund 2012-12-20 22:10:48 Re: Feature Request: pg_replication_master()