Thread: HINT: Please REINDEX it.

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

"nabakumar salam" <salamnabakumar@gmail.com> writes:
> "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?

Don't bother with single-user mode.  There's an example on the REINDEX
reference page:

$ export PGOPTIONS="-P"
$ psql broken_db
...
broken_db=> REINDEX DATABASE broken_db;
broken_db=> \q

(Not sure how to translate this to Windows, which reading between the
lines I suspect you're using.  But Windows does have environment
variables so I suppose there's a way.)

            regards, tom lane