Hacker News Reader

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.

> 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.

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.

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.

Reply on news.ycombinator.com