Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A21829F9B5B for ; Thu, 13 Sep 2007 17:39:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 14526-06 for ; Thu, 13 Sep 2007 17:39:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id 8F1DF9F9C5B for ; Thu, 13 Sep 2007 17:39:47 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 3E778B1FA9 for ; Thu, 13 Sep 2007 22:39:46 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ofWmAnKHyLIt for ; Thu, 13 Sep 2007 22:39:46 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 2D0EEB1F7D; Thu, 13 Sep 2007 22:39:46 +0200 (CEST) Date: Thu, 13 Sep 2007 22:39:46 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Moving database install to new SAN Message-ID: <20070913203946.GE6423@easy2.in-chemnitz.de> References: <507905.14268.qm@web57114.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <507905.14268.qm@web57114.mail.re3.yahoo.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/94 X-Sequence-Number: 26855 On Thu, Sep 13, 2007 at 01:15:34PM -0700, Abu Mushayeed wrote: > Can someone help me with moving a postgres database install to a new > SAN disks. We are getting a new set of faster disk, I would like to > find out is there a way, without reinstall to move existing database > and data to the new disks with minimal downtime. If you cannot move online with some SAN tools, you may simply 1. stop postgres 2. copy whole data directory over to new SAN 3. start postgres with new data directory Nothing tricky there. What size is you db space? What OS are you running PostgreSQL on? Tino. -- www.spiritualdesign-chemnitz.de www.lebensraum11.de Tino Schwarze * Parkstraße 17h * 09120 Chemnitz