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

2013-02-17 Thread Michael Harris
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 pl

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

2013-02-07 Thread Michael Harris
ubject: Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages On Thu, Feb 7, 2013 at 7:39 AM, amutu wrote: > maybe pg_basebackup can`t handle such big database.try > rsync,pg_start_backup,rsync,pg_stop_backup,it always works fine for > us.our instance is about 2TB

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

2013-02-07 Thread Magnus Hagander
On Thu, Feb 7, 2013 at 7:39 AM, amutu wrote: > maybe pg_basebackup can`t handle such big database.try > rsync,pg_start_backup,rsync,pg_stop_backup,it always works fine for us.our > instance is about 2TB and we use pg9.1.x. It really should handle that without problem, but sure, it might be worth

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

2013-02-06 Thread amutu
patch, however the error > recurred exactly as before. > > Regards // Mike > > > -Original Message- > From: Hari Babu [mailto:haribabu.ko...@huawei.com] > Sent: Tuesday, 5 February 2013 10:07 PM > To: Michael Harris; pgsql-general@postgresql.org > Subject:

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

2013-02-06 Thread Michael Harris
Subject: RE: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages On Tuesday, February 05, 2013 6:05 AM Michael Harris wrote: >Any ideas for a next troubleshooting step? [BUG?] lag of minRecoveryPont in archive recovery, which has fixed recently. Please check the following l

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

2013-02-05 Thread Hari Babu
On Tuesday, February 05, 2013 6:05 AM Michael Harris wrote: >Any ideas for a next troubleshooting step? [BUG?] lag of minRecoveryPont in archive recovery, which has fixed recently. Please check the following link for more details. It may help. http://www.postgresql.org/message-id/20121206.130458.

[GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

2013-02-04 Thread Michael Harris
Hi All, We are having a thorny problem I'm hoping someone will be able to help with. We have a pair of machines set up as an active / hot SB pair. The database they contain is quite large - approx. 9TB. They were working fine on 9.1, and we recently upgraded the active DB to 9.2.1. After upgra