[pgpool-general: 7311] Re: Best way to remove node with pgpool and streaming replication
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:
>> 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.
>> 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
>SRA OSS, Inc. Japan
>pgpool-general mailing list
>pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general