> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
