Re: [GENERAL] Data Checksum feature and streaming replication

[Martín Marqués]

2014-05-24 8:54 GMT-03:00 Jack Douglas j...@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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Data Checksum feature and streaming replication

[Jack Douglas]

I posted this question on dba.se (http://dba.stackexchange.com/q/65821/1396)
and was advised to try asking here.

 

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_Checksu
ms), 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?

 

Thanks

Jack