Re: Logical replication alternative

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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










[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux