Re: db recovery (FATAL 2) - Mailing list pgsql-admin

From Tom Lane
Subject Re: db recovery (FATAL 2)
Date
Msg-id 3233.1020876360@sss.pgh.pa.us
Whole thread Raw
In response to Re: db recovery (FATAL 2)  (Bojan Belovic <bbelovic@usa.net>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Vilson farias"
Date:
Subject: Re: Performance question related with temporary tables
Next
From: Tom Lane
Date:
Subject: Re: Performance question related with temporary tables