Thread: Unclear on Publication documentation page
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
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 thatreplicates UPDATE or DELETE operations then subsequent UPDATE or DELETEoperations will cause an error on the publisher. INSERT operations canproceed regardless of any replica identity."The text is ambiguous as to what is meant by "the publisher" in "will causean error on the publisher". I've personally never set up logicalreplication, 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 thepublication<->subscriber model will not work anymore? Or does it refer tothe actual database itself, and will the functionality of the database beimpacted? As in: your live production database can now no longer processUPDATE and DELETE statements so long as that publication exists/so long asthat 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.