| 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: | Whole Thread | Raw Message | 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. |