Re: Logical replication alternative

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Logical replication alternative
Дата
Msg-id 998fc693-ca58-ae60-b082-45de80a78b19@gmx.net
обсуждение исходный текст
Ответ на Logical replication alternative  (Yambu <hyambu@gmail.com>)
Список pgsql-admin
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







В списке pgsql-admin по дате отправления:

Предыдущее
От: Holger Jakobs
Дата:
Сообщение: Re: Logical replication alternative
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Logical replication alternative