Re: Hot Standby has PANIC: WAL contains references to invalid pages

From: Michael Harris <michael(dot)harris(at)ericsson(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>, amutu <zhao6014(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Hot Standby has PANIC: WAL contains references to invalid pages
Date: 2013-02-18 03:31:32
Message-ID: 30BC62DC16C7B842A8446ED8EB2F043907ACC1@ESGSCMB105.ericsson.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

>> Also, we can see that 9.2.3 has been released now and has a number of fixes relating to WAL replay, so we have decided to try again using that.
>> We will scrub the standby and make a fresh copy using pg_basebackup. If that doesn't work then we may try using rsync instead.

I am pleased to be able to report that the problem seems to be fixed after upgrading to 9.2.3.

We upgraded the standby server only to 9.2.3, rebuilt the standby using pg_basebackup, and then started it up. It replayed all the outstanding WAL files with no problems.

Regards // Mike

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-02-18 08:00:33 Re: Streaming replication and sharding
Previous Message John R Pierce 2013-02-17 22:41:36 Re: Why is this a cross join?