From: Scott Mead <scottm@openscg.com>
To: rammohan ganapavarapu <rammohanganap@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Can master and slave on different PG versions?
Date: Tue, 10 Oct 2017 22:10:07 -0400
Message-ID: <B193043A-AEFA-41A5-A45D-5A80839DB413@openscg.com> (raw)
In-Reply-To: <CALm_VjgLH=tdCjzFNGhte1L5=eWSmMvbg0WzYAMgOLG-UzFGVQ@mail.gmail.com>
References: <CALm_Vjg-vtuCv4zJxukE9VdQoF96bFo2ukQddzPQRMH3i9HF9A@mail.gmail.com>
<CAOR=d=3GdeQW73=668VQor7dPXypkB7rDBPzPkkP591pbNrohg@mail.gmail.com>
<CALm_VjgLH=tdCjzFNGhte1L5=eWSmMvbg0WzYAMgOLG-UzFGVQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> On Oct 10, 2017, at 11:49, rammohan ganapavarapu <rammohanganap@gmail.com> wrote:
>
> 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.
>
> Ram
No, you cannot do that with physical streaming replication. They must be the same major version number. 9.5 -> 9.5.
>
>> On Tue, Oct 10, 2017 at 8:26 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>> On Mon, Oct 9, 2017 at 5:06 PM, rammohan ganapavarapu
>> <rammohanganap@gmail.com> 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.
>
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: scottm@openscg.com, rammohanganap@gmail.com, scott.marlowe@gmail.com
Subject: Re: Can master and slave on different PG versions?
In-Reply-To: <B193043A-AEFA-41A5-A45D-5A80839DB413@openscg.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