HINT: Please REINDEX it.

From: "nabakumar salam" <salamnabakumar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org(dot)
Subject: HINT: Please REINDEX it.
Date: 2007-11-17 20:57:49
Message-ID: f3c948690711171257g2fd8e5edg66489b345028d4d7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
When i start the postgres DB , it starts properly. but when i am
trying to connect to it . it shows a pop up with the error message
"Error connecting to the server: FATAL: index "pg_class_oid_index"
contains unexpected zero page at block 0
HINT: Please REINDEX it."
i tried starting the database using --single --P option , but says it
cannot be started with user as admin.

Any pointers on how to solve this problem?

Thanks in advance,
nsalam

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ted Byers 2007-11-17 22:19:17 Re: Need help with complicated SQL statement
Previous Message Michelle Konzack 2007-11-17 16:48:17 Re: Temporary, In-memory Postgres DB?