Re: PostgreSQL Replication between Different Major Version (11-13)

Поиск
Список
Период
Сортировка
От Adarsh Sharma
Тема Re: PostgreSQL Replication between Different Major Version (11-13)
Дата
Msg-id CAGx-QqLyVHBaFn4WUqcJ=UwuY6VJDUdhWP=g8HABm-b3GmHihQ@mail.gmail.com
обсуждение исходный текст
Ответ на RE: PostgreSQL Replication between Different Major Version (11-13)  (Alvaro Aguayo <aaguayo@opensysperu.com>)
Список pgsql-admin
Дерево обсуждения
Is it recommended to use pglogical for PostgreSQL 9.6 -> PostgreSQL 12 Upgrade?
I have the similar use case but wondering if there are known issues or things to watch out for before using pglogical for setting replication across different PostgreSQL version.

On Wed, Dec 29, 2021 at 6:17 PM Alvaro Aguayo <aaguayo@opensysperu.com> wrote:

Hi.

 

Not with PostgreSQL itself, but you can achieve that with pglogical: https://www.2ndquadrant.com/en/resources-old/pglogical/

 

It supports replication across different versions. One of its intended usages is version migration with minimal (almost zero) downtime.

 

But please note that it won’t create a read only replica: The replica will always be writable. You should look for some way to restrict writing, via triggers or permissions, if you really want the replica to be read only.

 

Regards,

 

Alvaro Aguayo

Operations Manager

Jr. Prolongación Ayacucho 177 Urb. Santa Eulalia - San Miguel

Telf. (+51-1) 680-5726

E-mail: aaguayo@ocs.pe

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Aguayo
Дата:
Сообщение: RE: PostgreSQL Replication between Different Major Version (11-13)
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: PostgreSQL Replication between Different Major Version (11-13)