master-> 2 hot standbys

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

In response to

Responses

Browse pgsql-general by date

  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