For NeonDB, do you know if i could setup a birectional bi-region databases
For NeonDB, do you know if i could setup a birectional bi-region databases? I know that we can do logical replication from one NeonDB project to another (https://neon.com/docs/guides/logical-replication-neon-to-neon). However, this is a uni-direction from publisher (project A) to subscriber (project B). I tried to setup the reserve direction using the same method but the data does not seems to be replicate back from project B to A
2 Replies
extended-yellow•2mo ago
Hi @Khoi Van , sorry for the delayed response. I had to ask around a bit.
From our team:
PostgreSQL can support bi-directional replication, but it typically requires third-party tools like Bucardo or pglogical, because it's not a native feature.
It can get tricky because of things like conflict resolution when the same data gets updated on both sides.
Currently, NeonDB does not support bi-directional replication out of the box. As you mentioned, logical replication in Neon is uni-directional, where data flows from the publisher (e.g., Project A) to the subscriber (e.g., Project B), as outlined in the Neon-to-Neon logical replication guide.
Setting up the reverse direction using the same method will not enable replication back from Project B to Project A. If bi-directional replication is a critical requirement for your use case, you may need to explore external tools or alternative solutions that support this functionality.
passive-yellowOP•2mo ago
perfect. Thank you for confirming that, Andre!