recovery lag question

From: John Lister <john(dot)lister(at)kickstone(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: recovery lag question
Date: 2009-11-12 18:04:30
Message-ID: 4AFC4E2E.1070906@kickstone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, I've set up a warm standby box with postgresql 8.3.8 and pg_standby.
Everything seems to be ok except and 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 (about 30) 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.

Thanks

John

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Lister 2009-11-12 18:40:32 recovery lag question
Previous Message Tom Lane 2009-11-12 15:45:45 Re: recovery is stuck when children are not processing SIGQUIT from previous crash