Check integrity between servers

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Check integrity between servers
Date: 2016-11-16 23:19:02
Message-ID: CAJNY3ivJzCrAt+yxiy3RGe4g2goTRMzLz2pV+FOZnXxw-UYveQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Israel Brewster 2016-11-17 00:51:26 Streaming replication failover/failback
Previous Message Patrick B 2016-11-16 21:35:51 Re: Wal files being delayed - Pgsql 9.2