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 по дате отправления