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

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.

Start again with du -sk /* and follow the biggest numbers.

Ideas:

 - have you logfiles that processes, such as postmaster, are writing to and
have got huge?

 - did you have the above and you deleted such files without restarting the
process that was writing to the deleted files?

 - /var/(mail|tmp|whatever) is huge due to huge amounts of email recieved and
not deleted

 - /home/whatever is huge due to logfiles, downloads (inc. application caches),
datafiles, software builds, ...


--
Nigel Andrews



> Thx for the info.
>
>
> Rgs,
>
> Aurangzeb
>
>
> On Fri, 9 Jan 2004, Richard Huxton wrote:
>
> :On Friday 09 January 2004 20:31, Aurangzeb M. Agha wrote:
> :> I'm running Postgres 7.1.3, and just started having a problem where my
> :> dynamic site is going down (read-only DB, with no writes happening to the
> :> DB) regularly (every other day).  I have no idea whay this is happening,
> :> and my search of the FAQ's and mail list don't bring up anything.  i've
> :> attached the error from the log file, at the end of this message.
> :>
> :> Here's an output of the disk usage from within the DB dir
> :>
> :> [postgres - DB]$ du -k .
> :> 1716    ./base/1
> :> 1716    ./base/16555
> :> 5192    ./base/56048
> :> 8628    ./base
> :> 116 ./global
> :> 32812   ./pg_xlog
> :> 11380   ./pg_clog
> :> 53192   .
> :
> :OK, and what does "df -m" show? That will display disk sizes and free space
> :remaining. Your error is that you have run out of disk space.
> :
> :> Note that the pg_xlog dir is huge!  Here's its contents:
> :
> :Well - it's 32MB (2 x 16MB as you show below).
> :
> :> -rwx------    1 postgres admin    16777216 Jan  9 15:09 0000000000000001
> :> -rwx------    1 postgres admin    16777216 Mar 29  2003 0000000000000002
> :>
> :> What are these files, and what can I do to resolve this issue?
> :
> :They're transaction logs (see the section on WAL). You can probably reduce
> :them from their default size of 16MB, I'm guessing by changing some constant
> :in the source and re-compiling.
> :
> :
>
>