Re: BUG #15078: Unable to receive data from WAL Stream Error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15078: Unable to receive data from WAL Stream Error
Date
Msg-id 22119.1519323567@sss.pgh.pa.us
Whole thread Raw
In response to RE: BUG #15078: Unable to receive data from WAL Stream Error  ("Kolla, Mahesh" <Mahesh.Kolla@transunion.com>)
Responses RE: BUG #15078: Unable to receive data from WAL Stream Error
RE: BUG #15078: Unable to receive data from WAL Stream Error
List pgsql-bugs
"Kolla, Mahesh" <Mahesh.Kolla@transunion.com> writes:
> Thank you for the response. Primary is accepting the ssl connections .Stand by is in sync with primary all the time
butwe receive FATALS sometimes 3 to 4 times a day which make us worry if having any data corruption  

I doubt this is a PG bug; it sounds more like a networking problem.
Maybe there's a router or firewall in between that is timing out your
connections too easily.  If you can't adjust the network infrastructure,
you could try enabling TCP keepalives (with a shorter repeat
interval than the default) on the replication connections.

            regards, tom lane


pgsql-bugs by date:

Previous
From: "Kolla, Mahesh"
Date:
Subject: RE: BUG #15078: Unable to receive data from WAL Stream Error
Next
From: "Kolla, Mahesh"
Date:
Subject: RE: BUG #15078: Unable to receive data from WAL Stream Error