| From: | Venkata B Nagothi <nag1010(at)gmail(dot)com> |
|---|---|
| To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Check integrity between servers |
| Date: | 2016-11-17 06:07:09 |
| Message-ID: | CAEyp7J-5yXFSJfK2kujq_9HzwTTO5vWFgh4Y7s+Lbad8FRctOg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Nov 17, 2016 at 10:19 AM, Patrick B <patrickbakerbr(at)gmail(dot)com>
wrote:
> Would be possible to check the integrity between two database servers?
>
> Both servers are slaves (streaming replication + wal_files) but I believe
> one of them, when recovered from wal_files in a fast outage we got, got
> recovered not 100%.
>
Did you mean to say recovery is not successful or complete ? How did you
know that recovery is not 100% ? Any errors, messages etc ?
> How could I check the data between both DB?
>
That is something which Application needs to do. From database perspective
you can check if the databases are in complete sync.
Regards,
Venkata B N
Database Consultant
Fujitsu Australia
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amul Sul | 2016-11-17 06:15:41 | Re: Exclude pg_largeobject form pg_dump |
| Previous Message | dhaval jaiswal | 2016-11-17 03:08:52 | Re: pg_class (system) table increasing size. |