Re: [GENERAL] CREATE INDEX failing; No space left on device; Database recycling itself

2005-02-17 Thread Tom Lane
"Sailer, Denis (YBUSA-CDR)" <[EMAIL PROTECTED]> writes: > The following errors also showed up. So my question is why does the > failure of CREATE INDEX cause all my connections to be terminated and > the database to go into recovery mode? Sounds kind of drastic. Not having any xlog space is fata

[GENERAL] CREATE INDEX failing; No space left on device; Database recycling itself

2005-02-17 Thread Sailer, Denis (YBUSA-CDR)
I was trying to create an index on a 37,000,000 row table and received the following error.  Evidently I don’t have enough space in my pg_xlog directory to handle this as a single transaction.  The file system for pg_xlog is allocated 2GB.   The following output is from a psql session direc