As another data point, I upgraded from 8.2.6 to 8.3.6
and I saw those corruption messages after restoring
pg_dump files back into the database with psql and
inserting a bunch of data (some duplicate records
got rejected.) The insertion of new data is via
perl's DBI interface.
This was after the upgrade, so there had been no
dirty stops, etc.
Thinking that it might be an index problem, I've tried
reindexing the entire database - no errors but neither
does the problem go away. Nor does it stop the database
from starting up.
Where it pops up seems to be random (going from the errors
on postgres's log from earlier starts.) At the moment,
it's stopping me from creating a new table or dropping an
existing table (where I first ran into the error.) But
accessing all of the tables is fine...
I suppose the logical thing for me to do is go back to 8.2.6.
Darren
ERROR: could not read block 1 of relation 1664/0/1233: read only 0 of
8192 bytes
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs