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@xxxxxxxxxxxxxxx> 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@xxxxxx
