replication consistency checking

From: hydra <hydrapolic(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: replication consistency checking
Date: 2015-06-04 04:49:31
Message-ID: CAG6MAzRaONc703e1PLQZig9PZVuOeLBr=Cc_CsK9ewr-hXbAag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

After setting up streaming replication, is it possible to check whether the
slave has the same data as the master?

In the MySQL world there is the percona-toolkit with pt-table-checksum that
does this job:
https://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html

Thank you

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Venkata Balaji N 2015-06-04 06:27:48 Re: replication consistency checking
Previous Message Tom Lane 2015-06-03 21:12:13 Re: pset, NULL, and COPY-reporting