pg_upgrade in primary/standby architecture

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

 



Hello PGAdmins,

 

I am wondering if there is a way we can leverage replication set up to minimize outage caused by pg_upgrade in case of major version upgrade. We use streaming replication.

 

Scenario:

1.      Primary and standby are running 9.1.6 and I want to upgrade both to 9.2.4 (or 9.2.6)

2.      Streaming replication is used

3.      I cannot use pg_dump due to the size of the database. I have to use pg_upgrade

 

Thanks,

Murthy


[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