From: Steve Crawford <scrawford@pinpointresearch.com>
To: Rob Cowell <rob.cowell@transversal.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Replicating from 9.1.10 into 9.3.5
Date: Fri, 09 Jan 2015 09:26:14 -0800
Message-ID: <54B00F36.70801@pinpointresearch.com> (raw)
In-Reply-To: <1Y9dC8-0002qL-2Y@l31.mail.transversal.net>
References: <1Y9dC8-0002qL-2Y@l31.mail.transversal.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 01/09/2015 09:17 AM, Rob Cowell wrote:
> Hi,
>
> Is it possible to set up replication from a 9.1.10 master to a 9.3.5 slave?
For streaming log-based replication the answer is no:
> FATAL: database files are incompatible with server
> DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 903, but the server was compiled with PG_CONTROL_VERSION 937.
>
> Would I be better off dumping the data from 9.1.10 and re-importing into 9.3.5, then starting replication ?
> (or is there an easier way?) :)
There are lots of options. IIRC, Slony can be used for cross-version
replication. Pg_upgrade can be used instead of a dump and restore. Which
is easiest depends on your operational constraints.
Of all the methods, "old-reliable" is a dump and restore. Set up
replication after that. Be sure to use pg_dump from the *new* version to
take the dump from the old database. And if you are going through the
effort to upgrade, consider 9.4.0 at this point.
There is work to support statement-based replication which will probably
support replication-based upgrades in the future. But not from your version.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, rob.cowell@transversal.com
Subject: Re: Replicating from 9.1.10 into 9.3.5
In-Reply-To: <54B00F36.70801@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox