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

Re: Moving database install to new SAN

From: Andrzej Zawadzki <zawadaa(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Moving database install to new SAN
Date: 2007-09-13 21:14:05
Message-ID: 46E9A81D.90309@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Użytkownik Tino Schwarze napisał:
> 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
Not yet...

> 2. copy whole data directory over to new SAN
If database is big, then I think that is much faster to copy running
database
to new SAN.
Then stop postgres and rsync what was changed - but this will be probably
only a few files.

> 3. start postgres with new data directory

Minimal downtime I think.

Best regards

-- 
Andrzej Zawadzki

In response to

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2007-09-14 04:16:14
Subject: Re: tar, but not gnu tar
Previous:From: Tino SchwarzeDate: 2007-09-13 20:39:46
Subject: Re: Moving database install to new SAN

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