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 |