From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Iñigo Salvat <inigo@isalvat.es>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Migrate streaming replication 9.4 to 9.6
Date: Fri, 16 Feb 2018 07:37:39 -0500
Message-ID: <5A86D093.9030708@sqlexec.com> (raw)
In-Reply-To: <CAECtzeUD_2ndPzMehvR-BEGQ0X+NPJhwBBA_ncmgd=yonN_H2g@mail.gmail.com>
References: <a6c677a3-4b47-d31c-d6fb-62eb90ca191c@isalvat.es>
<CAECtzeUD_2ndPzMehvR-BEGQ0X+NPJhwBBA_ncmgd=yonN_H2g@mail.gmail.com>
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,
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: MichaelDBA@sqlexec.com, guillaume@lelarge.info, inigo@isalvat.es
Subject: Re: Migrate streaming replication 9.4 to 9.6
In-Reply-To: <5A86D093.9030708@sqlexec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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