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

Поиск
Список
Период
Сортировка
Искать
От
Mikheev, Vadim
Тема
RE: 7.1b6 - pg_xlog filled fs, postmaster won't start
Дата
Msg-id
8F4C99C66D04D4118F580090272A7A234D3340@sectorbase1.sectorbase.com
Список
Дерево обсуждения
RE: 7.1b6 - pg_xlog filled fs, postmaster won't start "Gordon A. Runkle" <gar@no-spam-integrated-dynamics.com>
> 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 по дате отправления
От: Gordon A. Runkle
Дата:
От: Gordon A. Runkle
Дата:
FAQ