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

[Giancarlo Celli]

Hi,
I have some questions, so I try to integrate your commands with other 
steps ... please, tell me if the following procedure is correct:

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

2) stop PostgeSQL and Pgpool-II. Both on primary and standby?

3) start the standby server.
Will I use the old standby without pgpool or will it necessarily be a 
new pgpool master with only one postgresql node? I really don't need 
pgpool this way anymore.Should i also change the postgres.conf file with 
the original settings? Mush I change port from 5433 to 5432?

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.
on the primary server should i leave pgpool or could i easily remove it 
and use only postgresql?
Best regards.
Giancarlo

------ Messaggio originale ------
Da: "Tatsuo Ishii" <ishii at sraoss.co.jp>
A: giancarlo.celli at flottaweb.com
Cc: pgpool-general at pgpool.net
Inviato: 19/06/2020 07:13:22
Oggetto: Re: [pgpool-general: 7096] How to split the DBs and delete a 
standby server and make it a standalone postgresql server

>>  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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200619/d2fee0f7/attachment.html>