From: Iñigo Salvat <inigo@isalvat.es>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Migrate streaming replication 9.4 to 9.6
Date: Sat, 17 Feb 2018 08:34:41 +0100
Message-ID: <c9bf33ff-9fa5-dfc8-4959-da3c9eee36d1@isalvat.es> (raw)
In-Reply-To: <5A86D093.9030708@sqlexec.com>
References: <a6c677a3-4b47-d31c-d6fb-62eb90ca191c@isalvat.es>
<CAECtzeUD_2ndPzMehvR-BEGQ0X+NPJhwBBA_ncmgd=yonN_H2g@mail.gmail.com>
<5A86D093.9030708@sqlexec.com>
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,
>>
>
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: inigo@isalvat.es, pgsql-admin@lists.postgresql.org
Subject: Re: Migrate streaming replication 9.4 to 9.6
In-Reply-To: <c9bf33ff-9fa5-dfc8-4959-da3c9eee36d1@isalvat.es>
* 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