<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html>
<head></head>
<body>
<div>
<div>hello,</div>
<div><br></div>
<div>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.</div>
<div>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.</div>
<div>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 </div>
<div><br></div>
<div>s1 <span class="Apple-tab-span" style="white-space:pre"> </span>Up. Connected. Running as primary server<span class="Apple-tab-span" style="white-space: pre;"> </span>postgres: Up<span class="Apple-tab-span" style="white-space: pre;"> </span><br>
</div>
<div>s2 <span class="Apple-tab-span" style="white-space:pre"> </span>Up. Connected. Running as primary server<span class="Apple-tab-span" style="white-space: pre;"> </span>postgres: Up<span class="Apple-tab-span" style="white-space: pre;"> </span><br>
</div>
<div><br></div>
<div>tailing the postgres logs i see the same queries running on the same machines.</div>
<div>EET LOG: statement: SELECT pg_is_in_recovery()<br>
</div>
<div><br></div>
<div>changes i make on pgpool server effect the first primary but does not effect the second.</div>
<div><br></div>
<div>i followed the tatsuo sensei’s tutorial on (<a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/" style="color: rgb(0, 128, 255);">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/</a>) and the actual manual page for online recovery.</div>
<div><br></div>
<div>any advices?</div>
<div><br></div>
<div>thanks in advance.</div>
</div>
<div><br></div>
<div><br></div>
<div class="unibox-signature">Özgür Köy<br>
</div>
</body>
</html>