Re: db recovery (FATAL 2)

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?

Thanks!

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bojan Belovic <bbelovic(at)usa(dot)net> writes:
> > FATAL 2: write(logfile 10 seg 93 off 15474688) failed: Success
>
> This would be what PG version?
>
> Broad-jumping to conclusions, I'm going to guess (a) 7.1.0-7.1.2
> and (b) you are out of disk space for the WAL logs.
>
> If so, you'll need to free up 16MB or so to restart the postmaster,
> and you'd be well advised to update to 7.1.3 before trying another
> VACUUM.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster