Re: replication consistency checking

On Thu, Jun 4, 2015 at 8:27 AM, Venkata Balaji N <nag1010(at)gmail(dot)com> wrote:

>
>
> On Thu, Jun 4, 2015 at 2:49 PM, hydra <hydrapolic(at)gmail(dot)com> wrote:
>
>> After setting up streaming replication, is it possible to check whether
>> the slave has the same data as the master?
>>
>>
> Yes. There are quite a few ways to check the sync status between master
> and standby. Which version of PostgreSQL are you using by the way ?
>
> Generally, you can easily build some scripts and schedule them in cron to
> check the status. You can use functions or catalog views to monitor the
> status, this depends on the version of PG you are using.
>
> You can also use tools like "repmgr" to monitor and manage replication. I
> am not 100% sure how good or efficient it is.
>
> Regards,
> Venkata Balaji N
>
> Fujitsu Australia
>
>
Thanks for the answer, however I'm looking for a data consistency check.

That means, you deploy your master standby replication, you're happily
running it and after 3 months you decide to do a failover. How can one be
sure the data are the same?

I'm running PostgreSQL 9.4.