2016-11-17 12:19 GMT+13:00 Patrick B <patrickbake...@gmail.com>: > Would be possible to check the integrity between two database servers? > > Both servers are slaves (streaming replication + wal_files) but I believe > one of them, when recovered from wal_files in a fast outage we got, got > recovered not 100%. > > How could I check the data between both DB? > > I'm using Postgres 9.2 > Cheers >
As far as I could see, checksum is only allowed on Postgres 9.3? https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.3#Data_Checksums So can't use that! Any other ideas?