| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Wampler <swampler(at)noao(dot)edu> |
| Cc: | postgres-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can't restart postmaster! |
| Date: | 2001-06-01 17:24:27 |
| Message-ID: | 3383.991416267@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Steve Wampler <swampler(at)noao(dot)edu> writes:
> FATAL 2: ZeroFill(/var/lib/pgsql/data/pg_xlog/xlogtemp.16747) failed: No such file or directory
The error message is bogus --- almost certainly, the real problem is not
enough free space to create another 16-MB WAL segment. (I have a TODO
item about making sure that this case doesn't return a misleading error
code...)
As for recovery, if you can't free any space elsewhere, try removing the
oldest (lowest-numbered) WAL segment file. If the thing refuses to
start after you do that, you might have to resort to applying
contrib/pg_resetxlog, but don't do that unless you have to.
BTW, if you have WAL_FILES set higher than zero, set it back to zero
untill you're out of the woods.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-06-01 17:39:19 | Re: Can't restart postmaster! |
| Previous Message | Brian Kejser | 2001-06-01 16:46:02 | Functionality |