I think you have experienced data/index block corruption. First drop indexes (if you have) and recreate them. if only index corrupts, you are lucky, this will fix your problem. but if this won't work, it means that data block corrupted, you may need to recovery your database using backup. Above suggestion comes from my oracle DBA experience. I know extractly how to handle this in oracle, for postgres, theory is same. Good luck!!
Anna Zhang -----Original Message----- From: Vilson farias [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 7:51 AM To: [EMAIL PROTECTED] Subject: [ADMIN] ERROR: cannot read block Sorry for inconvenience, but search engine is not working so maybe I'm talking about this kind of error again. I can't explain exactly what happenend but at certain point one of my PostgreSQL database tables had stopped working. The error is : ERROR: cannot read block 3 from rel__modelo Can it be fixed? Vacuum can't access this table, so I don't know how to fix it. Best regards. ---------------------------------------------------------------------------- ---- José Vilson de Mello de Farias Analista de Sistemas Dígitro Tecnologia Ltda - www.digitro.com.br APC - Aplicativos Orientados ao Cliente E-mail: [EMAIL PROTECTED] Tel.: +55 48 281 7158 ICQ 11866179 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
