Re: no space left on device - Mailing list pgsql-general

From Tom Lane
Subject Re: no space left on device
Date
Msg-id 27065.1073690712@sss.pgh.pa.us
Whole thread Raw
In response to Re: no space left on device  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: no space left on device  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: no space left on device  ("Aurangzeb M. Agha" <ama-list@mltp.com>)
List 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

pgsql-general by date:

Previous
From: "Aurangzeb M. Agha"
Date:
Subject: Re: no space left on device
Next
From: Dennis Björklund
Date:
Subject: Re: no space left on device