[SQL] (pgsql8.4) DATA Corruption

2011-08-19 Thread Mikola Rose
Happy Friday people! I was wondering if anyone had any suggestions on how to resolve this issue... I am moving otrs to another server and during the backup process I am running into this error pg_dump: dumping contents of table article_attachment pg_dump: SQL command failed pg_dump:

Re: [SQL] (pgsql8.4) DATA Corruption

2011-08-19 Thread Scott Marlowe
On Fri, Aug 19, 2011 at 1:08 PM, Mikola Rose mr...@power-soft.com wrote: Happy Friday people! I was wondering if anyone had any suggestions on how to resolve this issue...  I am moving otrs to another server and during the backup process I am running into this error pg_dump: dumping

Re: [SQL] (pgsql8.4) DATA Corruption

2011-08-19 Thread Mik Rose
Thanks for the suggestions Scott. I was looking at the zero_damage_page option and enabled it in my postgres.conf. I saw that it detected bad pages and zero'd them out during a number of reindex and a vacuum's. Now when i reindex though, I am getting this error. NOTICE: table