Re: Check integrity between servers - Mailing list pgsql-general

From Venkata B Nagothi
Subject Re: Check integrity between servers
Date
Msg-id CAEyp7J-5yXFSJfK2kujq_9HzwTTO5vWFgh4Y7s+Lbad8FRctOg@mail.gmail.com
Whole thread Raw
In response to Check integrity between servers  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general

On Thu, Nov 17, 2016 at 10:19 AM, Patrick B <patrickbakerbr@gmail.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 

pgsql-general by date:

Previous
From: dhaval jaiswal
Date:
Subject: Re: pg_class (system) table increasing size.
Next
From: Yogesh Sharma
Date:
Subject: Re: Request to share information regarding deadlock in postgresql-9.3.6