Re: Unclear on Publication documentation page
От | Euler Taveira |
---|---|
Тема | Re: Unclear on Publication documentation page |
Дата | |
Msg-id | 009dbc5c-d229-4180-b425-632b681cba1d@app.fastmail.com обсуждение исходный текст |
Ответ на | Unclear on Publication documentation page (PG Doc comments form <noreply@postgresql.org>) |
Список | pgsql-docs |
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.
В списке pgsql-docs по дате отправления: