Postgres Pro
Downloads
Home   >   mailing lists

Re: : Postgresql Error after recovery - Mailing list pgsql-general

From Raghavendra
Subject Re: : Postgresql Error after recovery
Date
Msg-id CA+h6AhjbHjeMrD70eTH5QzW0O74JNhagz_yBZSTuaUSpnW7XdQ@mail.gmail.com
Whole thread Raw
In response to Re: : Postgresql Error after recovery  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Responses Re: : Postgresql Error after recovery  (Venkat Balaji <venkat.balaji@verse.in>)
List pgsql-general
Tree view
On Wed, Jul 4, 2012 at 2:11 PM, Raghavendra <raghavendra.rao@enterprisedb.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

pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: : Postgresql Error after recovery
Next
From: Venkat Balaji
Date:
Subject: Re: : Postgresql Error after recovery