Re: [Pacemaker] postgresql failover

2013-08-19 Thread Takatoshi MATSUO
Hi Gregg Jaskiewicz 2013/8/16 Gregg Jaskiewicz : > Running rsync -avzPc -e 'ssh -o UserKnownHostsFile=/dev/null' > --delete-during 10.0.1.100:/var/lib/pgsql/9.2/data/pg_archive > /var/lib/pgsql/9.2/data/ > on each slave fixes it - but question then is - why cannot this be done > automatically by R

Re: [Pacemaker] postgresql failover

2013-08-16 Thread Gregg Jaskiewicz
Running rsync -avzPc -e 'ssh -o UserKnownHostsFile=/dev/null' --delete-during 10.0.1.100:/var/lib/pgsql/9.2/data/pg_archive /var/lib/pgsql/9.2/data/ on each slave fixes it - but question then is - why cannot this be done automatically by RA ? Andrew on irc suggested I use restart_on_promote, but

[Pacemaker] postgresql failover

2013-08-15 Thread Gregg Jaskiewicz
Hey folks, Following few battles with the thing - I managed to get pgsql RA to run on 4 nodes, it's all great, however... When testing the failover, I unplugged the 'master' machine, the slaves are getting sorted out, new master is elected, however the slaves now don't reconnect to the new master.