[pgpool-general: 7097] Re: How to split the DBs and delete a standby server and make it a standalone postgresql server
ishii at sraoss.co.jp
Fri Jun 19 14:13:22 JST 2020
> 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
1) edit pgpool.conf to remove the standby server (remove or commentout
2) stop PostgeSQL and Pgpool-II.
3) start the standby server
4) promote the standby server (pg_ctl promote). Now the server is a
5) if neccessary, start the primary PostgreSQL and Pgpool-II. You will
see only the primary PostgreSQL.
SRA OSS, Inc. Japan
More information about the pgpool-general