pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.org

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (6+ messages)

Message-ID: <200709211429.47837.cedric.villemain@dalibo.com>
Permalink:  ../200709211429.47837.cedric.villemain@dalibo.com/
Also on:    postgresql.org/message-id/200709211429.47837.cedric.villemain@dalibo.com

 · 

reply

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