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

From Aurangzeb M. Agha
Subject Re: no space left on device
Date
Msg-id Pine.LNX.4.58.0401091312480.971@cinemaspace.berkeley.edu
Whole thread Raw
In response to Re: no space left on device  (Richard Huxton <dev@archonet.com>)
Responses Re: no space left on device  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
Here's the output of "df -m":

[postgres - DB]$ df -m .
Filesystem           1M-blocks      Used Available Use% Mounted on
-                        63328     55308      4803  93% /

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.
:
:

--
Aurangzeb M. Agha     | Email : ama@mltp.com
                      | Home  : +1 413 586.4863
                      | Pager : +1 413 785.7568
                      |       : 4137857568@myairmail.com
73 Bridge St. #15     | Mobile: <coming soon>
Northampton, MA 01060 | e-Fax : +1 978 246.0770
USA                   | PGP id: <coming soon>


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: no space left on device
Next
From: "Aurangzeb M. Agha"
Date:
Subject: Re: no space left on device