Re: Moving database install to new SAN - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: Moving database install to new SAN
Date
Msg-id 20070913203946.GE6423@easy2.in-chemnitz.de
Whole thread Raw
In response to Moving database install to new SAN  (Abu Mushayeed <abumushayeed@yahoo.com>)
Responses Re: Moving database install to new SAN  (Andrzej Zawadzki <zawadaa@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Abu Mushayeed
Date:
Subject: Moving database install to new SAN
Next
From: Andrzej Zawadzki
Date:
Subject: Re: Moving database install to new SAN