Re: Replicating from 9.1.10 into 9.3.5

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(dot)cowell(at)transversal(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>