Re: open-source equivalent of golden-gate

There is a SQL/MED standard exactly for this: https://wiki.postgresql.org/wiki/SQL/MED

Implemented in PostgreSQL as Foreign Data Wrappers: https://wiki.postgresql.org/wiki/Fdw
You need to do the following:
1. Add wrapper via https://www.postgresql.org/docs/current/sql-createextension.html
2. Create remote source via https://www.postgresql.org/docs/current/sql-createserver.html
3. Create foreign table via https://www.postgresql.org/docs/current/sql-createforeigntable.html

Note, that PostgreSQL provides only infrastructure, wrappers for different remote systems are not supported by the PostgreSQL community,
except for postgres_fdw and csv_fdw provided by the project.