B
B
beduin012016-11-25 11:11:43
PostgreSQL
beduin01, 2016-11-25 11:11:43

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

1 answer(s)
D
Denis Smirnov, 2016-11-25
@darthunix

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 question

Ask a Question

731 491 924 answers to any question