pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigrate streaming replication 9.4 to 9.6
4+ messages / 3 participants
[nested] [flat]
* Migrate streaming replication 9.4 to 9.6
@ 2018-02-16 06:16 Iñigo Salvat <inigo@isalvat.es>
2018-02-16 07:18 ` Re: Migrate streaming replication 9.4 to 9.6 Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 4+ messages in thread
From: Iñigo Salvat @ 2018-02-16 06:16 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Migrate streaming replication 9.4 to 9.6
2018-02-16 06:16 Migrate streaming replication 9.4 to 9.6 Iñigo Salvat <inigo@isalvat.es>
@ 2018-02-16 07:18 ` Guillaume Lelarge <guillaume@lelarge.info>
2018-02-16 12:37 ` Re: Migrate streaming replication 9.4 to 9.6 MichaelDBA <MichaelDBA@sqlexec.com>
0 siblings, 1 reply; 4+ messages in thread
From: Guillaume Lelarge @ 2018-02-16 07:18 UTC (permalink / raw)
To: Iñigo Salvat <inigo@isalvat.es>; +Cc: pgsql-admin
Hi,
2018-02-16 7:16 GMT+01:00 Iñigo Salvat <inigo@isalvat.es>:
> 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Migrate streaming replication 9.4 to 9.6
2018-02-16 06:16 Migrate streaming replication 9.4 to 9.6 Iñigo Salvat <inigo@isalvat.es>
2018-02-16 07:18 ` Re: Migrate streaming replication 9.4 to 9.6 Guillaume Lelarge <guillaume@lelarge.info>
@ 2018-02-16 12:37 ` MichaelDBA <MichaelDBA@sqlexec.com>
2018-02-17 07:34 ` Re: Migrate streaming replication 9.4 to 9.6 Iñigo Salvat <inigo@isalvat.es>
0 siblings, 1 reply; 4+ messages in thread
From: MichaelDBA @ 2018-02-16 12:37 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: Iñigo Salvat <inigo@isalvat.es>; pgsql-admin
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 <mailto:guillaume@lelarge.info>
> 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 <mailto:inigo@isalvat.es>
> 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,
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Migrate streaming replication 9.4 to 9.6
2018-02-16 06:16 Migrate streaming replication 9.4 to 9.6 Iñigo Salvat <inigo@isalvat.es>
2018-02-16 07:18 ` Re: Migrate streaming replication 9.4 to 9.6 Guillaume Lelarge <guillaume@lelarge.info>
2018-02-16 12:37 ` Re: Migrate streaming replication 9.4 to 9.6 MichaelDBA <MichaelDBA@sqlexec.com>
@ 2018-02-17 07:34 ` Iñigo Salvat <inigo@isalvat.es>
0 siblings, 0 replies; 4+ messages in thread
From: Iñigo Salvat @ 2018-02-17 07:34 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 <mailto:guillaume@lelarge.info>
>> 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 <mailto:inigo@isalvat.es>
>> 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,
>>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-02-17 07:34 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-02-16 06:16 Migrate streaming replication 9.4 to 9.6 Iñigo Salvat <inigo@isalvat.es>
2018-02-16 07:18 ` Guillaume Lelarge <guillaume@lelarge.info>
2018-02-16 12:37 ` MichaelDBA <MichaelDBA@sqlexec.com>
2018-02-17 07:34 ` Iñigo Salvat <inigo@isalvat.es>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox