Re: db recovery (FATAL 2)

Bojan Belovic <bbelovic(at)usa(dot)net> writes:
> You are correct, it's 7.1.2 . However, the problem is not with disk space
> (there's several gigs available), but there could be a problem with a bad
> sector on one of the log files. If this is the case, and the log file is
> corrupted, is there any way of recovering, even with a certain data loss?

Hm. It's complaining about a write, not a read, so there is no lost
data (yet), even if your theory is correct. You might first try copying
the entire $PGDATA/pg_xlog directory somewhere else.

If nothing else avails, see contrib/pg_resetxlog. But that should be
your last resort not first.

regards, tom lane