8

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.

0

1 Answer 1

12

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

3
  • Had forgotten about foreign tables! Thanks for the reminder
    – ivarec
    Commented Jul 20, 2018 at 19:17
  • 1
    Also, maybe it's worth mentioning, but logical replication seems to have been added in version 10, so my question may be useful to others :)
    – ivarec
    Commented Jul 20, 2018 at 19:49
  • 1
    dblink is another option.
    – Jasen
    Commented Jul 21, 2018 at 9:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.