On 11/12/2014 10:06 AM, Robert Haas wrote: >> hat *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. > I'm not sure what's going on here, but keep in mind that when you > restart the replica, it's going to back up to the most recent > restartpoint and begin replication from there, not from the point it > was at when you shut down.
Except that in the problem case, it appears to be going *forwards*. What would cause that? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers