Re: corrupted indexes when using base backups generated from hot standby - Mailing list pgsql-admin

From Heikki Linnakangas
Subject Re: corrupted indexes when using base backups generated from hot standby
Date
Msg-id 5107FAFA.4020305@vmware.com
Whole thread Raw
In response to Re: corrupted indexes when using base backups generated from hot standby  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: corrupted indexes when using base backups generated from hot standby  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-admin
On 29.01.2013 18:36, Lonni J Friedman wrote:
> On Tue, Jan 29, 2013 at 8:32 AM, Heikki Linnakangas
> <hlinnakangas@vmware.com>  wrote:
>> Thanks. I'm afraid I didn't get any wiser from the log output. Since this is
>> a test system, could you reduce the test case into something smaller and
>> self-contained?
>
> Sorry, I don't understand what you're requesting.  How can I reduce a
> test case when all I'm doing to generate the corrupted data is running
> pg_basebackup on the standby?  Do you mean using a smaller database?

Yes, smaller database, and a simpler schema with e.g only one table and
index. And only do inserts while the backup is running, for example.

- Heikki


pgsql-admin by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: corrupted indexes when using base backups generated from hot standby
Next
From: Lonni J Friedman
Date:
Subject: Re: corrupted indexes when using base backups generated from hot standby