Re: : Postgresql Error after recovery

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: : Postgresql Error after recovery
Date: 2012-07-04 08:42:54
Message-ID: CA+h6AhjbHjeMrD70eTH5QzW0O74JNhagz_yBZSTuaUSpnW7XdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 4, 2012 at 2:11 PM, Raghavendra <
raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:

> \
>> postgres=# \c oltp_db
>> FATAL: index "pg_attribute_relid_attnum_index" contains unexpected zero
>> page at block 0
>> HINT: Please REINDEX it.
>> Previous connection kept
>>
>> Can anyone please help us.
>>
>>
> You have HINT given to REINDEX it. Use reindexdb from OS.
>
>
One more point, reindex the system catalog as "reindexdb -s"

--Raghav

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Venkat Balaji 2012-07-04 09:46:39 Re: : Postgresql Error after recovery
Previous Message Raghavendra 2012-07-04 08:41:46 Re: : Postgresql Error after recovery