Обсуждение: streaming replication different versions
Hi,
on release 10, I remember reading something like: streaming replication is NOW upward compatible.
which could be understood as: its possible to have a master in rel 10 and a slave in rel 11.
Can someone confirm (or not !) this ?
if true, is the following scheme possible:
a master and a slave in same rel (10/11/12/13/14?)
1) stopping the slave
2) upgrading the slave to rel+1
3) restarting the slave
4) stopping the master and promoting the slave
5) upgrading the ex master
6) restarting it as slave
bingo version upgrade without stopping production.
what about the time line of the upgraded slave (step 2 ) ??
thanks,
Marc Millas schrieb am 06.10.2021 um 13:43: > on release 10, I remember reading something like: streaming replication is NOW upward compatible. > which could be understood as: its possible to have a master in rel 10 and a slave in rel 11. No, that's not possible. For streaming replication both servers must run the same major versions.
Le mer. 6 oct. 2021 à 13:46, Thomas Kellerer <shammat@gmx.net> a écrit :
Marc Millas schrieb am 06.10.2021 um 13:43:
> on release 10, I remember reading something like: streaming replication is NOW upward compatible.
> which could be understood as: its possible to have a master in rel 10 and a slave in rel 11.
No, that's not possible.
For streaming replication both servers must run the same major versions.
You're right for physical replication. But it works for logical replication, which was released in version 10.
--
Guillaume.
it does work well for logical replication.
still its sad that it doesnt work for physical replication as, then, how to ensure continuous availability for generic apps ??
On Wed, Oct 6, 2021 at 5:03 PM Guillaume Lelarge <guillaume@lelarge.info> wrote:
Le mer. 6 oct. 2021 à 13:46, Thomas Kellerer <shammat@gmx.net> a écrit :Marc Millas schrieb am 06.10.2021 um 13:43:
> on release 10, I remember reading something like: streaming replication is NOW upward compatible.
> which could be understood as: its possible to have a master in rel 10 and a slave in rel 11.
No, that's not possible.
For streaming replication both servers must run the same major versions.You're right for physical replication. But it works for logical replication, which was released in version 10.
--Guillaume.