master-> 2 hot standbys - Mailing list pgsql-general

From Julie Nishimura
Subject master-> 2 hot standbys
Date
Msg-id BYAPR08MB50146E87789FA8EAFC340B05AC710@BYAPR08MB5014.namprd08.prod.outlook.com
Whole thread Raw
In response to validation of hot standby  (Julie Nishimura <juliezain@hotmail.com>)
Responses Re: master-> 2 hot standbys  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
Hello,
Our current master 9.2 has two active standbys. Can you please help me out with the right sequence of events if we would like to promote one of current standbys to master and convert master to standby?

Your help is appreciated.

Thanks,
Julie


From: Julie Nishimura
Sent: Thursday, February 28, 2019 6:00 PM
To: pgsql-general@lists.postgresql.org
Subject: validation of hot standby
 
Hello,
We set up our hot standby by putting master into archive mode and issuing pg_basebackup command, and we are about to start our hot standby instance. What are the things you suggest for validation (assuming it will come up cleanly) and replication caught up?

What do I need to check in addition, making sure the data is clean and not corrupted?

thanks for your help

pgsql-general by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Question about pg_upgrade from 9.2 to X.X
Next
From: Perumal Raj
Date:
Subject: Re: Question about pg_upgrade from 9.2 to X.X