Postgres Pro
Downloads
Home   >   mailing lists

Re: replication consistency checking - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: replication consistency checking
Date
Msg-id CAL_0b1s9ZE1=ZRVySGE-Q3jLJC4U_O1y_PzN-R1vUbnNb7hKhg@mail.gmail.com
Whole thread Raw
In response to replication consistency checking  (hydra <hydrapolic@gmail.com>)
Responses Re: replication consistency checking  (hydra <hydrapolic@gmail.com>)
List pgsql-admin
Tree view 
On Wed, Jun 3, 2015 at 9: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?
>
> 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

I believe you only need
http://www.postgresql.org/docs/9.4/static/app-initdb.html#APP-INITDB-DATA-CHECKSUMS.

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray.ru@gmail.com

pgsql-admin by date:

Previous
From: Keith
Date:
Subject: Re: Problem with Out of Memory and no more connecction possible
Next
From: hydra
Date:
Subject: Re: replication consistency checking