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 129B6329FB2 for ; Thu, 21 Oct 2004 19:36:43 +0100 (BST) 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 14680-10 for ; Thu, 21 Oct 2004 18:36:32 +0000 (GMT) Received: from bramble.mmrd.com (bramble.mmrd.com [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id D5AD432A916 for ; Thu, 21 Oct 2004 19:36:31 +0100 (BST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i9LHZQBW022956; Thu, 21 Oct 2004 13:35:29 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i9LIaGm12261; Thu, 21 Oct 2004 14:36:17 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 4C2FDXKA; Thu, 21 Oct 2004 14:36:13 -0400 Subject: Re: How to drop a database cluster? From: Robert Treat To: Slobodan Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 21 Oct 2004 14:36:15 -0400 Message-Id: <1098383775.15573.7.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/282 X-Sequence-Number: 15275 On Thu, 2004-10-21 at 10:43, Slobodan wrote: > Hi! > > I cannot find the way of dropping a database cluster in the > documentation. Should I simply remove the directory associated with > the cluster? > I take you don't want to use the DROP DATABASE command, but instead are trying to drop all databases from a system? If so, remove whatever directory PGDATA is set to and then run initdb on the new PGDATA directory. Be aware that this is basically like starting from scratch, you will lose all of your information. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL