<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html>
<head></head>
<body>
<div>Yes tatsuo sama, you were right. I fixed and it’s looking good now. thanks a lot.</div>
<div><br></div>
<div><br></div>
<div class="unibox-signature">Özgür Köy<br>
</div>
<div><br></div>
<blockquote type="cite" class="unibox-hidden">
<div>On Dec 9, 2014, at 1:22 AM, Tatsuo Ishii <ishii@postgresql.org> wrote:</div>
<div><br></div>
<div>It seems there's something wrong with your recovery script, or any<br>other settings. Apparently you failed to create the standby<br>node. Please show pgpool log, PostgreSQL log of the first primary when<br>you execute online recovery.</div>
<div><br></div>
<div>Best regards,<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: http://www.sraoss.co.jp/index_en.php<br>Japanese:http://www.sraoss.co.jp</div>
<div><br></div>
<blockquote>
<div style="orphans: auto; text-align: start; widows: auto;">hello,</div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">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.<br>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.<br>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 style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">s1 Up. Connected. Running as primary server postgres: Up </div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">s2 Up. Connected. Running as primary server postgres: Up </div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">tailing the postgres logs i see the same queries running on the same machines.<br>EET LOG: statement: SELECT pg_is_in_recovery()</div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">changes i make on pgpool server effect the first primary but does not effect the second.</div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">i followed the tatsuo sensei’s tutorial on (http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/<br>) and the actual manual page for online recovery.</div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">any advices?</div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">thanks in advance.</div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">Özgür Köy</div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<br class="Apple-interchange-newline">
</blockquote>
</blockquote>
</body>
</html>