From: | "Aurangzeb M(dot) Agha" <ama-list(at)mltp(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | ama-list(at)mltp(dot)com, PostgreSQL General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: no space left on device |
Date: | 2004-01-09 21:13:26 |
Message-ID: | Pine.LNX.4.58.0401091312480.971@cinemaspace.berkeley.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)mltp(dot)com
| Home : +1 413 586.4863
| Pager : +1 413 785.7568
| : 4137857568(at)myairmail(dot)com
73 Bridge St. #15 | Mobile: <coming soon>
Northampton, MA 01060 | e-Fax : +1 978 246.0770
USA | PGP id: <coming soon>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2004-01-09 21:13:59 | Re: no space left on device |
Previous Message | Aurangzeb M. Agha | 2004-01-09 21:11:51 | Re: no space left on device |