Re: Can master and slave on different PG versions?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Oct 10, 2017 at 9:49 AM, rammohan ganapavarapu
<rammohanganap@xxxxxxxxx> wrote:
>
> On Tue, Oct 10, 2017 at 8:26 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx>
> wrote:
>>
>> On Mon, Oct 9, 2017 at 5:06 PM, rammohan ganapavarapu
>> <rammohanganap@xxxxxxxxx> wrote:
>> > Hi,
>> >
>> > Is it possible to add 9.6 version Slave to 9.4 master?
>>
>> Standard usage for Slony. I've used it for dozens of upgrades in place
>> with a few seconds switch over time.  It's not as complex as it first
>> appears, but test on something other than production please.

> I am getting this error when i try to add 9.6 slave to 9.4 master.
>
> < 2017-10-09 22:56:31.081 UTC > FATAL: database files are incompatible with
> server < 2017-10-09 22:56:31.081 UTC > DETAIL: The data directory was
> initialized by PostgreSQL version 9.4, which is not compatible with this
> version 9.6.1.

Please don't top post.

So Are you trying to use streaming replication? That won't work. I was
suggesting using Slony for replication if you need to do that.

http://slony.info/documentation/index.html

It's a trigger based replication engine for postgresql designed back
in the early days and useful for replication between different
versions.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux