Re: Bloated pg_shdepend_depender_index

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

 





Andy Shellam wrote:
This is true, but you could run the new version on the same server/different
port to the current version, and do a simultaneous dump/restore without
having to use extra disk space, or taking your production database offline -
then you can schedule a time to kill the old one, re-assign the port on the
new one and bring it up - would take about 30 seconds, and this could be
done at a time when traffic was at its lowest.


Hmmm - Interesting solution!
Does you know of anybody that have tried an upgrade migration like this, and experience with very large databases?

--
-------------------------------------
Ola Sandbu       tel: (+47)22840197
USIT/SAPP-DBA    mob: (+47)91594704
mailto:Ola.Sandbu@xxxxxxxxxxx
-------------------------------------


[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