Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2243A9F9F46 for ; Fri, 22 Dec 2006 12:07:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 46895-08 for ; Fri, 22 Dec 2006 12:06:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from out4.smtp.messagingengine.com (out4.smtp.messagingengine.com [66.111.4.28]) by postgresql.org (Postfix) with ESMTP id D675E9F9C35 for ; Fri, 22 Dec 2006 12:06:54 -0400 (AST) Received: from out1.internal (unknown [10.202.2.149]) by out1.messagingengine.com (Postfix) with ESMTP id 9F1CE59965 for ; Fri, 22 Dec 2006 11:06:46 -0500 (EST) Received: from db2.messagingengine.com ([10.202.2.12]) by out1.internal (MEProxy); Fri, 22 Dec 2006 11:06:46 -0500 Received: by db2.messagingengine.com (Postfix, from userid 99) id 6CC8FBF; Fri, 22 Dec 2006 11:06:46 -0500 (EST) Message-Id: <1166803606.2828.281701761@webmail.messagingengine.com> X-Sasl-Enc: JKibWDNuWtDPOTd0FheTILh+FCny77EQZDU3LaHcyD+d 1166803606 From: "Jeremy Haile" To: pgsql-performance@postgresql.org Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MessagingEngine.com Webmail Interface Subject: URGENT: Out of disk space pg_xlog Date: Fri, 22 Dec 2006 11:06:46 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/491 X-Sequence-Number: 22547 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!