Re: ERROR: cannot read block

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:vilson.farias@digitro.com.br]
Sent: Thursday, January 24, 2002 7:51 AM
To: pgsql-admin@postgresql.org
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: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org