The following bug has been logged online:
Bug reference: 5851
Logged by: Mark
Email address: dvlhntr@gmail.com
PostgreSQL version: 9.0.2 x86_64
Operating system: CentOS release 5.5 (Final) | 2.6.18-194.17.1.el5 #1 SMP
X86_64
Description: ROHS (read only hot standby) needs to be restarted
manually in somecases.
Details:
getting a break down in streaming rep. my current work around is to restart
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 happened
with 9.0.2 twice now in a month.
2011-01-26 08:35:42 MST :: (postgres@10.80.2.89) LOG: could not receive
data
from client: Connection reset by peer
2011-01-26 08:35:42 MST :: (postgres@10.80.2.89) LOG: unexpected 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 hopefully
get a better idea of what is going on. nothing is being logged to the
standby. I can't find anything else to grab that shows this break down in
streaming rep that won't start back up.
This is a somewhat *long* distance replication over a 100mbit metro line. we
have had routing issues in the past and see replication fall behind but once
connectivity is restored we see it catch up, without a restart of the
standby.
probably only ships a few gig of changes a day.
these are production machines so I can't do too much playing around to try
and induce "issues"
PostgreSQL 9.0.2 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
(1 row)
is this a known issue ? I didn't see anything when I have the mailing list
archive a quick glance search that looked like this.
is there somewhere else I should be looking for more details into why this
is happening ?
I can post the configs if you all want them but nothing special is happening
w/ regards to them.
thank you,
Mark