Обсуждение: Replication between two different versions

Поиск
Список
Период
Сортировка

Replication between two different versions

От
Erik Serrano
Дата:
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

От
J T
Дата:
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

От
Erik Serrano
Дата:
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

От
J T
Дата:

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

От
Abhishek Singh
Дата:
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.