Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have a need to keep updated just a few tables between databases with different purposes and schemas, except for these few tables.
My current solution is a cron job that selects from one database and inserts into the other every minute or so, but I was wondering if there are more robust solutions around for PostgreSQL version 10.
To replicate some specific tables, you can use logical replication
Another option is to not replicate at all and access the remote tables through a foreign table
