From: | Julie Nishimura <juliezain(at)hotmail(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | master-> 2 hot standbys |
Date: | 2019-03-04 21:59:13 |
Message-ID: | BYAPR08MB50146E87789FA8EAFC340B05AC710@BYAPR08MB5014.namprd08.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)lists(dot)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Perumal Raj | 2019-03-04 22:21:11 | Re: Question about pg_upgrade from 9.2 to X.X |
Previous Message | Justin Pryzby | 2019-03-04 21:45:01 | Re: Question about pg_upgrade from 9.2 to X.X |