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 1emx1I-0006le-Cf for pgsql-admin@arkaria.postgresql.org; Sat, 17 Feb 2018 07:34:52 +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 1emx1H-0006xv-2K for pgsql-admin@arkaria.postgresql.org; Sat, 17 Feb 2018 07:34:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1emx1G-0006xm-Re for pgsql-admin@lists.postgresql.org; Sat, 17 Feb 2018 07:34:50 +0000 Received: from smtp-out2.electric.net ([208.70.129.180]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1emx1E-0006HI-7M for pgsql-admin@lists.postgresql.org; Sat, 17 Feb 2018 07:34:50 +0000 Received: from 1emx19-00075e-V0 by out2b.electric.net with emc1-ok (Exim 4.87) (envelope-from ) id 1emx1B-00076b-U9 for pgsql-admin@lists.postgresql.org; Fri, 16 Feb 2018 23:34:45 -0800 Received: by emcmailer; Fri, 16 Feb 2018 23:34:45 -0800 Received: from [10.86.10.83] (helo=fuseout2c.electric.net) by out2b.electric.net with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.87) (envelope-from ) id 1emx19-00075e-V0 for pgsql-admin@lists.postgresql.org; Fri, 16 Feb 2018 23:34:43 -0800 Received: from mailanyone.net by fuseout2c.electric.net with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (MailAnyone extSMTP inigo@isalvat.es) id 1emx19-0004tV-9j for pgsql-admin@lists.postgresql.org; Fri, 16 Feb 2018 23:34:43 -0800 Subject: Re: Migrate streaming replication 9.4 to 9.6 To: pgsql-admin@lists.postgresql.org References: <5A86D093.9030708@sqlexec.com> From: =?UTF-8?Q?I=c3=b1igo_Salvat?= Message-ID: Date: Sat, 17 Feb 2018 08:34:41 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: <5A86D093.9030708@sqlexec.com> Content-Type: multipart/alternative; boundary="------------7E5911DB49D3C48C477C21DD" Content-Language: es-ES X-FM-Out: [10.12.48.95] / 81.32.206.228 / inigo@isalvat.es X-Outbound-IP: 10.86.10.83 X-Env-From: inigo@isalvat.es X-Proto: esmtps X-Revdns: fuseout2c.electric.net X-HELO: fuseout2c.electric.net X-TLS: TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256 X-Authenticated_ID: X-PolicySMART: 872319 X-Virus-Status: Scanned by VirusSMART (c) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------7E5911DB49D3C48C477C21DD Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Thanks to all of you. I'll test the pglogical Regards, Iñigo El 16/02/18 a las 13:37, MichaelDBA escribió: > 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, >> > --------------7E5911DB49D3C48C477C21DD Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Thanks to all of you. I'll test the pglogical

Regards,

Iñigo


El 16/02/18 a las 13:37, MichaelDBA escribió:
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,



--------------7E5911DB49D3C48C477C21DD--