Re: Logical replication alternative

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Logical replication alternative
Date: 2020-11-04 11:58:33
Message-ID: 998fc693-ca58-ae60-b082-45de80a78b19@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2020-11-04 15:35:08 Re: Logical replication alternative
Previous Message Holger Jakobs 2020-11-04 11:57:21 Re: Logical replication alternative