Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

There is some tool for mysql (from percona I think) which could compare databases by making md5 sums of tables data. We used it in our mysql replication system to check if data is correctly replicated. Do you know something similar that I can use in pgsql environment ?

share|improve this question

migrated from Nov 1 '12 at 23:56

This question came from our site for system and network administrators.

I'm not aware of any such tool. It'd be fairly simple to write one using the strategy you describe, but it'd produce false negatives sometimes because of replication lag. – Craig Ringer Nov 1 '12 at 23:06

You could try pg_comparator. Also older version of pt-table-checksum (or mk-table-checksum) could compare pg data - but I wouldn't recommend these old versions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.