top | item 36406470

(no title)

srslack | 2 years ago

I did this the "hard way" a year ago. This blog post came in handy:

https://jstaf.github.io/posts/pglogical/

pglogical is magic. Keeping an eye on this project for the future, looks great.

discuss

sgt|2 years ago

> Binary replication only works with DBs of the same major version. If you want to replicate to a different version, well… you can’t.

Is this true? I thought they fixed that at some point after PG11.

luhn|2 years ago

You're thinking of logical replication being added to the core. https://www.postgresql.org/docs/current/logical-replication....

WAL streaming is still only supported between the same major versions and AFAIA that isn't going to change anytime soon.

shayonj|2 years ago

Love pglogical. I was thinking, it'd be nice to orchestrate this setup using pglogical too. Would attempt it if there is interest. Especially with bi-directional replication setup.