Re: recovery_target_time and standby_mode

On 11/07/2014 02:03 PM, Josh Berkus wrote:
> But, like I said, there's a serviceable workaround.

Some update on this.  We've seen a problem in production with this setup
which I can't reproduce as a test case, but which may jog Heikki's
memory for something to fix.

1. Recover master to 2014-11-10 12:10:00
2. Recover replica to 2014-11-10 12:10:00,  with pause_at_recovery_target
3. reconfigure recovery.conf for streaming replication  and restart the replica
4. get a fatal error for replication, because  the replica is ahead of the master on timeline1

What *appears* to be happening is that the pause_at_recovery_target,
followed by the restart, on the replica causes it to advance one commit
on timeline 1.  But *not all the time*; this doesn't happen in my
pgbench-based tests.

There's a workaround for the user (they just restore the replica to 5
minutes earlier), but I'm thinking this is a minor bug somewhere.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com