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

From Lonni J Friedman
Subject Re: corrupted indexes when using base backups generated from hot standby
Date
Msg-id CAP=oouG+jaKhhgDsm0FD28pw3_jjCHGHgmBhyDFo84+zh+fYvw@mail.gmail.com
Whole thread Raw
In response to Re: corrupted indexes when using base backups generated from hot standby  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-admin
On Tue, Jan 29, 2013 at 8:38 AM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
> 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.

ok, i'll give that a try.


pgsql-admin by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: corrupted indexes when using base backups generated from hot standby
Next
From: Sathish Reddy Yelala
Date:
Subject: Re: PGSQL-IDLE connection problem