Postgres Pro
Downloads
Home   >   mailing lists

Re: Using 9.3 as a slave to 9.1 for upgrade purposes - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Using 9.3 as a slave to 9.1 for upgrade purposes
Date
Msg-id 20140422231213.GA10075@momjian.us
Whole thread Raw
In response to Using 9.3 as a slave to 9.1 for upgrade purposes  (Wells Oliver <wellsoliver@gmail.com>)
List pgsql-general
Tree view 
On Tue, Apr 22, 2014 at 03:52:19PM -0700, Wells Oliver wrote:
> As a way of upgrading, I'd like to setup a 9.3 cluster as a slave to a 9.1
> master so that I can then promote that 9.3 instance to master, using streaming
> replication.
>
> Curious if this is a possible/advisable route.

Streaming replication has to use the same major PG version. You can do
that with Slony.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

pgsql-general by date:

Previous
From: Wells Oliver
Date:
Subject: Using 9.3 as a slave to 9.1 for upgrade purposes
Next
From: Adrian Klaver
Date:
Subject: Re: Using 9.3 as a slave to 9.1 for upgrade purposes