On 2/28/19 8:00 PM, Julie Nishimura wrote:
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.
