Re: Data Checksum feature and streaming replication

From: Martín Marqués <martin(at)2ndquadrant(dot)com>
To: Jack Douglas <jack(at)douglastechnology(dot)co(dot)uk>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Data Checksum feature and streaming replication
Date: 2014-05-30 12:43:53
Message-ID: CABeG9LtzngYBEiDOJvfo_O6v1NHxo_LPpPhU+Q3uPrwW4M__9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2014-05-24 8:54 GMT-03:00 Jack Douglas <jack(at)douglastechnology(dot)co(dot)uk>:
>
> If I’m using the Data Checksum feature (new to 9.3:
> https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.3#Data_Checksums),
> and in the event of a checksum failure on a replication master, will that
> corrupt data replicate to slaves or will replication halt. Does it depend on
> the setting of ignore_checksum_failure?

I think you got page checksum check confused with WAL CRC check.

There is a README in the source that explains page checksum (and there
is some information about WAL CRC):

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=src/backend/storage/page/README;hb=HEAD

--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Claudio Freire 2014-05-30 13:36:37 Re: Extended Prefetching using Asynchronous IO - proposal and patch
Previous Message Bruce Momjian 2014-05-30 12:00:44 Re: Error while upgrading from 8.4 to 9.3