diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2020-04-06 15:15:52 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2020-04-06 15:15:52 +0200 |
| commit | f1ac27bfda6ce8a399d8001843e9aefff5814f9b (patch) | |
| tree | bd3a62808e434421ee2af2abe494a5308b465e7b /doc/src | |
| parent | b7ce6de93b59852c55d09acdaeebbf5aaf89114e (diff) | |
| download | postgresql-f1ac27bfda6ce8a399d8001843e9aefff5814f9b.tar.gz postgresql-f1ac27bfda6ce8a399d8001843e9aefff5814f9b.zip | |
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 <amitlangote09@gmail.com>
Reviewed-by: Rafia Sabih <rafia.pghackers@gmail.com>
Reviewed-by: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Reviewed-by: Petr Jelinek <petr@2ndquadrant.com>
Discussion: https://www.postgresql.org/message-id/flat/CA+HiwqH=Y85vRK3mOdjEkqFK+E=ST=eQiHdpj43L=_eJMOOznQ@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/logical-replication.sgml | 17 |
1 files changed, 10 insertions, 7 deletions
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 @@ <listitem> <para> - 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. </para> + </listitem> + <listitem> <para> - 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.) </para> </listitem> </itemizedlist> |