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

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!

Responses

Browse pgsql-general by date

  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