hello all, I'm using Airbyte to sync 2 postgres da...
# announcements
r
hello all, I'm using Airbyte to sync 2 postgres databases and it's great so far, but I was wondering can this support 2-way sync i.e. changes from A go to B and changes from B go to A
j
Yes indeed. You just need to add a 2nd source connector and a 2nd destination one, and then the connection between both
so in sources, you should see A and B, and in destinations, B and A.
c
yes, it’s possible but i think you might run in some slight schema/table naming issues for the moment that may not do exactly what you would want…
c
Hi @Rav Panchalingam we actually do not support this right now. There are some details around how we handle schema and tables names that isn't going to work for you in the current iteration. If you attempt to do a circular dependency between source and destination you'll end up with the follwoing A.public.table_foo writes to B.public.public_table_foo to A.public.public_public_table_foo. You won't be writing into your original table, which I think is your intention.
Can you speak a little more about your use case? It sounds like you want to have a two master setup for your databases.
r
thanks guys; i'm setting up IoT gateway devices which log data locally and sync up to a master database, I then wanted to allow my cloud service to make modifications to this data that could be synced back down