Re: corrupted indexes when using base backups generated from hot standby

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Lonni J Friedman <netllama(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: corrupted indexes when using base backups generated from hot standby
Date: 2013-01-29 16:38:18
Message-ID: 5107FAFA.4020305@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 29.01.2013 18:36, Lonni J Friedman wrote:
> On Tue, Jan 29, 2013 at 8:32 AM, Heikki Linnakangas
> <hlinnakangas(at)vmware(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lonni J Friedman 2013-01-29 16:40:10 Re: corrupted indexes when using base backups generated from hot standby
Previous Message Lonni J Friedman 2013-01-29 16:36:12 Re: corrupted indexes when using base backups generated from hot standby