Re: no space left on device

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: no space left on device
Date: 2004-01-09 21:55:55
Message-ID: 20040109225555.A627@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Wait... from the df you provided you have space left on the device:
>
> postgres - DB]$ df -m .
> Filesystem 1M-blocks Used Available Use% Mounted on
> - 63328 55308 4803 93% /
>
> Perhaps you are out of inodes?
Remember that df shows the *total* space left on the device,
especially when run as root. Some percent are reserved for
root, however, AFAIR pretty much exactly 7% in my experience,
eg. user postgres can't use them but rather sees a device
that's out of space. That may be the case here.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-01-09 22:18:45 Re: Rép. : Re: start/stop a database
Previous Message Frank van Vugt 2004-01-09 21:50:01 Why does this use of accents in psql fail for a Unicode database?