On Sat, May 18, 2024, at 5:44 PM, PG Doc comments form wrote:
The page in question:
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.