Jeff Brenton wrote: > I've attempted to re-index the pkey listed but after an hour it fails > with > > REINDEX INDEX testrun_log_pkey; > > ERROR: could not write block 1832079 of temporary file: No space left > on device > > HINT: Perhaps out of disk space? > > There is currently 14GB free on the disk that postgres is installed on. > Does anyone know what I can do to get the db up and running again? Is there 14GB free at the time PostgreSQL claims to run out of space? Try: watch -n 60 "df -m /db" and see if the free space falls close to zero during your reindex attempt. Personally, I'd just try to give Pg some room to breathe. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
