Re: Moving database install to new SAN

-----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-----