On Wed, Jun 3, 2015 at 9:49 PM, hydra <hydrapolic@xxxxxxxxx> 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@xxxxxxxxx -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin