Re: [BUGS] Corrpupt Data File

2004-02-26 Thread Tom Lane
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

Re: [BUGS] Corrpupt Data File

2004-02-26 Thread Alex Derbes
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