Re: Moving database install to new SAN

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux