Re: db recovery (FATAL 2)

Bojan Belovic <bbelovic@usa.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