Re: tablesync copy ignores publication actions

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: tablesync copy ignores publication actions
Date: 2022-06-14 07:35:31
Message-ID: CAHut+Puz0QHStztwsLYDSBh0Ghdk90pqEA_hpACT30PVPH9fXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

PSA v2 of the patch, based on all feedback received.

~~~

Main differences from v1:

* Rewording and more explanatory text.

* The examples were moved to the "Subscription" [1] page and also
extended to show some normal replication and row filter examples, from
[Amit].

* Added some text to CREATE PUBLICATION 'publish' param [2], from [Euler][Amit].

* Added some text to CREATE SUBSCRIPTION Notes [3], from [Shi-san].

* Added some text to the "Publication page" [4] to say the 'publish'
is only for DML operations.

* I changed the note in "Row Filter - Initial Data Synchronization"
[5] to be a warning because I felt users could be surprised to see
data exposed by the initial copy, which a DML operation would not
expose.

------
[1] https://www.postgresql.org/docs/devel/logical-replication-subscription.html
[2] https://www.postgresql.org/docs/devel/sql-createpublication.html
[3] https://www.postgresql.org/docs/devel/sql-createsubscription.html
[4] https://www.postgresql.org/docs/devel/logical-replication-publication.html
[5] https://www.postgresql.org/docs/devel/logical-replication-row-filter.html#LOGICAL-REPLICATION-ROW-FILTER-INITIAL-DATA-SYNC

[Euler] https://www.postgresql.org/message-id/bd49c14d-7a01-4ae3-b424-8c49630fec57%40www.fastmail.com
[Amit] https://www.postgresql.org/message-id/CAA4eK1Lb5QpWCQU8qkELnX6t8z7JeVtGantmKptxkkpxnYnpHA%40mail.gmail.com
[Shi-san] https://www.postgresql.org/message-id/OSZPR01MB631026B8428422EAC1BFB8A4FDAA9%40OSZPR01MB6310.jpnprd01.prod.outlook.com

Kind Regards,
Peter Smith.
Fujitsu Australia

Attachment Content-Type Size
v2-0001-PGDOCS-tablesync-ignores-publish-operation.patch application/octet-stream 9.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2022-06-14 07:50:14 Re: Logging query parmeters in auto_explain
Previous Message Amit Langote 2022-06-14 07:32:05 Re: Replica Identity check of partition table on subscriber