[GENERAL] Timeline switch problem with streaming replication with 3 nodes

2012-09-24 Thread Mads . Tandrup
Hi All I've set up a 3 postgresql nodes 1 master and 2 slaves. They have been configured for streaming replication with synchronous on. I've set up an virtual IP that points to the current master node. When I kill the master node. The slave that was synchronous gets promoted to master and gets

Re: [GENERAL] Timeline switch problem with streaming replication with 3 nodes

2012-09-24 Thread Stuart Bishop
On Mon, Sep 24, 2012 at 7:37 PM, mads.tand...@schneider-electric.com wrote: I've found a discussion (http://archives.postgresql.org/pgsql-general/2011-12/msg00553.php) on a similar issue a while back. They talk about sharing WAL files as the solution. But I thought that the idea with