From: Jeremy Haile <jhaile@fastmail.fm>
To: pgsql-performance@postgresql.org
Subject: URGENT: Out of disk space pg_xlog
Date: Fri, 22 Dec 2006 11:06:46 -0500
Message-ID: <1166803606.2828.281701761@webmail.messagingengine.com> (raw)
I created a 10GB partition for pg_xlog and ran out of disk space today
during a long running update. My checkpoint_segments is set to 12, but
there are 622 files in pg_xlog. What size should the pg_xlog partition
be?
Postmaster is currently not starting up (critical for my organization)
and reports "FATAL: The database system is starting up" .
The log reports:
2006-12-22 10:50:09 LOG: checkpoint record is at 2E/87A323C8
2006-12-22 10:50:09 LOG: redo record is at 2E/8729A6E8; undo record is
at 0/0; shutdown FALSE
2006-12-22 10:50:09 LOG: next transaction ID: 0/25144015; next OID:
140986
2006-12-22 10:50:09 LOG: next MultiXactId: 12149; next MultiXactOffset:
24306
2006-12-22 10:50:09 LOG: database system was not properly shut down;
automatic recovery in progress
2006-12-22 10:50:09 LOG: redo starts at 2E/8729A6E8
This has been running for 20 minutes. What can I do? Please help!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jhaile@fastmail.fm
Subject: Re: URGENT: Out of disk space pg_xlog
In-Reply-To: <1166803606.2828.281701761@webmail.messagingengine.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox