Re: no space left on device

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: "Aurangzeb M(dot) Agha" <ama-list(at)mltp(dot)com>, PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: no space left on device
Date: 2004-01-09 23:25:12
Message-ID: 27065.1073690712@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2004-01-09 23:25:28 Re: no space left on device
Previous Message Aurangzeb M. Agha 2004-01-09 23:22:17 Re: no space left on device