From: Cédric Villemain <cedric.villemain@dalibo.com>
To: pgsql-admin@postgresql.org
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Chris Hoover <revoohc@gmail.com>
Cc: Andrzej Zawadzki <zawadaa@gmail.com>
Subject: Re: Moving database install to new SAN
Date: Fri, 21 Sep 2007 14:29:42 +0200
Message-ID: <200709211429.47837.cedric.villemain@dalibo.com> (raw)
In-Reply-To: <46F2B8E6.4010108@commandprompt.com>
References: <507905.14268.qm@web57114.mail.re3.yahoo.com>
<1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com>
<46F2B8E6.4010108@commandprompt.com>
Le jeudi 20 septembre 2007, Joshua D. Drake a écrit :
> Chris Hoover wrote:
> >>> 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.
> >
> > I believe if you do this, you will not get a function database in the
> > end. There is a lot of data that is held in memory/buffers that may not
> > be flushed to the disks. You have no guarantee you will get this data
> > with this method.
>
> The method would work if they are willing to have an outage. Basically
> you do an initial rsync of the large db...
Perhaps using some tablespace to move the bigest data, then rsync ...
>
> Then you shut down the db.
>
> And rsync again, which will be faster than doing a complete move with
> shutdown.
>
> The key here is, if you use this method... there is *zero* way around
> shutting down the database before the second rsync.
>
>
> Sincerely,
>
> Joshua D. Drake
--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.orgAttachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cedric.villemain@dalibo.com, jd@commandprompt.com, revoohc@gmail.com, zawadaa@gmail.com
Subject: Re: Moving database install to new SAN
In-Reply-To: <200709211429.47837.cedric.villemain@dalibo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox