Answer the question
In order to leave comments, you need to log in
How to synchronize two PostgreSQL DBs?
There are two different PostgreSQL databases. It is necessary to take 5 columns with each data change in DB A and update them in DB B.
It is noteworthy that you need to synchronize not the 1k1 table, but only the indicated fields. Their names match.
What are the options?
Answer the question
In order to leave comments, you need to log in
Look towards plproxy. On server B, write the logic for updating 5 rows as a function fB. Install the plproxy extension on server A, connect server B to it and write a function fA that remotely calls the function fB to update 5 rows on server B. After updating a row on server A, pull fA and get an update on server B
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question