RE: 7.1b6 - pg_xlog filled fs, postmaster won't start

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Gordon A(dot) Runkle'" <gar(at)no-spam-integrated-dynamics(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: RE: 7.1b6 - pg_xlog filled fs, postmaster won't start
Date: 2001-03-21 20:00:01
Message-ID: 8F4C99C66D04D4118F580090272A7A234D3340@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gilles DAROLD 2001-03-21 20:14:55 Re: Re: Compile PL/Perl
Previous Message Gilles DAROLD 2001-03-21 19:45:03 Re: Call for platforms