[pgpool-general: 7311] Re: Best way to remove node with pgpool and streaming replication

Anssi Kanninen anssi at iki.fi
Sun Oct 11 14:25:00 JST 2020


How about also:
- If you use streaming replication, drop the replication slots on the primary PostgreSQL.
- Remove all references of remote pgpool on the master Pgpool config and restart Pgpool.

On 11 October 2020 03:13:53 EEST, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> Hi,
>> I have 2 node with pgpool and postgresql in streaming replication.
>> Now I need to remove a node because I need server.
>> What is the best way to disable pgpool and postgresql streaming
>> replication from secondary server, without stop service on primary
>> master node?
>> Please, let me do as soon as possible.
>> Thanks!
>> Best regards.
>
>Assuming there's already nobody who is accessing pgpool:
>
>1) stop the pgpool
>2) stop the standby server
>
>If you setup synchronous replication, you need to restart the primary
>server after removing the standby server's name in
>synchronous_standby_names.
>
>Best regards,
>--
>Tatsuo Ishii
>SRA OSS, Inc. Japan
>English: http://www.sraoss.co.jp/index_en.php
>Japanese:http://www.sraoss.co.jp
>_______________________________________________
>pgpool-general mailing list
>pgpool-general at pgpool.net
>http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20201011/01a8b72f/attachment.html>


More information about the pgpool-general mailing list