Alex Derbes <[EMAIL PROTECTED]> writes:
> deleting the indexes from the table did not help. Is there a tool or
> method that that I could use to simply skip the bad data and at least
> recover the good blocks?
Just zero out the broken page, eg with dd from /dev/zero. Note it
might be a good id
for the annals of postgres maintenance I got my DB running by using DD to
copy the blocks before the corrupt block, then add block from /dev/zero,
then add the remaining blocks from the file. I discovered the block size
by looking at he output of pg_filedump. To find the offending file select
re
Hi,
I have a postgres data base that is probably about 2gigs in size
spread across a couple of tables. The orders table is about 500megs in
size and is mostly writes.
When running "select count(1) from orders" on the database this
evening, the DB responded with "ERROR: Inval
