Hi rob,
It is not possible to take streaming replication between two major versions as by taking basebackup all the data directory of lower is copied which are not changed in this case version is not changed.
You may better go with slony replication in which replication between two different major versions can be taken efficiently for which you have to take dump of empty schema and then restore it the other version of postgresql and then run scripts to setup replication between postgresql 9.1.10 master and postgresql 9.3.5 slave.
Thanks & Regards
Venkataramana Aitla
Shreeyansh Technologies
www.shreeyansh.com
On Jan 9, 2015 10:48 PM, "Rob Cowell" <
rob.cowell@transversal.com> wrote:
Hi,
Is it possible to set up replication from a 9.1.10 master to a 9.3.5 slave?
I've taken a base-backup from the master and rsync'd it over to the slave but I'm seeing the following error :
HINT: It looks like you need to initdb.
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?) :)
Cheers,
Rob.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin