Yambu schrieb am 04.11.2020 um 11:55:
> May i know what is the alternative to logical replication if i want
> to replicate a few tables on postgres v10?
What about using foreign tables?
Then no replication would be required.
If that is to slow, you could create a materialized view on the
"secondary" server that is based on the foreign tables.
You can refresh the MVIEW multiple times a day.
The downside is that this isn't incremental, you would always copy
all the data.
Thomas
