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

Tatsuo Ishii ishii at sraoss.co.jp
Sun Oct 11 09:13:53 JST 2020

> 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

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list