=?ISO-8859-1?Q?Andr=E9_Volpato?= <andre.volpato@ecomtecnologia.com.br> writes:
> 8. Postgres is up, but...
> # psql matriz
> psql: FATAL: could not read block 0 of relation 1664/0/2676: read only
> 0 of 8192 bytes
Looks like your raid array is dying under you :-( ...
2676 is pg_authid_rolname_index, so you could probably get around that
particular problem by reindexing pg_authid in standalone mode. (You
might need to use the -P option too, not sure.) But the "corrupted item
pointer" complaint is heap corruption and no amount of reindexing will
fix it.
Since you seem to be able to select from the broken table without
problem, I'd suggest just copying its data into a new table and dropping
the broken one (or truncate it and copy the data back).
regards, tom lane
