URGENT: Whole DB down ("no space left on device") - Mailing list pgsql-general

From Phoenix Kiula
Subject URGENT: Whole DB down ("no space left on device")
Date
Msg-id e373d31e0708310411v611152cfj9e76dfd85f6f9f25@mail.gmail.com
Whole thread Raw
Responses Re: URGENT: Whole DB down ("no space left on device")  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
Re: URGENT: Whole DB down ("no space left on device")  (Bruce McAlister <bruce.mcalister@blueface.ie>)
Re: URGENT: Whole DB down ("no space left on device")  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: URGENT: Whole DB down ("no space left on device")  (Zoltan Boszormenyi <zb@cybertec.at>)
List 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!

pgsql-general by date:

Previous
From: "Joost Kraaijeveld"
Date:
Subject: Out of memory error, FreeBSD 6.2, PostgreSQL 8.2.4
Next
From: Tommy Gildseth
Date:
Subject: Re: URGENT: Whole DB down ("no space left on device")