[pgpool-general: 7312] Re: Best way to remove node with pgpool and streaming replication
ishii at sraoss.co.jp
Sun Oct 11 20:53:42 JST 2020
> 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:
>>> 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
More information about the pgpool-general