| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bojan Belovic <bbelovic(at)usa(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: db recovery (FATAL 2) |
| Date: | 2002-05-08 05:59:46 |
| Message-ID: | 29774.1020837586@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah. | 2002-05-08 06:15:37 | data loss due to improper handling of postmaster .... |
| Previous Message | otisg | 2002-05-08 00:03:55 | Re: Dying PostgreSQL backend |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah. | 2002-05-08 06:15:37 | data loss due to improper handling of postmaster .... |
| Previous Message | Martijn van Oosterhout | 2002-05-08 01:25:27 | Re: Performance issues with compaq server |