Re: replication consistency checking - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: replication consistency checking
Date
Msg-id 20150611123904.GA19473@momjian.us
Whole thread Raw
In response to Re: replication consistency checking  (hydra <hydrapolic@gmail.com>)
Responses Re: replication consistency checking  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
On Thu, Jun 11, 2015 at 07:12:36AM +0200, hydra wrote:
>     I am entering this discussion a bit late, so maybe I am missing the point.
>     But SR is using xlog and there is a crc32 checksum on each xlog record. So
>     why would you need to compare the whole thing again when each record has
>     been approved during replication ?
>
>
>
> Hello Jan,
> you don't have it if you don't want to. However I'd like to have the
> possibility to do so and thus I was asking - is it possible? Are you guys doing
> it?
>
> The reasons are mentioned above, but still:
> - bugs can appear anywhere,
> - the bug report mentioned before also states to check the data, but does not
> give and hints how to do it, that's why I asked here

The answer is "no".

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


pgsql-admin by date:

Previous
From: hydra
Date:
Subject: Re: replication consistency checking
Next
From: Bruce Momjian
Date:
Subject: Re: replication consistency checking