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
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
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
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:
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
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.
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