From: | "Aurangzeb M(dot) Agha" <ama-list(at)mltp(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(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:11:51 |
Message-ID: | Pine.LNX.4.58.0401091308300.971@cinemaspace.berkeley.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've not run a vacuum in quite some time, and that's because I've only
been doing reads from this DB. I was under the impression that I should
run vacuum when tables are heavily modified:
http://www.postgresql.org/docs/aw_pgsql_book/node110.html
I guess I must have been mistaken?
I'm looking through the docs now, but am having trouble finding this: how
can I vacuum the entire DB at once?
Thx,
Zeb
On Fri, 9 Jan 2004, Joshua D. Drake wrote:
:
:>
:>Note that the pg_xlog dir is huge! Here's its contents:
:>
:>[postgres - DB/pg_xlog]$ ls -al
:>total 32816
:>drwx------ 2 postgres admin 4096 Mar 29 2003 .
:>drwx------ 6 postgres admin 4096 Jan 9 15:04 ..
:>-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?
:>
:>
:The are check_point files. You need them. Have you ran a vacuum recently?
:
:Sincerely,
:
:Joshua D. Drake
:
:
:
:>Thx,
:>
:>Zeb
:>
:>
:>--
:>DEBUG: statistics collector process (pid 2523) exited with exit code 1
:>PGSTAT: Error closing temp stats file
:>PGSTAT: /usr/local/G101/App/DB/./global/pgstat.tmp.7823: No space left on
:>device
:>PGSTAT: AbDEBUG: statistics collector process (pid 2979) exited with exit
:>code
:>1
:>FATAL 2: write of clog file 43, offset 188416 failed: No space left on
:>device
:>DEBUG: server process (pid 3741) exited with exit code 2
:>DEBUG: terminating any other active server processes
:>NOTICE: Message from PostgreSQL backend:
:> The Postmaster has informed me that some other backend
:> died abnormally and possibly corrupted shared memory.
:> I have rolled back the current transaction and am
:> going to terminate your database system connection and exit.
:> Please reconnect to the database system and repeat your query.
:>NOTICE: Message from PostgreSQL backend:
:> The Postmaster has informed me that some other backend
:> died abnormally and possibly corrupted shared memory.
:> I have rolled back the current transaction and am
:> going to terminate your database system connection and exit.
:> Please reconnect to the database system and repeat your query.
:>NOTICE: Message from PostgreSQL backend:
:> The Postmaster has informed me that some other backend
:> died abnormally and possibly corrupted shared memory.
:> I have rolled back the current transaction and am
:> going to terminate your database system connection and exit.
:> Please reconnect to the database system and repeat your query.
:>DEBUG: all server processes terminated; reinitializing shared memory and
:>semaph
:>ores
:>DEBUG: database system was interrupted at 2004-01-09 05:22:52 EST
:>DEBUG: checkpoint record is at 0/138CFD4
:>DEBUG: redo record is at 0/138CFD4; undo record is at 0/0; shutdown FALSE
:>DEBUG: next transaction id: 45811837; next oid: 65205
:>DEBUG: database system was not properly shut down; automatic recovery in
:>progre
:>ss
:>DEBUG: redo starts at 0/138D014
:>FATAL 2: write of clog file 43, offset 188416 failed: No space left on
:>device
:>DEBUG: startup process (pid 3785) exited with exit code 2
:>DEBUG: aborting startup due to startup process failure
:>
:>---------------------------(end of broadcast)---------------------------
:>TIP 6: Have you searched our list archives?
:>
:> http://archives.postgresql.org
:>
:>
:
:
:
From | Date | Subject | |
---|---|---|---|
Next Message | Aurangzeb M. Agha | 2004-01-09 21:13:26 | Re: no space left on device |
Previous Message | Richard Huxton | 2004-01-09 21:10:49 | Re: no space left on device |