May 2018
Intermediate to advanced
576 pages
30h 25m
English
LSR can work alongside PSR. There are no conflicting parameters; just ensure that all requirements are met for both PSR and LSR.
With LSR and pglogical, neither DDL nor sequences are replicated; only the data changes (DML) are sent. Only the full version of Postgres-BDR provides these features at present.
Logical replication is one-way only, so if you want multi-master replication, see the Bi-Directional Replication recipe. Logical replication provides cascaded replication.