Using 9.3 as a slave to 9.1 for upgrade purposes
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.
--
Wells Oliver
wellsoliver@gmail.com
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. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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@gmail.com <mailto:wellsoliver@gmail.com>
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general