Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 31 Aug 2007 13:22:24 +0200
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
- References:
- URGENT: Whole DB down ("no space left on device")
- From: Phoenix Kiula
- URGENT: Whole DB down ("no space left on device")
- Prev by Date: URGENT: Whole DB down ("no space left on device")
- Next by Date: Re: URGENT: Whole DB down ("no space left on device")
- Previous by thread: URGENT: Whole DB down ("no space left on device")
- Next by thread: Re: URGENT: Whole DB down ("no space left on device")
- Indexes: