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

From: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: URGENT: Whole DB down ("no space left on device")
Date: 2007-08-31 11:22:24
Message-ID: 46D7F9F0.6010704@usit.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Phoenix Kiula wrote:
> 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:
>
>

> /dev/sda2 ext3 9.9G 9.5G 0 100% /var
>

Well, the error message is pretty clear, and assuming you don't keep
your database in any non-standard location, you /var partition is indeed
full.

--
Tommy Gildseth

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce McAlister 2007-08-31 11:27:55 Re: URGENT: Whole DB down ("no space left on device")
Previous Message Phoenix Kiula 2007-08-31 11:11:24 URGENT: Whole DB down ("no space left on device")