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