Postgres Pro
Downloads
Home   >   mailing lists

pg_upgrade in primary/standby architecture - Mailing list pgsql-admin

From Murthy Nunna
Subject pg_upgrade in primary/standby architecture
Date
Msg-id BD7563973EF8894D905C80593EE9A4ED34B0CF@MAIL02.fnal.gov
Whole thread Raw
Responses Re: pg_upgrade in primary/standby architecture  (Venkata Balaji Nagothi <vbnpgc@gmail.com>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Kasia Tuszynska
Date:
Subject: Re: looking for doc
Next
From: Venkata Balaji Nagothi
Date:
Subject: Re: pg_upgrade in primary/standby architecture