Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 2C16E9FB41A for ; Thu, 15 Feb 2007 14:31:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 68643-05 for ; Thu, 15 Feb 2007 14:31:46 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id 8BCA79FB708 for ; Thu, 15 Feb 2007 14:31:41 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id D7C88118A32; Thu, 15 Feb 2007 13:31:40 -0500 (EST) Date: Thu, 15 Feb 2007 13:31:40 -0500 From: Ray Stell To: "Andy Shellam (Mailing Lists)" Cc: pgsql-admin@postgresql.org Subject: Re: rename a cluster Message-ID: <20070215183140.GA22753@cns.vt.edu> References: <20070215171940.GA21838@cns.vt.edu> <200702151836.24296.peter_e@gmx.net> <20070215180143.GC21838@cns.vt.edu> <45D4A491.5060108@mailnetwork.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45D4A491.5060108@mailnetwork.co.uk> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200702/225 X-Sequence-Number: 24690 Many thx. It that in the doc? On Thu, Feb 15, 2007 at 06:21:05PM +0000, Andy Shellam (Mailing Lists) wrote: > The cluster's "name" is only the file-system's directory path. > > You can easily rename this directory, as long as you pass the relevant > directory name to pg_ctl's -D parameter (which tells PostgreSQL which > database "cluster" to use.) > > It goes without saying, don't move the directory while PostgreSQL is > running. > > > Ray Stell wrote: > >On Thu, Feb 15, 2007 at 06:36:23PM +0100, Peter Eisentraut wrote: > > > >>Ray Stell wrote: > >> > >>>Is there a method to rename a cluster? > >>> > >>Clusters don't have names in the first place. > >> > > > >So, from 16.2 "Creating a Database Cluster" > > > >"...you must initialize a database storage area on disk. > >We call this a database cluster." > > > >then, directory = cluster, no? > > > >What I was trying to get at is, is mv of the dir ok or > >is there something else that needs to be considered? Thx. > > > >---------------------------(end of broadcast)--------------------------- > >TIP 2: Don't 'kill -9' the postmaster > > > >!DSPAM:37,45d4a11118511420134615! > > > > > > > > > -- > Andy Shellam > NetServe Support Team > > the Mail Network > "an alternative in a standardised world" > > p: +44 (0) 121 288 0832/0839 > m: +44 (0) 7818 000834 > -- You have no chance to survive make your time.