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