[pgpool-general: 7097] Re: How to split the DBs and delete a standby server and make it a standalone postgresql server

[Tatsuo Ishii]

> Hi,
> I have two postgresql servers with streaming replication, pgpool and
> pgAdmin. Now I have to split the DBs and I should delete a standby
> server and make it a standalone postgresql server. How can I bring up
> the previous standby server and make it standalone using the db
> already present, without having to recreate it (what was previously
> realdonly)?

1) edit pgpool.conf to remove the standby server (remove or commentout
backend_*1 lines).

2) stop PostgeSQL and Pgpool-II.

3) start the standby server

4) promote the standby server (pg_ctl promote). Now the server is a
standalone PostgreSQL.

5) if neccessary, start the primary PostgreSQL and Pgpool-II. You will
see only the primary PostgreSQL.

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