Re: FATAL: index contains unexpected zero page at block

From: Dmitriy Tyugaev <dtyugaev(at)gmail(dot)com>
To: VB N <vbnpgc(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FATAL: index contains unexpected zero page at block
Date: 2012-11-15 07:58:49
Message-ID: CAAL_pKLnLP9zxGR_J54ykshe0TCpHGd7oQpaVXSfOgwu5npjOQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

How can I execute rebulding the index, if it does not start and I can't
connect?

On Thu, Nov 15, 2012 at 2:34 AM, VB N <vbnpgc(at)gmail(dot)com> wrote:

>
> user=,db= FATAL: index "316879235" contains unexpected zero page at block
>> 264
>> user=,db= HINT: Please REINDEX it.
>>
>> Please tell me what can I do to recover?
>>
>
> Did you try re-building the index ? Re-Indexing or re-creating an new
> index should resolve this.
>
> Regards,
> VBN
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Tyugaev 2012-11-15 08:31:21 Re: FATAL: index contains unexpected zero page at block
Previous Message Wang, Hao 2012-11-15 01:44:24 Re: File system level copy