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

[Tatsuo Ishii]

> How about also:
> - If you use streaming replication, drop the replication slots on the primary PostgreSQL.

Good point. If replication slots are used.

> - Remove all references of remote pgpool on the master Pgpool config and restart Pgpool.

I thought there's only one Pgpool-II. If each server has Pgpool-II
running on, then yes it's needed.

> 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