Thank you for pointing this out, I would have missed it.In fact, thank you everyone who has answered with helpful technical details.
I have a couple of use-cases in mind where logical streaming replication could solve a number of problems. A personal project would benefit from a database-level setup due to easier data migration, a professional one would benefit from bi-directionality and logically straightforward clustering. (I also have some future designs in mind where replicating only subsets of a database would be VERY useful.)
Owing thanks to the replies, I now have some extra reading to do. :)
Thank you for pointing this out, I would have missed it.In fact, thank you everyone who has answered with helpful technical details.
I have a couple of use-cases in mind where logical streaming replication could solve a number of problems. A personal project would benefit from a database-level setup due to easier data migration, a professional one would benefit from bi-directionality and logically straightforward clustering. (I also have some future designs in mind where replicating only subsets of a database would be VERY useful.)
Owing thanks to the replies, I now have some extra reading to do. :)