Thread: Migrate streaming replication 9.4 to 9.6

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,

-- 
Iñigo Salvat

__________________
La presente información se envía únicamente para la persona a la que va 
dirigida y puede contener información de carácter confidencial o 
privilegiada. Cualquier modificación, retransmisión, difusión u otro uso 
de esta información por personas o entidades distintas a la persona a la 
que va dirigida está prohibida. Si usted lo ha recibido por error por 
favor contacte con el remitente y borre el mensaje de cualquier 
ordenador. Para el caso de que este mensaje vaya a ser contestado por la 
misma vía, ha de saberse que su respuesta podría ser conocida por 
terceros al entrar en la red. Por ello, si el mensaje incluye 
contraseñas, números de tarjetas de crédito o cualquier otra información 
que usted considere confidencial, sería más seguro contestar por otra 
vía y cancelar su transmisión. El autor no puede asumir la 
responsabilidad derivada del hecho de que terceras personas puedan 
llegar a conocer el contenido de este mensaje durante su transmisión.

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,

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

Regards,

Iñigo

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,