On 2/28/19 8:00 PM, Julie Nishimura wrote:
P {margin-top:0;margin-bottom:0;} 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?
Run the program pg_controldata on the secondary server. Specifically look for the last checkpoint timestamp. It will lag some, depending on how checkpoint frequency is configured on the master.
What do I need to check in addition, making sure the data is clean and not corrupted?
thanks for your help
--
Angular momentum makes the world go 'round.