| Lists: | pgsql-general |
|---|
| From: | "Jack Douglas" <jack(at)douglastechnology(dot)co(dot)uk> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Data Checksum feature and streaming replication |
| Date: | 2014-05-24 11:54:28 |
| Message-ID: | 001601cf7746$eae388b0$c0aa9a10$@douglastechnology.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| 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 |
| 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):
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services