Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BCEEF9FB791 for ; Fri, 16 Feb 2007 17:58:22 -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 12329-01 for ; Fri, 16 Feb 2007 17:58:19 -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 C67749FB6A6 for ; Fri, 16 Feb 2007 17:58:19 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 9B468118A36; Fri, 16 Feb 2007 16:58:18 -0500 (EST) Date: Fri, 16 Feb 2007 16:58:18 -0500 From: Ray Stell To: Bruce Momjian Cc: Peter Eisentraut , pgsql-admin@postgresql.org Subject: Re: rename a cluster Message-ID: <20070216215818.GA28345@cns.vt.edu> References: <200702151931.26298.peter_e@gmx.net> <200702162135.l1GLZek16563@momjian.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200702162135.l1GLZek16563@momjian.us> 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/244 X-Sequence-Number: 24709 On Fri, Feb 16, 2007 at 04:35:40PM -0500, Bruce Momjian wrote: > Peter Eisentraut wrote: > > Renaming the directory is OK. Just make sure your init script or > > whatever finds it. > > Oh, and make sure the postmaster isn't running when you do the rename. Right, there are a few operational considerations. I think this topic should be get documented. I didn't know if there was anything internal from the initdb and didn't see the answer anywhere. Really good news found here on this topic. Everyday seems to bring more good stuff from pg-land. I go live with three more apps with pg backends in the morning, converted from oracle, btw ;)