"nabakumar salam" <salamnabakumar@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
