POSTGRESQL table replication between 2 servers
0
votes
1
answer
1002
views
I want to to replicate A TABLE from one server A to another B so that A and B always in-sync.
This table on server A has like 4 - 5 million rows, whereas the table B is empty.
What I want to do is doing this by pushing data from A to B. I will be using TRIGGER on Server A via either FDW or DBLINK. If there is CRUD operation on A, then it will immediately pushed into B.
Previously, FWD has been used on another table, but it really really slow. I want to take a precaution of doing this before I proceed.
Questions:
1. Why FWD is slow? This is the newest method of cross-database operation right?
2. For the start, Initially I need to copy data Server A into server B. Then turning on the trigger. Correct?
3. Is FWD better than DBLINK? If so, what makes it better and what does not?
4. Is there any tool that I can use to achieve this? There is Pentaho. But what else are the options?
Many thanks
Asked by padjee
(337 rep)
Jun 30, 2022, 07:23 AM
Last activity: Jul 12, 2022, 04:58 AM
Last activity: Jul 12, 2022, 04:58 AM