Re: no space left on device

On Fri, 9 Jan 2004, 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   .
>
> Note that the pg_xlog dir is huge!  Here's its contents:

That's normal.  32 meg isn't really that big.  How big of a partition do
you have this database on?  Your best bet is to put it on a bigger
partition.  the pg_xlog directory is gonna be at least 16 megs for most
installations.

Do you have any transactions sitting at idle keeping postgresql from
recycling the xlogs?

Normally when you run out of space it's a lack of vacuuming, but here it
just sounds like either the partition is too small or the postgres user is
living under a quota on that partition.