Postgres Pro
Downloads
Home   >   mailing lists

Re: Migrate streaming replication 9.4 to 9.6 - Mailing list pgsql-admin

From MichaelDBA
Subject Re: Migrate streaming replication 9.4 to 9.6
Date
Msg-id 5A86D093.9030708@sqlexec.com
Whole thread Raw
In response to Re: Migrate streaming replication 9.4 to 9.6  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Migrate streaming replication 9.4 to 9.6
List pgsql-admin
Tree view
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,


pgsql-admin by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: How to download minor version
Next
From: Laurenz Albe
Date:
Subject: Re: postgres not starting