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

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnakangas(at)vmware(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:40:10
Message-ID: CAP=oouG+jaKhhgDsm0FD28pw3_jjCHGHgmBhyDFo84+zh+fYvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jan 29, 2013 at 8:38 AM, Heikki Linnakangas
<hlinnakangas(at)vmware(dot)com> wrote:
> 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.

ok, i'll give that a try.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sathish Reddy Yelala 2013-01-30 07:01:28 Re: PGSQL-IDLE connection problem
Previous Message Heikki Linnakangas 2013-01-29 16:38:18 Re: corrupted indexes when using base backups generated from hot standby