Postgres Pro
Downloads
Home   >   mailing lists

Re: Data Checksum feature and streaming replication - Mailing list pgsql-general

From Martín Marqués
Subject Re: Data Checksum feature and streaming replication
Date
Msg-id CABeG9LtzngYBEiDOJvfo_O6v1NHxo_LPpPhU+Q3uPrwW4M__9g@mail.gmail.com
Whole thread Raw
In response to Data Checksum feature and streaming replication  ("Jack Douglas" <jack@douglastechnology.co.uk>)
List pgsql-general
Tree view 
2014-05-24 8:54 GMT-03:00 Jack Douglas <jack@douglastechnology.co.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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Error while upgrading from 8.4 to 9.3
Next
From: Tom Lane
Date:
Subject: Re: Fwd: libpq: indefinite block on poll during network problems