From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Wells Oliver <wellsoliver(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Using 9.3 as a slave to 9.1 for upgrade purposes |
Date: | 2014-04-22 23:20:01 |
Message-ID: | 5356F921.9070502@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/22/2014 03:52 PM, 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.
Not possible with streaming replication. It is a binary format so the
version and system architecture have to be the same on both sides of the
equation. You would need to use another replication method, say
something like Slony. For more information see here:
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
>
> --
> Wells Oliver
> wellsoliver(at)gmail(dot)com <mailto:wellsoliver(at)gmail(dot)com>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | AI Rumman | 2014-04-22 23:58:07 | Is it good to have toast table for information schema table? |
Previous Message | Bruce Momjian | 2014-04-22 23:12:13 | Re: Using 9.3 as a slave to 9.1 for upgrade purposes |