X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6822D9DC98D for ; Tue, 3 Jan 2006 14:38:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45001-01 for ; Tue, 3 Jan 2006 14:38:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id D71D19DC9A1 for ; Tue, 3 Jan 2006 14:38:23 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k03IcDRl018813; Tue, 3 Jan 2006 13:38:13 -0500 (EST) To: Tomaz Borstnar cc: pgsql-admin@postgresql.org Subject: Re: full data disk -- any chance of recovery In-reply-to: References: <71E37EF6B7DCC1499CEA0316A2568328024BBD84@loki.wc.globexplorer.net> Comments: In-reply-to Tomaz Borstnar message dated "Tue, 03 Jan 2006 19:04:19 +0100" Date: Tue, 03 Jan 2006 13:38:13 -0500 Message-ID: <18812.1136313493@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.063 required=5 tests=[AWL=0.063] X-Spam-Score: 0.063 X-Spam-Level: X-Archive-Number: 200601/29 X-Sequence-Number: 20117 Tomaz Borstnar writes: > Jeff Frost pravi: >> Seems like you're going to have to kill -9. > Yeah, this is bad :( Seems like kill -9 is needed when disk is full. Tested on *BSD jails. With what PG version? And what behavior did you see exactly? regards, tom lane