From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: software.mike.johnson@gmail.com
Subject: Logical replication restriction documentation
Date: Wed, 25 Sep 2019 14:43:19 +0000
Message-ID: <156942259967.1110.17296757626302026770@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/logical-replication-restrictions.html
Description:
Re this note in the "logical replication restrictions" documentation page:
Replication is only possible from base tables to base tables. That is, the
tables on the publication and on the subscription side must be normal
tables, not views, materialized views, partition root tables, or foreign
tables. In the case of partitions, you can therefore replicate a partition
hierarchy one-to-one, but you cannot currently replicate to a differently
partitioned setup. Attempts to replicate tables other than base tables will
result in an error.
We are exploring using logical replication and partitioned tables, and
therefore I am trying to understand if these two concepts will work
together. This note in the doc seems to indicate that it might work. So I
tried to do more research by Googling the terms "postgres base table" and
"postgres partition root table" (both mentioned in the document note above),
but Google finds pretty much nothing for either term. So the documentation
note doesn't really help me to discern what will work and what won't.
I believe the doc note above should be revised to clarify what works and
doesn't work in relation to partitioning and logical replication, and
perhaps these two terms should be defined on this page.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, software.mike.johnson@gmail.com
Subject: Re: Logical replication restriction documentation
In-Reply-To: <156942259967.1110.17296757626302026770@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox