Sample Header Ad - 728x90

PostgreSQL - Best way to incremental export 1000+ tables every 5 mins

0 votes
1 answer
284 views
I have 6 PostgreSQL database servers(v11) hosted on some third-party vendor. I don't have access to setup pg_logical. Each server has 1 database but 1000+ tables. So I want to get the data from these 6 servers to my central PostgreSQL database. The sources tables are having PK and last_updated_timestamp columns. Im just trying to find the best approach to get the data at every 5 or 15mins interval from these tables to my central database server. My goal is to sync the whole database to Report database server with every5mins interval.
Asked by TheDataGuy (1986 rep)
Jun 24, 2020, 01:16 PM
Last activity: Jun 25, 2020, 05:40 AM