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

2001-03-21 Thread Mikheev, Vadim
> >> 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 > > 00 to 00012 (in hex), if any. > > OK, thanks. Is there any documentation on these files, and what > our options are if something l

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

2001-03-21 Thread Gordon A. Runkle
In article <[EMAIL PROTECTED]>, "Mikheev, Vadim" <[EMAIL PROTECTED]> wrote: >> 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 000 > to 00012 (in hex), if any. OK, thanks. Is there any documentat

[GENERAL] 7.1b6 - pg_xlog filled fs, postmaster won't start

2001-03-21 Thread Gordon A. Runkle
Yes, I was loading a large table. :-) The filesystem with pg_xlog filled up, and the backend (all backends) died abnormally. I can't restart postmaster, either. There are no stray IPC resources left allocated. Is it OK to delete the files from pg_xlog? What will be the result? Will I be abl

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

2001-03-21 Thread Mikheev, Vadim
> 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 000 to 00012 (

[GENERAL] 7.1b6 - pg_xlog filled fs, postmaster won't start

2001-03-21 Thread Gordon A. Runkle
Yes, I was loading a large table. :-) 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? Will I be able to avoid this problem by splitting the load data