7 ms·
I did this the "hard way" a year ago. This blog post came in handy: https://jstaf.github.io/posts/pglogical/ https://jstaf.github.io/posts/pglogical/ pglogica
by srslack 3y ago
I did this the "hard way" a year ago. This blog post came in handy:
https://jstaf.github.io/posts/pglogical/ https://jstaf.github.io/posts/pglogical/
pglogical is magic. Keeping an eye on this project for the future, looks great.
- shayonj 3y agoLove 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.
- sgt 3y 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 3y agoYou're thinking of logical replication being added to the core. https://www.postgresql.org/docs/current/logical-replication.html 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.