X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A9E128BA097 for ; Wed, 16 Feb 2005 15:24:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65872-03 for ; Wed, 16 Feb 2005 15:24:52 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6D7F78B9CB8 for ; Wed, 16 Feb 2005 15:24:52 +0000 (GMT) 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 j1GFOqOW024114; Wed, 16 Feb 2005 10:24:52 -0500 (EST) To: Morus Walter Cc: pgsql-admin Subject: Re: when datas filesystem is full how to do In-reply-to: <16915.20833.452186.548671@tanto-xipolis.de> References: <421347DD.2090602@3times25.net> <16915.20833.452186.548671@tanto-xipolis.de> Comments: In-reply-to Morus Walter message dated "Wed, 16 Feb 2005 14:57:53 +0100" Date: Wed, 16 Feb 2005 10:24:52 -0500 Message-ID: <24113.1108567492@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/140 X-Sequence-Number: 16308 Morus Walter writes: > I guess the problem is, that he doesn't want to stop the database. Yeah ... I'm afraid that's an impractical goal. > I'd rather suggest to look into tablespaces. > Create a new tablespace on some other filesystem and move the contents > of the database by using ALTER TABLE/INDEX SET TABLESPACE... Although the postmaster may stay up, this would still involve taking exclusive locks on large tables for long enough to copy them to another disk. That would probably knock out his application just as effectively as a full database shutdown. And of course it's not even an option unless he's running PG 8.0. regards, tom lane