pg_upgrade in primary/standby architecture

From: Murthy Nunna <mnunna(at)fnal(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: pg_upgrade in primary/standby architecture
Date: 2014-03-18 02:52:34
Message-ID: BD7563973EF8894D905C80593EE9A4ED34B0CF@MAIL02.fnal.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Venkata Balaji Nagothi 2014-03-18 05:46:59 Re: pg_upgrade in primary/standby architecture
Previous Message Kasia Tuszynska 2014-03-17 22:51:44 Re: looking for doc