[GENERAL] warm standby and reciprocating failover

2009-08-24 Thread james bardin
I wasn't sure which list is better suited, so this is cross posted from pgsql-admin. -Thanks On Fri, Aug 21, 2009 at 10:46 AM, james bardin wrote: > I have a working warm standby system, running 8.4 (thanks for urging > me to upgrade from the rehdat provided release). >

Re: [GENERAL] warm standby and reciprocating failover

2009-08-25 Thread james bardin
On Mon, Aug 24, 2009 at 12:45 PM, james bardin wrote: >> >> I tried recovery_target_timeline='X' on the standby, where X is the >> new timeline created after recovery on the new master. This fails, >> with some "unexpected timeline ID" lines and a &g

[GENERAL] Verifying a PITR

2009-09-04 Thread james bardin
What would be the best way to verify that a PITR came up with *all* the expected data? This is mostly for a controlled failover, where I manually bring down the primary server, and shouldn't ever lose a transaction. If I need to use something like txid_current(), how do I ensure that it's the last