Thread: Replication between two different versions

Replication between two different versions

From
Erik Serrano
Date:
Hi guys,
query ... is it possible to do a Master - Slave read only replica between 2 different versions of postgresql ?

Thanks ,
greetings.


Erik S.

Re: Replication between two different versions

From
J T
Date:
Depending on version.

You can use logical replication between 10 and higher. 

Streaming needs to be equal major versions.



On Tue, Mar 7, 2023, 7:42 AM Erik Serrano <eserranos@gmail.com> wrote:
Hi guys,
query ... is it possible to do a Master - Slave read only replica between 2 different versions of postgresql ?

Thanks ,
greetings.


Erik S.

Re: Replication between two different versions

From
Erik Serrano
Date:
Is it possible in a version 9.6?


Erik 


El mar, 7 mar 2023 a las 13:35, J T (<jorge.torralba@gmail.com>) escribió:
Depending on version.

You can use logical replication between 10 and higher. 

Streaming needs to be equal major versions.



On Tue, Mar 7, 2023, 7:42 AM Erik Serrano <eserranos@gmail.com> wrote:
Hi guys,
query ... is it possible to do a Master - Slave read only replica between 2 different versions of postgresql ?

Thanks ,
greetings.


Erik S.

Re: Replication between two different versions

From
J T
Date:

On Tue, Mar 7, 2023 at 8:44 AM Erik Serrano <eserranos@gmail.com> wrote:
Is it possible in a version 9.6?


Erik 


El mar, 7 mar 2023 a las 13:35, J T (<jorge.torralba@gmail.com>) escribió:
Depending on version.

You can use logical replication between 10 and higher. 

Streaming needs to be equal major versions.



On Tue, Mar 7, 2023, 7:42 AM Erik Serrano <eserranos@gmail.com> wrote:
Hi guys,
query ... is it possible to do a Master - Slave read only replica between 2 different versions of postgresql ?

Thanks ,
greetings.


Erik S.


--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.

Re: Replication between two different versions

From
Abhishek Singh
Date:
Hi,

Yes, you can go for "logical" replication between two versions, if and only if those versions having functions & commands compatible to one-another; otherwise there will be command error at first and further run-time error or fatal errors. It is a matter of compatibility between versions.


Thanks & Regards,

Abhishek Singh
---------------------------------------------------------------

Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.
------------------------------------------------------------------


On Tue, 7 Mar, 2023, 21:12 Erik Serrano, <eserranos@gmail.com> wrote:
Hi guys,
query ... is it possible to do a Master - Slave read only replica between 2 different versions of postgresql ?

Thanks ,
greetings.


Erik S.