How to check if databases are consistent in pgsql replication? 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 ?
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.