On Wed, Jan 26, 2011 at 8:24 PM, Mark <dvlhntr@gmail.com> wrote:
> getting a break down in streaming rep. my current work around is to resta=
rt
> the PG instance on the ROHS. doesn't seem to affect the master any. doesn=
't
> require a re-rsync of the base to get replication going again. has happen=
ed
> with 9.0.2 twice now in a month.
>
>
>
> 2011-01-26 08:35:42 MST :: (postgres@10.80.2.89) LOG: =A0could not receive
> data
> from client: Connection reset by peer
> 2011-01-26 08:35:42 MST :: (postgres@10.80.2.89) LOG: =A0unexpected EOF on
> standby connection
>
> this was all I have in the master's log with the level set to debug 1, I
> have reset it to debug 5 and will just wait till it dies again and hopefu=
lly
> get a better idea of what is going on. nothing is being logged to the
> standby.
Maybe a break in network connectivity is leading the master to think
that the slave is dead, while the slave still thinks it's connected.
You might need to adjust the TCP keepalive parameters the slave uses
to connect to the master.
--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company