pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedUnclear on Publication documentation page
2+ messages / 2 participants
[nested] [flat]
* Unclear on Publication documentation page
@ 2024-05-18 20:44 PG Doc comments form <noreply@postgresql.org>
2024-05-21 02:16 ` Re: Unclear on Publication documentation page Euler Taveira <euler@eulerto.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2024-05-18 20:44 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: kdg.dev@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/logical-replication-publication.html
Description:
The page in question:
https://www.postgresql.org/docs/current/logical-replication-publication.html
It says:
"If a table without a replica identity is added to a publication that
replicates UPDATE or DELETE operations then subsequent UPDATE or DELETE
operations will cause an error on the publisher. INSERT operations can
proceed regardless of any replica identity."
The text is ambiguous as to what is meant by "the publisher" in "will cause
an error on the publisher". I've personally never set up logical
replication, which is why I'm reading the documentation now.
The question for me is: Does "the publisher" refer to a logical entity,
created by the "CREATE PUBLICATION " command? And further publication in the
publication<->subscriber model will not work anymore? Or does it refer to
the actual database itself, and will the functionality of the database be
impacted? As in: your live production database can now no longer process
UPDATE and DELETE statements so long as that publication exists/so long as
that publication is configured to publish that particular table?
Regards,
Koen De Groote
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Unclear on Publication documentation page
2024-05-18 20:44 Unclear on Publication documentation page PG Doc comments form <noreply@postgresql.org>
@ 2024-05-21 02:16 ` Euler Taveira <euler@eulerto.com>
0 siblings, 0 replies; 2+ messages in thread
From: Euler Taveira @ 2024-05-21 02:16 UTC (permalink / raw)
To: kdg.dev@gmail.com; pgsql-docs@lists.postgresql.org
On Sat, May 18, 2024, at 5:44 PM, PG Doc comments form wrote:
> The page in question:
> https://www.postgresql.org/docs/current/logical-replication-publication.html
>
> It says:
>
> "If a table without a replica identity is added to a publication that
> replicates UPDATE or DELETE operations then subsequent UPDATE or DELETE
> operations will cause an error on the publisher. INSERT operations can
> proceed regardless of any replica identity."
>
> The text is ambiguous as to what is meant by "the publisher" in "will cause
> an error on the publisher". I've personally never set up logical
> replication, which is why I'm reading the documentation now.
>
> The question for me is: Does "the publisher" refer to a logical entity,
> created by the "CREATE PUBLICATION " command? And further publication in the
> publication<->subscriber model will not work anymore? Or does it refer to
> the actual database itself, and will the functionality of the database be
> impacted? As in: your live production database can now no longer process
> UPDATE and DELETE statements so long as that publication exists/so long as
> that publication is configured to publish that particular table?
The first paragraph in the referred URL says
The node where a publication is defined is referred to as publisher.
And [2] defines the logical replication model:
Logical replication uses a publish and subscribe model with one or more
subscribers subscribing to one or more publications on a publisher node.
Unless there is a documentation bug or you want to suggest changes to any part of
the documentation, use pgsql-general for questions instead.
[2] https://www.postgresql.org/docs/current/logical-replication.html
--
Euler Taveira
EDB https://www.enterprisedb.com/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-05-21 02:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-18 20:44 Unclear on Publication documentation page PG Doc comments form <noreply@postgresql.org>
2024-05-21 02:16 ` Euler Taveira <euler@eulerto.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