Re: URGENT: Whole DB down ("no space left on device") - Mailing list 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