Hello Tom ,
Please let me know why we are getting below associated LOGS saying invalid resource manager with the FATAL message
Unableto receive data from WAL Stream Error
> sh: dev/null: No such file or directory
> sh: dev/null: No such file or directory < 2018-02-19 01:37:48.860 CST
> > LOG: invalid resource manager ID 48 at
> 15/2D69E848
Please kindly suggest us a value for tcp_keepalives_idle as it is presently set to 0
Thank you
Mahesh Kolla
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, February 22, 2018 12:19 PM
To: Kolla, Mahesh <Mahesh.Kolla@transunion.com>
Cc: Eric Radman <ericshane@eradman.com>; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15078: Unable to receive data from WAL Stream Error
"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 but we 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
networkinfrastructure, you could try enabling TCP keepalives (with a shorter repeat interval than the default) on the
replicationconnections.
regards, tom lane