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

[Tatsuo Ishii]

> 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