=?ISO-8859-1?Q?Andr=E9_Volpato?= <andre.volpato@xxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
