From: | Murthy Nunna <mnunna(at)fnal(dot)gov> |
---|---|
To: | Venkata Balaji Nagothi <vbnpgc(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade in primary/standby architecture |
Date: | 2014-03-18 12:49:16 |
Message-ID: | BD7563973EF8894D905C80593EE9A4ED34B2F8@MAIL02.fnal.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Venkata Balaji,
Thank you!
Yes, streaming replication cannot be setup between two different versions. That is true.
I am looking to upgrade both primary and standby with minimal outage to application..... I want to know if it is possible. If it is not possible, is there any architecture where we can minimize upgrade related outage?
Murthy
From: Venkata Balaji Nagothi [mailto:vbnpgc(at)gmail(dot)com]
Sent: Tuesday, March 18, 2014 12:47 AM
To: Murthy Nunna
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] pg_upgrade in primary/standby architecture
On Tue, Mar 18, 2014 at 1:52 PM, Murthy Nunna <mnunna(at)fnal(dot)gov<mailto:mnunna(at)fnal(dot)gov>> wrote:
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.
If i got you correct - Streaming Replication cannot be setup between two different versions of PostgreSQL.
Scenario:
1. Primary and standby are running 9.1.6 and I want to upgrade both to 9.2.4 (or 9.2.6)
Though its not an straight forward or easy way to upgrade a big database - Did you think of Slony as an option ?
We have used Slony in the past to upgrade databases to reduce lengthy downtime. This depends on lot of factors though.
Regards.
Venkata Balaji N
Sr. Database Administrator
Fujitsu Australia
From | Date | Subject | |
---|---|---|---|
Next Message | Glyn Astill | 2014-03-18 13:25:40 | Re: pg_upgrade in primary/standby architecture |
Previous Message | Venkata Balaji Nagothi | 2014-03-18 05:46:59 | Re: pg_upgrade in primary/standby architecture |