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.
|
