Re: : Postgresql Error after recovery

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

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.

How about starting the instance with ignore_system_indexes=true ? And do dump & restore. Am not sure on this procedure. Should someone here would have better idea on this.

http://www.postgresql.org/docs/9.0/interactive/runtime-config-developer.html

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/