Re: streaming replication: could not receive data from client: Connection reset by peer

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Anson Abraham *EXTERN*" <anson(dot)abraham(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: streaming replication: could not receive data from client: Connection reset by peer
Date: 2013-10-23 08:03:09
Message-ID: A737B7A37273E048B164557ADEF4A58B17C509DF@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Anson Abraham wrote:
> No client connecting to the slave. It's just streamed replication for HA. This occurs when the slave
> starts immediately. SSL is used. And as I mentioned the libraries are identical on both slave and
> master. Interestingly, another slave that replicates from master does not have this issue. The one
> difference between the two slaves, the slave w/ the message is a VM. But other master dbs i have w/
> slaves (that are VMs) and have no issues. So it's kind of odd, that this message occurs.

So, right when the slave starts, you get the message in the log, right?

Is there anything else in the log?

Is there anything in the master's log around that time?
Try to set log_connections=on and log_disconnections=on, then you
should at least see when the slave connects.

Could there be a firewall or something that filters or disconnects sessions?

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rémi Cura 2013-10-23 08:39:52 Re: [postgis-users] Error with "return query" ( "return next" working ) with custom type
Previous Message Rémi Cura 2013-10-23 07:59:37 Re: Count of records in a row