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

Looks like you're out of disk space on:

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

is this where your database resides?

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:
>
>
> 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!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
>