Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 serverfault.com Nov 1 '12 at 23:56

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

2  
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

1 Answer 1

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

 
discard

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