From: Joshua D. Drake <jd@commandprompt.com>
To: Chris Hoover <revoohc@gmail.com>
Cc: Andrzej Zawadzki <zawadaa@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Moving database install to new SAN
Date: Thu, 20 Sep 2007 11:16:06 -0700
Message-ID: <46F2B8E6.4010108@commandprompt.com> (raw)
In-Reply-To: <1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com>
References: <507905.14268.qm@web57114.mail.re3.yahoo.com>
<20070913203946.GE6423@easy2.in-chemnitz.de>
<46E9A81D.90309@gmail.com>
<1d219a6f0709201110r603e1d4dg8cc4f514201a65ab@mail.gmail.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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...
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
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG8rjmATb/zqfZUUQRAs5bAJ9Avhtd0KgQfta1YqN5IX75M3I0awCdHuna
suRxLPewL/v2t4w1t7K3eyM=
=0rQC
-----END PGP SIGNATURE-----
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: jd@commandprompt.com, revoohc@gmail.com, zawadaa@gmail.com
Subject: Re: Moving database install to new SAN
In-Reply-To: <46F2B8E6.4010108@commandprompt.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