Horton

Re: no space left on device

Mark Kirkwood <markir@paradise.net.nz>

View thread View on postgr.es
From: Mark Kirkwood <markir@paradise.net.nz>
To: "Nigel J. Andrews" <nandrews@investsystems.co.uk>
Cc: "Aurangzeb M. Agha" <ama-list@mltp.com>, Richard Huxton <dev@archonet.com>, PostgreSQL General List <pgsql-general@postgresql.org>
Date: 2004-01-09T23:46:11Z
Lists: pgsql-general 
I would suspect some *other* service is using the 4G for transient 
storage every now and again, and it just so happens that Pg is getting 
tripped up.

What else does this machine run ?

regards

Mark



Nigel J. Andrews wrote:

>On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote:
>
>  
>
>>Here's the output of "df -m":
>>
>>[postgres - DB]$ df -m .
>>Filesystem           1M-blocks      Used Available Use% Mounted on
>>-                        63328     55308      4803  93% /
>>
>>    
>>
>
>But your du, below, of the postgres data directory shows 53MB in use. That's an
>order of magnitude smaller than the 55GB the above appears to be saying is used
>in the db.
>
>
>  
>