Search code examples
postgresqlreplicationlogical-replication

Does logical replication supports bidirectional?

I have created two publications one on each PostgreSQL instance but on the same table. Then I subscribed to these publications from each instance. I didn't see an error in the logs of two instances but I can see replication works on one side i.e. uni-directional.

Does logical replication support bi-directional or not?

Thanks

Solution

  • No, you cannot use logical replication to replicate the same table in both directions. This would necessitate complicated conflict resolution, which PostgreSQL doesn't have at the moment.