Re: Disaster recovery: pg_class

Enrico <scotty(at)linuxtime(dot)it> writes:
> After a system crash, I have this error:
> SELECT * from mytable;
> WARNING: could not write block 14 of 1663/1743558/1259
> DETAIL: Multiple failures --- write error may be permanent.
> ERROR: xlog flush request 4/D43E0A00 is not satisfied --- flushed only to 4/D42700F0
> CONTEXT: writing block 14 of relation 1663/1743558/1

I'm not convinced there's anything much there you need to fix. You
should look into why the filesystem seems to have lost part of your WAL
file --- that strongly suggests that the disk or kernel is lying about
write ordering, which will cause you problems eventually. But this
message per se will go away as soon as the WAL endpoint moves another
1.5Mb. Unless there's other corruption elsewhere you'll be fine.

regards, tom lane