URGENT: Whole DB down ("no space left on device")

Поиск
Список
Период
Сортировка
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!

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joost Kraaijeveld"
Дата:
Сообщение: Out of memory error, FreeBSD 6.2, PostgreSQL 8.2.4
Следующее
От: Tommy Gildseth
Дата:
Сообщение: Re: URGENT: Whole DB down ("no space left on device")