pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: hydra <hydrapolic@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: replication consistency checking
Date: Thu, 4 Jun 2015 10:47:03 +0200
Message-ID: <CAG6MAzS7vJY48GBdMeajahuvXjEMd43EePipeOMP9APbNGFcdQ@mail.gmail.com> (raw)
In-Reply-To: <CAEyp7J_ccGRLXnb6-qB2R=-fgUc7OUYLGSvhupRbshXbsVWuYQ@mail.gmail.com>
References: <CAG6MAzRaONc703e1PLQZig9PZVuOeLBr=Cc_CsK9ewr-hXbAag@mail.gmail.com>
	<CAEyp7J_ccGRLXnb6-qB2R=-fgUc7OUYLGSvhupRbshXbsVWuYQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

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

>
>
> On Thu, Jun 4, 2015 at 2:49 PM, hydra <hydrapolic@gmail.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.

view thread (34+ messages)  latest in thread

Message-ID: <CAG6MAzS7vJY48GBdMeajahuvXjEMd43EePipeOMP9APbNGFcdQ@mail.gmail.com>
Permalink:  ../CAG6MAzS7vJY48GBdMeajahuvXjEMd43EePipeOMP9APbNGFcdQ@mail.gmail.com/
Also on:    postgresql.org/message-id/CAG6MAzS7vJY48GBdMeajahuvXjEMd43EePipeOMP9APbNGFcdQ@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: hydrapolic@gmail.com
  Subject: Re: replication consistency checking
  In-Reply-To: <CAG6MAzS7vJY48GBdMeajahuvXjEMd43EePipeOMP9APbNGFcdQ@mail.gmail.com>
  References: <CAG6MAzRaONc703e1PLQZig9PZVuOeLBr=Cc_CsK9ewr-hXbAag@mail.gmail.com> <CAEyp7J_ccGRLXnb6-qB2R=-fgUc7OUYLGSvhupRbshXbsVWuYQ@mail.gmail.com> <CAG6MAzS7vJY48GBdMeajahuvXjEMd43EePipeOMP9APbNGFcdQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox