From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: validation of hot standby |
Date: | 2019-03-01 02:22:53 |
Message-ID: | 05c604c1-7226-9fdf-309c-bf6f3d95abbd@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Lewis | 2019-03-01 04:26:27 | Re: Overloaded && operator from intarray module prevents index usage. |
Previous Message | Ron | 2019-03-01 02:19:46 | Re: Overloaded && operator from intarray module prevents index usage. |