Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e26TU-00031V-8F for pgsql-admin@arkaria.postgresql.org; Wed, 11 Oct 2017 02:10:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e26TT-00029n-8N for pgsql-admin@arkaria.postgresql.org; Wed, 11 Oct 2017 02:10:19 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e26TS-00029M-Ok for pgsql-admin@postgresql.org; Wed, 11 Oct 2017 02:10:18 +0000 Received: from mail-qt0-x233.google.com ([2607:f8b0:400d:c0d::233]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1e26TL-0004Gc-MH for pgsql-admin@postgresql.org; Wed, 11 Oct 2017 02:10:17 +0000 Received: by mail-qt0-x233.google.com with SMTP id o52so1131555qtc.9 for ; Tue, 10 Oct 2017 19:10:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=openscg-com.20150623.gappssmtp.com; s=20150623; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=lNrcQ2KWC1g6JFDKr/2dY7TscYupDe7T1h0uBmRxZ9I=; b=NHZICi+1XKnk2iVhxFX2wWcIkbhOZcwreRKvstsR9cd261Y7r4tYm4gwmyos1VASi9 NaLvahR87rT4iXoC8VBNqnwMdz5C1qFbuI0B2YHD1FRZyM8BWrlPycsgAkOnJ7GENwRP v4I0+msSZZHPoam9J8SrVHuWrx1/sz1SYEIQH1beCEPKCSkMX2DBamwtyy5GyZyJshvE FDPsH0cuk+IFViTg8N7nV5qqIL9gw8BsG6rQnLdO1XC3C76tuJxz0/FU39mEjuag0FIX Tzh6tMORxdjkjrQUfd4b1ZhXI5GS/L1ppd+2vEM9S1zSEZYtJ4bGwcohgmqwJMLBRjHy 3h6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=lNrcQ2KWC1g6JFDKr/2dY7TscYupDe7T1h0uBmRxZ9I=; b=VRn23YtN4secR7emTyhznwImTih9kNlgU/c2oec4+AjVmso964z6c/d4m+3k14IQS+ KBkSSq0g2UHk0KPpfX+evTd6VpPVc1IeXgZGb9gdU+dG6gqv3mPmiqi8IluolEHdnEX2 61qIm40/H42ij/OGNLP0zxQrn3yESYT03pALtHm1ZanudmUR9+AkyRzlNGVkR0GZNO0r Lfhn00kNVS5+7PuXId59OFOGdSB1tdzgXxEaliPeJw1uAa6MLK2gFlOvdf/YQyAGdOVU SuqrQYbxzDimvpPhZy56ZW2SKhSY43fK0SRvq3BAiwpAc8sDRm0s1FCyOX41tsNe7hBy stxg== X-Gm-Message-State: AMCzsaXuISZjV+1/iuJD4LHuDmUqafsszp7HSRBrKfdh4XrHxJ3zz4pI v042N2b7jlb3149ZOrF6rJ0Zsg== X-Google-Smtp-Source: AOwi7QA9haByL6VfufwsrE85Ivv4DJbRDeOK8WJAz9iV096WVHuNqxSlhi2ui5LwSoEodUyk6eNHOw== X-Received: by 10.55.212.219 with SMTP id s88mr16782496qks.188.1507687810013; Tue, 10 Oct 2017 19:10:10 -0700 (PDT) Received: from [192.168.115.100] (cpe-66-66-220-41.rochester.res.rr.com. [66.66.220.41]) by smtp.gmail.com with ESMTPSA id v189sm7301864qkb.46.2017.10.10.19.10.08 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 10 Oct 2017 19:10:08 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-27A749C8-0430-41F1-9B1B-003414CD9092 Mime-Version: 1.0 (1.0) Subject: Re: Can master and slave on different PG versions? From: Scott Mead X-Mailer: iPhone Mail (15A402) In-Reply-To: Date: Tue, 10 Oct 2017 22:10:07 -0400 Cc: Scott Marlowe , "pgsql-admin@postgresql.org" Content-Transfer-Encoding: 7bit Message-Id: References: To: rammohan ganapavarapu List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --Apple-Mail-27A749C8-0430-41F1-9B1B-003414CD9092 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable > On Oct 10, 2017, at 11:49, rammohan ganapavarapu = wrote: >=20 > I am getting this error when i try to add 9.6 slave to 9.4 master. >=20 > < 2017-10-09 22:56:31.081 UTC > FATAL: database files are incompatible wi= th server > < 2017-10-09 22:56:31.081 UTC > DETAIL: The data directory was initialize= d by PostgreSQL version 9.4, which is not compatible with this version 9.6.1= . >=20 > Ram No, you cannot do that with physical streaming replication. They must be th= e same major version number. 9.5 -> 9.5. =20 >=20 >> On Tue, Oct 10, 2017 at 8:26 AM, Scott Marlowe w= rote: >> On Mon, Oct 9, 2017 at 5:06 PM, rammohan ganapavarapu >> wrote: >> > Hi, >> > >> > Is it possible to add 9.6 version Slave to 9.4 master? >>=20 >> 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. >=20 --Apple-Mail-27A749C8-0430-41F1-9B1B-003414CD9092 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

On Oct 10, 2017, at 11:49, ram= mohan ganapavarapu <rammohanga= nap@gmail.com> wrote:

I am getting this error when i try to add 9.6 slave to 9.4 mas= ter.

< 2017-10-09 22:56:31.081 UTC > FATAL: data= base files are incompatible with server < 2017-10-09 22:56:31.081 UTC > DETAIL: The data directory was initia= lized by PostgreSQL version 9.4, which is not compatible with this version 9= .6.1.

Ram
<= /div>

No, you cannot do that with physical s= treaming replication.  They must be the same major version number. 9.5 -= > 9.5.  


On Tue, Oct 10, 2017 at 8:26 AM, Scot= t Marlowe <scott.marlowe@gmail.com> wrote:
On Mon, Oct 9, 2017 at 5:06 PM, rammoha= n ganapavarapu
<rammohanganap@gmail.com&g= t; 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 plac= e
with a few seconds switch over time.  It's not as complex as it first appears, but test on something other than production please.

= --Apple-Mail-27A749C8-0430-41F1-9B1B-003414CD9092--