From f1ac27bfda6ce8a399d8001843e9aefff5814f9b Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Mon, 6 Apr 2020 15:15:52 +0200 Subject: Add logical replication support to replicate into partitioned tables Mainly, this adds support code in logical/worker.c for applying replicated operations whose target is a partitioned table to its relevant partitions. Author: Amit Langote Reviewed-by: Rafia Sabih Reviewed-by: Peter Eisentraut Reviewed-by: Petr Jelinek Discussion: https://www.postgresql.org/message-id/flat/CA+HiwqH=Y85vRK3mOdjEkqFK+E=ST=eQiHdpj43L=_eJMOOznQ@mail.gmail.com --- doc/src/sgml/logical-replication.sgml | 17 ++++++++++------- 1 file changed, 10 insertions(+), 7 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index 8bd7c9c8ac0..c513621470a 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -402,16 +402,19 @@ - Replication is only supported by tables, partitioned or not, although a - given table must either be partitioned on both servers or not partitioned - at all. Also, when replicating between partitioned tables, the actual - replication occurs between leaf partitions, so partitions on the two - servers must match one-to-one. + Replication is only supported by tables, including partitioned tables. + Attempts to replicate other types of relations such as views, materialized + views, or foreign tables, will result in an error. + + - Attempts to replicate other types of relations such as views, materialized - views, or foreign tables, will result in an error. + When replicating between partitioned tables, the actual replication + originates from the leaf partitions on the publisher, so partitions on + the publisher must also exist on the subscriber as valid target tables. + (They could either be leaf partitions themselves, or they could be + further subpartitioned, or they could even be independent tables.) -- cgit v1.2.3