Re: : Postgresql Error after recovery

Re-index option did not work.

Single user mode option did not work as well -

[postgres@localhost bin]$ postgres --single oltp_db -E -D /usr/local/postgresql-9.0.1/data

2012-07-04 04:30:47 CDT [26072]: [1-1] user=,db= FATAL:  index "pg_attribute_relid_attnum_index" contains unexpected zero page at block 0

2012-07-04 04:30:47 CDT [26072]: [2-1] user=,db= HINT:  Please REINDEX it.

Last option would be dump and restore. We need to avoid that reduce the downtime.