Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group