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
> 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.
In response to
pgsql-admin by date
|Next:||From: Bruce Momjian||Date: 2007-09-14 04:16:14|
|Subject: Re: tar, but not gnu tar|
|Previous:||From: Tino Schwarze||Date: 2007-09-13 20:39:46|
|Subject: Re: Moving database install to new SAN|