Re: Moving database install to new SAN

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Moving database install to new SAN
Date: 2007-09-13 20:39:46
Message-ID: 20070913203946.GE6423@easy2.in-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrzej Zawadzki 2007-09-13 21:14:05 Re: Moving database install to new SAN
Previous Message Abu Mushayeed 2007-09-13 20:15:34 Moving database install to new SAN