<html><head>
<style id="css_styles" type="text/css"><!--blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc }
blockquote.cite2 {margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc; margin-top: 3px; padding-top: 0px; }
a img { border: 0px; }
li[style='text-align: center;'], li[style='text-align: right;'] { list-style-position: inside;}
body { font-family: Segoe UI; font-size: 12pt; }--></style></head><body class="plain"><div>Hi,</div><div>I have some questions, so I try to integrate your commands with other steps ... please, tell me if the following procedure is correct:</div><div><br /></div><div>1) edit pgpool.conf to remove the standby server (remove or commentout backend_*1 lines). <i><b>Both on primary and standby.</b></i><br /> <br />2) stop PostgeSQL and Pgpool-II. <b><i>Both on primary and standby?</i></b><br /> <br />3) start the standby server. </div><div><ul style="list-style-type: disc;"><li><b><i>Will I use the old standby without pgpool or will it necessarily be a new pgpool master with only one postgresql node? I really don't need pgpool this way anymore.</i></b></li><li><b style="font-size: 12pt;"><i>Should i also change the postgres.conf file with the original settings? Mush I change port from 5433 to 5432?</i></b></li></ul></div><div> <br />4) promote the standby server (pg_ctl promote). Now the server is a standalone PostgreSQL. <br /> <br />5) if neccessary, start the primary PostgreSQL and Pgpool-II. You will see only the primary PostgreSQL.</div><div id="signature_old"><div><ul style="list-style-type: disc;"><li><b><i>on the primary server should i leave pgpool or could i easily remove it and use only postgresql?</i></b></li></ul><div>Best regards.</div><div>Giancarlo</div><div><b><i><br /></i></b></div></div></div>
<div>------ Messaggio originale ------</div>
<div>Da: "Tatsuo Ishii" <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>></div>
<div>A: <a href="mailto:giancarlo.celli@flottaweb.com">giancarlo.celli@flottaweb.com</a></div>
<div>Cc: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a></div>
<div>Inviato: 19/06/2020 07:13:22</div>
<div>Oggetto: Re: [pgpool-general: 7096] How to split the DBs and delete a standby server and make it a standalone postgresql server</div><div><br /></div>
<div id="xac85313fa30e455"><blockquote type="cite" class="cite2">
<blockquote type="cite" class="cite">
<div class="plain_line"> Hi,</div>
<div class="plain_line"> I have two postgresql servers with streaming replication, pgpool and</div>
<div class="plain_line"> pgAdmin. Now I have to split the DBs and I should delete a standby</div>
<div class="plain_line"> server and make it a standalone postgresql server. How can I bring up</div>
<div class="plain_line"> the previous standby server and make it standalone using the db</div>
<div class="plain_line"> already present, without having to recreate it (what was previously</div>
<div class="plain_line"> realdonly)?</div>
</blockquote>
<div class="plain_line"> </div>
<div class="plain_line">1) edit pgpool.conf to remove the standby server (remove or commentout</div>
<div class="plain_line">backend_*1 lines).</div>
<div class="plain_line"> </div>
<div class="plain_line">2) stop PostgeSQL and Pgpool-II.</div>
<div class="plain_line"> </div>
<div class="plain_line">3) start the standby server</div>
<div class="plain_line"> </div>
<div class="plain_line">4) promote the standby server (pg_ctl promote). Now the server is a</div>
<div class="plain_line">standalone PostgreSQL.</div>
<div class="plain_line"> </div>
<div class="plain_line">5) if neccessary, start the primary PostgreSQL and Pgpool-II. You will</div>
<div class="plain_line">see only the primary PostgreSQL.</div>
<div class="plain_line"> </div>
<div class="plain_line">Best regards,</div>
<div class="plain_line">--</div>
<div class="plain_line">Tatsuo Ishii</div>
<div class="plain_line">SRA OSS, Inc. Japan</div>
<div class="plain_line">English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a></div>
<div class="plain_line">Japanese:<a href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a></div>
</blockquote></div>
</body></html>