[pgpool-hackers: 708] multiple primary servers on pgpool
Özgür Köy
ozgur.koy at gmail.com
Mon Dec 8 21:19:19 JST 2014
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>
More information about the pgpool-hackers
mailing list