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

From Mark Kirkwood
Subject Re: no space left on device
Date
Msg-id 3FFF3D43.6030201@paradise.net.nz
Whole thread Raw
In response to Re: no space left on device  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List 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.
>
>
>
>


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: no space left on device
Next
From: Martijn van Oosterhout
Date:
Subject: Re: ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index