<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt">Hi Tatsuo,<br><br>Thanks, for the answer but I have a pgpool native replication setup (not a master/slave with streaming replication).<br><div><span>Are my assuptions valid in such a scenario ?<br></span></div><div> </div><div>Regards,<br>Adrian Videanu</div><div><br></div> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Tatsuo Ishii <ishii@postgresql.org><br> <b><span style="font-weight: bold;">To:</span></b> videanuadrian@yahoo.com <br><b><span style="font-weight:
bold;">Cc:</span></b> pgpool-general@pgpool.net <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, January 24, 2014 12:47 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 2477] Re: native replication PITR problems<br> </font> </div> <div class="y_msg_container"><br>Hi,<br clear="none"><br clear="none">This week I am busy with working on my job. I just want to give a<br clear="none">short follow:<br clear="none"><br clear="none">> Hi all, <br clear="none">> <br clear="none">> just some clarifications : <br clear="none">> <br clear="none">> <br clear="none">> So, what I understand from here is that when I perform online recovery I <br clear="none">> should stop the stand-by pgpool server. <br clear="none"><br clear="none">Yes.<br clear="none"><br clear="none">> Also, on the primary server <br clear="none">> there should be no connections open left, and until the recovery is <br
clear="none">> performed, no other connections will be opened.<br clear="none"><br clear="none">Assuming you choose master/slave plus streaming replication mode,<br clear="none">no. The primary server can work as usual while performing the<div class="yqt4712696330" id="yqtfd45806"><br clear="none">recovery.<br clear="none"><br clear="none">> The entire cluster will <br clear="none">> be basically down when 2nd stage recovery process is running.<br clear="none">> Are these assumptions correct ?</div><br clear="none"><br clear="none">Again if I can assume you choose master/slave plus streaming<br clear="none">replication mode, no.<br clear="none"><br clear="none">First of all, you don't need to define 2nd stage recovery process. It<br clear="none">only needs for replication mode (replication_mode = on).<br clear="none"><br clear="none">Also while doing recovery, pgpool-II happily accepts new connections<br clear="none">from clients and even
executes DMLs, which will be sent to the primary<br clear="none">PostgreSQL. The modifications made to the database are recorded on the<br clear="none">WAL on the primary and will be forwarded to the standby which is being<br clear="none">recovered. Once the standby server boots up, it will replay the wal<br clear="none">log sent from the primary.<br clear="none"><br clear="none">Best regards,<br clear="none">--<br clear="none">Tatsuo Ishii<br clear="none">SRA OSS, Inc. Japan<br clear="none">English: <a shape="rect" href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br clear="none">Japanese: <a shape="rect" href="http://www.sraoss.co.jp/" target="_blank">http://www.sraoss.co.jp</a><div class="yqt4712696330" id="yqtfd37869"><br clear="none"></div><br><br></div> </div> </div> </div></body></html>