pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedLogical replication restriction documentation
2+ messages / 2 participants
[nested] [flat]
* Logical replication restriction documentation
@ 2019-09-25 14:43 PG Doc comments form <noreply@postgresql.org>
2019-09-26 20:11 ` Re: Logical replication restriction documentation Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2019-09-25 14:43 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: software.mike.johnson@gmail.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Logical replication restriction documentation
2019-09-25 14:43 Logical replication restriction documentation PG Doc comments form <noreply@postgresql.org>
@ 2019-09-26 20:11 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2019-09-26 20:11 UTC (permalink / raw)
To: software.mike.johnson@gmail.com, pgsql-docs@lists.postgresql.org, PG Doc comments form <noreply@postgresql.org>
On 2019-09-25 16:43, PG Doc comments form wrote:
> 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.
It looked pretty clear to me. What in particular was unclear to you.
I'd also suggest just trying it out.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-09-26 20:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-09-25 14:43 Logical replication restriction documentation PG Doc comments form <noreply@postgresql.org>
2019-09-26 20:11 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
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