On Wed, Jan 06, 2021 at 03:31:32PM +0200, Yambu wrote:
> If i use logical replication , can i not make it work?
Well yes, you can write to the subscriber if you use logical
However, there are severe drawbacks in this, e.g. you will have to
resolve conflicts yourself, DDL isn't possible unless you do it
manually, sequences are not replicated etc. pp.
Logical replication for itself is not a general HA tool for Postgres
right now but if implemented carefully can be used for some use cases
like merging several databases into a data warehouse or carefully only
changing data locally.