<html><head></head><body>How about also:<br>- If you use streaming replication, drop the replication slots on the primary PostgreSQL.<br>- Remove all references of remote pgpool on the master Pgpool config and restart Pgpool.<br><br><div class="gmail_quote">On 11 October 2020 03:13:53 EEST, Tatsuo Ishii <ishii@sraoss.co.jp> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">Hi,<br>I have 2 node with pgpool and postgresql in streaming replication.<br>Now I need to remove a node because I need server.<br>What is the best way to disable pgpool and postgresql streaming<br>replication from secondary server, without stop service on primary<br>master node?<br>Please, let me do as soon as possible.<br>Thanks!<br>Best regards.<br></blockquote><br>Assuming there's already nobody who is accessing pgpool:<br><br>1) stop the pgpool<br>2) stop the standby server<br><br>If you setup synchronous replication, you need to restart the primary<br>server after removing the standby server's name in<br>synchronous_standby_names.<br><br>Best regards,<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>Japanese:http://www.sraoss.co.jp<hr>pgpool-general mailing list<br>pgpool-general@pgpool.net<br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></pre></blockquote></div></body></html>