From: | "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com> |
---|---|
To: | "Postgres General" <pgsql-general(at)postgresql(dot)org> |
Subject: | URGENT: Whole DB down ("no space left on device") |
Date: | 2007-08-31 11:11:24 |
Message-ID: | e373d31e0708310411v611152cfj9e76dfd85f6f9f25@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am getting this message when I start the DB:
psql: FATAL: could not access status of transaction 0
DETAIL: Could not write to file "pg_subtrans/01F8" at offset 221184:
No space left on device.
What is this about and how do I solve this? A "df -h" on my system shows this:
Filesystem Type Size Used Avail Use% Mounted on
/dev/sda5 ext3 9.9G 2.5G 6.9G 27% /
/dev/sda1 ext3 99M 17M 78M 18% /boot
none tmpfs 2.0G 0 2.0G 0% /dev/shm
/dev/sda7 ext3 197G 17G 171G 9% /home
/dev/sda8 ext3 1012M 34M 927M 4% /tmp
/dev/sda3 ext3 9.9G 4.4G 5.0G 47% /usr
/dev/sda2 ext3 9.9G 9.5G 0 100% /var
/tmp none 1012M 34M 927M 4% /var/tmp
Please help!
From | Date | Subject | |
---|---|---|---|
Next Message | Tommy Gildseth | 2007-08-31 11:22:24 | Re: URGENT: Whole DB down ("no space left on device") |
Previous Message | Joost Kraaijeveld | 2007-08-31 10:54:11 | Out of memory error, FreeBSD 6.2, PostgreSQL 8.2.4 |