Hacker News new | ask | show | jobs
by srslack 1087 days 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.
2 comments
sgt 1087 days 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.

link
luhn 1087 days 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.

link
shayonj 1087 days 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.
link