Re: no space left on device

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: "Aurangzeb M. Agha" <ama-list@mltp.com>, PostgreSQL General List <pgsql-general@postgresql.org>
Date: 2004-01-09T23:25:12Z
Lists: pgsql-general
"scott.marlowe" <scott.marlowe@ihs.com> writes:
>> [postgres - DB]$ df -m .
>> Filesystem           1M-blocks      Used Available Use% Mounted on
>> -                        63328     55308      4803  93% /

> Do you have root access to it?  if so, set the reserved space for root to 
> be 0%, and then try vacuuming.  Vacuuming requires some free space, and 
> since you're pretty much out, it isn't gonna be able to complete.

Look again --- it's showing free space in MB not KB.  He's got 4.8GB
free.  (Although that might be free-from-root's-point-of-view, rather
than what an unprivileged user can use ...)

			regards, tom lane