Re: : Postgresql Error after recovery
| От | Raghavendra |
|---|---|
| Тема | Re: : Postgresql Error after recovery |
| Дата | |
| Msg-id | CA+h6AhjcuOxHvJ7OxArMi=zDj+ciNwWkumXgk4aj6LS7gzRjVA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: : Postgresql Error after recovery (Venkat Balaji <venkat.balaji@verse.in>) |
| Ответы |
Re: : Postgresql Error after recovery
|
| Список | pgsql-general |
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/data2012-07-04 04:30:47 CDT [26072]: [1-1] user=,db= FATAL: index "pg_attribute_relid_attnum_index" contains unexpected zero page at block 02012-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.
---
Regards,
Raghavendra
EnterpriseDB Corporation
В списке pgsql-general по дате отправления: