Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1emfH7-0002Qo-7z for pgsql-admin@arkaria.postgresql.org; Fri, 16 Feb 2018 12:38:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1emfH5-0002E0-Uo for pgsql-admin@arkaria.postgresql.org; Fri, 16 Feb 2018 12:37:59 +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 1emfH5-0002Dq-KD for pgsql-admin@lists.postgresql.org; Fri, 16 Feb 2018 12:37:59 +0000 Received: from mout.perfora.net ([74.208.4.196]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1emfGy-0000PK-Uk for pgsql-admin@postgresql.org; Fri, 16 Feb 2018 12:37:58 +0000 Received: from [192.168.1.101] ([98.169.215.140]) by mrelay.perfora.net (mreueus001 [74.208.5.2]) with ESMTPSA (Nemesis) id 0LzZYq-1ehWn03voA-014oUH; Fri, 16 Feb 2018 13:37:41 +0100 Message-ID: <5A86D093.9030708@sqlexec.com> Date: Fri, 16 Feb 2018 07:37:39 -0500 From: MichaelDBA User-Agent: Postbox 5.0.22 (Windows/20171208) MIME-Version: 1.0 To: Guillaume Lelarge CC: =?UTF-8?B?ScOxaWdvIFNhbHZhdA==?= , pgsql-admin Subject: Re: Migrate streaming replication 9.4 to 9.6 References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------040003040601020302020005" X-Provags-ID: V03:K0:Y1bXnE9xDZ9u8DkoPfCOAq5oovNSbglboufUZQyWg+EP6RYd9rp y+u57q7eBxhGGZLZfrP0nmr1YGsSpxLJ60cvOf1dZEwoolUqo1SXtc0RpqSipLRIhzTg2E6 QxWxzj/A6n4yfbqvCMMS28qBJv4E0g1SM79iiGgbj0cYxXNO1eZUBkrlA0/U/T/CIjgqCsO srSzr/9kG6oeGa/cc93jQ== X-UI-Out-Filterresults: notjunk:1;V01:K0:tVYwcw2l7lk=:09smjKuyV5VBkt7cvkixHb FKXV34tjS6FpaSPUbmIKhYfrzJpCcOHZ8ZeQR4bynqr3NtMOjoY6lOvHUcmCNFnMttNOwrcsv LVuz1/3XR7++iC7QujumbKo2Gw3eUYauWDvmtVbefcxEdsJKXkz+wHKPoeoHl51nguX7/YkS5 PLEb5smcK3J6hPly5osktJ7Rc6adcOBvaRKoYKHc8WbWTY2a9BtfjMYVDT3SvaBJRGCnPbQQW Xm6KGgienur931HZLz6xRyGI6ZhrniaHHliZjN3NaBhe6KdUyRB6Y6UdGDBw9AYIPtzp4bXv8 2GzY0nHqOjInj79scf7k2pLHTRJPzxvuenHwdMBT65v2HocHFtZnsIa/Tp+NhBciaE8MKEs9G slZb0UIwJSc9BINv3ThvSE6ghz2nH8GvXbFlub/LhVQX+8L/cUyOn7ZaqvqCk0adSrMnfC1Qd jQ1sFysHkzW/k6aokKmBE6sUgiidBgNnx/o9oIVzmS87CefquMxdClKHTJQReq+Ydk7k21jR8 HBfwkfrkZdHwANs/7alodqymwPk1Gu44UEZbU4/QuvGHaBbm7Eld0FHtCNwyxJNzuDgZa5vE5 vmIx+iWPKZMHsjujN36NtYVwt000PAzhMsO2kGQmc1BPSVevY3HaGSSwgiZ2ZTASs52glWSN5 2O//m2SAG2nTxCl5LW73mYNAcQ8h1V5fct6HC+opKneMVDmSuZn1YpTlrI4n1glkGH7uZZGXT pPD575Aif0TUNyXnyBZSLVCQRPS0sU4fH0oX3jujfiBs94hLFcMf/oTUGTs= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------040003040601020302020005 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit pglogical can do major upgrades starting at version 9.4 and up, so startup a 9.6 logical replication from the 9.4 master and failover over to the 9.6 replica when you want to go live with the new version. Regards, Michael Vitale > Guillaume Lelarge > Friday, February 16, 2018 2:18 AM > Hi, > > Hi all, > > I need to migrate a couple of servers running postgresql 9.4 been > syncro with streaming replication to postgresql 9.6. Obviously the > service could not be stopped. > > Does any of you test to syncro data via streaming replication from > a source in 9.4 and a target in 9.6? > > Do you have a "howto" tested? > > > You can't. Streaming replication requires you use the same major > version on all the nodes. > > > -- > Guillaume. > Iñigo Salvat > Friday, February 16, 2018 1:16 AM > Hi all, > > I need to migrate a couple of servers running postgresql 9.4 been > syncro with streaming replication to postgresql 9.6. Obviously the > service could not be stopped. > > Does any of you test to syncro data via streaming replication from a > source in 9.4 and a target in 9.6? > > Do you have a "howto" tested? > > Many thanks, > --------------040003040601020302020005 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit pglogical can do major upgrades starting at version 9.4 and up,  so startup a 9.6 logical replication from the 9.4 master and failover over to the 9.6 replica when you want to go live with the  new version.

Regards,
Michael Vitale


Friday, February 16, 2018 2:18 AM
Hi,

Hi all,

I need to migrate a couple of servers running postgresql 9.4 been syncro with streaming replication to postgresql 9.6. Obviously the service could not be stopped.

Does any of you test to syncro data via streaming replication from a source in 9.4 and a target in 9.6?

Do you have a "howto" tested?


You can't. Streaming replication requires you use the same major version on all the nodes.


--
Guillaume.
Friday, February 16, 2018 1:16 AM
Hi all,

I need to migrate a couple of servers running postgresql 9.4 been syncro with streaming replication to postgresql 9.6. Obviously the service could not be stopped.

Does any of you test to syncro data via streaming replication from a source in 9.4 and a target in 9.6?

Do you have a "howto" tested?

Many thanks,


--------------040003040601020302020005--