| From: | Zoltan Boszormenyi <zb(at)cybertec(dot)at> |
|---|---|
| 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 12:56:05 |
| Message-ID: | 46D80FE5.3030408@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Phoenix Kiula írta:
> 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/sda2 ext3 9.9G 9.5G 0 100% /var
>
This is the problem. Free up some space under /var or move either
the whole partition or PostgreSQL's data directory to a new disk.
The data directory lives under /var/lib/postgresql (mainstream) or
/var/lib/pgsql (RedHat speciality).
--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Tolley | 2007-08-31 13:17:36 | Re: URGENT: Whole DB down ("no space left on device") |
| Previous Message | Merlin Moncure | 2007-08-31 12:55:09 | Re: URGENT: Whole DB down ("no space left on device") |