RE: Should walsernder check correctness of WAL records? - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: Should walsernder check correctness of WAL records?
Date
Msg-id TYAPR01MB299024C7E5DB0B965A5C5677FE310@TYAPR01MB2990.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Should walsernder check correctness of WAL records?  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Should walsernder check correctness of WAL records?  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
From: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
> Investigating one of customer's support cases I found out that walsender
> is not calculating WAL records CRC and send them to replicas without any
> checks.
> As a result damaged WAL record causes errors on all replicas:

IIUC, walsender tries hard to send WAL as fast as possible to reduce replication lag and transaction response time, so
itdoesn't try to peek each WAL record.  I think it's good.
 

In any case, the WAL can get corrupt during transmission, and writing and reading on the standby.  So, the standby
needsto check the WAL record CRC.
 


Regards
Takayuki Tsunakawa




pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Asynchronous Append on postgres_fdw nodes.
Next
From: Michael Paquier
Date:
Subject: Re: Should walsernder check correctness of WAL records?