This is a multi-part message in MIME format.
------=_NextPart_000_0005_01CA63C7.9D516780
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi, I've set up a warm standby box with postgresql 8.3.8 and pg_standby. =
Everything seems to be ok, the wal files are being copied across and =
being processed during the recovery as you'd expect but I have one =
question. The recovery seems to be processing the final wal files at the =
same rate as they are generated, which is approximately every 6 minutes. =
This means that it is currently lagging behind the primary by about 3 =
hours. I assumed that the recovery would process the wal files as fast =
as possible until it caught up and then waited, there appears to be no =
load on the secondary server so I'm guessing it is sat waiting but i may =
be wrong. Is this the correct behaviour or is something else going on?
Thanks
John
--
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/
------=_NextPart_000_0005_01CA63C7.9D516780
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18852">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2 face=3DArial><FONT size=3D3 face=3D"Times New =
Roman"></FONT>
<DIV style=3D"FONT-FAMILY: -moz-fixed; FONT-SIZE: 13px" lang=3Dx-western =
class=3Dmoz-text-flowed>Hi, I've set up a warm standby box with =
postgresql 8.3.8
and pg_standby. Everything seems to be ok, the wal files are being =
copied across
and being processed during the recovery as you'd expect but I have one =
question.
The recovery seems to be processing the final wal files at the same rate =
as they
are generated, which is approximately every 6 minutes. This means that =
it is
currently lagging behind the primary by about 3 hours. I assumed that =
the
recovery would process the wal files as fast as possible until it caught =
up and
then waited, there appears to be no load on the secondary server so I'm =
guessing
it is sat waiting but i may be wrong. Is this the correct behaviour or =
is
something else going on?<BR><BR>Thanks <BR><BR>John <BR></FONT><FONT =
size=3D2
face=3DArial>--</FONT></DIV></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2 face=3DArial>Got needs? Get Goblin'! - <A
href=3D"http://www.pricegoblin.co.uk/">http://www.pricegobli n.co.uk/</A><=
BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_0005_01CA63C7.9D516780--
