Обсуждение: Replicating from 9.1.10 into 9.3.5

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_VERSION937. 

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.

Rob Cowell 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.

If you mean ongoing streaming replication then, as indicated from the error
message you are getting, no, you cannot mix server versions.

Only logical replication can do that; which, for you, would be a third-party
solution.

David J.



--
View this message in context: http://postgresql.nabble.com/Replicating-from-9-1-10-into-9-3-5-tp5833423p5833424.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

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_VERSION937. 
>
> 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

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