| 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: | Whole Thread | Raw Message | 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
| 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? |