From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: Moving database install to new SAN
Date: Thu, 13 Sep 2007 22:39:46 +0200
Message-ID: <20070913203946.GE6423@easy2.in-chemnitz.de> (raw)
In-Reply-To: <507905.14268.qm@web57114.mail.re3.yahoo.com>
References: <507905.14268.qm@web57114.mail.re3.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql@tisc.de
Subject: Re: Moving database install to new SAN
In-Reply-To: <20070913203946.GE6423@easy2.in-chemnitz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox