[pgpool-hackers: 708] multiple primary servers on pgpool

[Özgür Köy]

  hello,


i am setting up a master-slave with streaming on a 3 server set. that is 1 pg pool(3.4) and 2 9.3 postgres servers. There’s a pgpooladmin running on the pgpool server.
i setup a pitr online recovery , and touched a few things on pgpooladmin and all seems well except i see two primary servers on my node status page.
i removed failover script from pgpool configuration, tried playing with the weight of the servers, stopping one then recovering it by pgpooladmin interface but it always ends up with 2 servers showing 


s1   	Up. Connected. Running as primary server	postgres: Up	

s2  	Up. Connected. Running as primary server	postgres: Up	



tailing the postgres logs i see the same queries running on the same machines.
EET LOG:  statement: SELECT pg_is_in_recovery()



changes i make on pgpool server effect the first primary but does not effect the second.


i followed the tatsuo sensei’s tutorial on (http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/
) and the actual manual page for online recovery.


any advices?


thanks in advance.





Özgür Köy


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20141208/ccff9a88/attachment.html>