RE: 7.1b6 - pg_xlog filled fs, postmaster won't start - Mailing list pgsql-general

From Mikheev, Vadim
Subject RE: 7.1b6 - pg_xlog filled fs, postmaster won't start
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D3340@sectorbase1.sectorbase.com
Whole thread Raw
In response to 7.1b6 - pg_xlog filled fs, postmaster won't start  ("Gordon A. Runkle" <gar@no-spam-integrated-dynamics.com>)
List pgsql-general
> The filesystem with pg_xlog filled up, and the
> backend (all backends) died abnormally.  I can't
> restart postmaster, either.
>
> Is it OK to delete the files from pg_xlog?  What
> will be the result?

It's not Ok. Though you could remove files numbered
from 000000000000000 to 0000000000012 (in hex), if any.

> Will I be able to avoid this problem by splitting
> the load data into multiple files?

Yes if you'll run CHECKPOINT command between COPY-s.

You could also move logs to another FS.

Vadim

pgsql-general by date:

Previous
From: "Gordon A. Runkle"
Date:
Subject: 7.1b6 - pg_xlog filled fs, postmaster won't start
Next
From: "Gordon A. Runkle"
Date:
Subject: 7.1b6 - pg_xlog filled fs, postmaster won't start