Re: replication consistency checking

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: hydra <hydrapolic(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: replication consistency checking
Date: 2015-06-05 02:40:26
Message-ID: CAL_0b1s9ZE1=ZRVySGE-Q3jLJC4U_O1y_PzN-R1vUbnNb7hKhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Jun 3, 2015 at 9: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?
>
> 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(dot)ru(at)gmail(dot)com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message hydra 2015-06-05 04:33:17 Re: replication consistency checking
Previous Message Keith 2015-06-04 22:06:58 Re: Problem with Out of Memory and no more connecction possible