Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-admin by date:

Previous
From: "otisg"
Date:
Subject: Re: Dying PostgreSQL backend
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: data loss due to improper handling of postmaster ....