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: (view raw, whole thread or download thread mbox)
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
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


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-2018 The PostgreSQL Global Development Group