Postgres Pro
Downloads
Home   >   mailing lists

replication consistency checking - Mailing list pgsql-admin

From hydra
Subject replication consistency checking
Date
Msg-id CAG6MAzRaONc703e1PLQZig9PZVuOeLBr=Cc_CsK9ewr-hXbAag@mail.gmail.com
Whole thread Raw
Responses Re: replication consistency checking  (Venkata Balaji N <nag1010@gmail.com>)
Re: replication consistency checking  (Sergey Konoplev <gray.ru@gmail.com>)
Re: replication consistency checking  (Jan Lentfer <Jan.Lentfer@web.de>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pset, NULL, and COPY-reporting
Next
From: Venkata Balaji N
Date:
Subject: Re: replication consistency checking