From 68fd9bf77d86e294009c900b5eb8e006adddea70 Mon Sep 17 00:00:00 2001 From: Amit Kapila Date: Thu, 9 Sep 2021 09:36:04 +0530 Subject: [PATCH v5 2/2] PG Docs - Create Subscription - options rewording Some rewording to improve grammar of the subscription_parameter descriptions. --- doc/src/sgml/ref/create_subscription.sgml | 42 +++++++++++++++---------------- 1 file changed, 21 insertions(+), 21 deletions(-) diff --git a/doc/src/sgml/ref/create_subscription.sgml b/doc/src/sgml/ref/create_subscription.sgml index 04a0fd7..2ce6b73 100644 --- a/doc/src/sgml/ref/create_subscription.sgml +++ b/doc/src/sgml/ref/create_subscription.sgml @@ -112,18 +112,18 @@ CREATE SUBSCRIPTION subscription_name - It is not allowed to combine connect set to + You are not allowed a combination of connect set to false and enabled, create_slot, or copy_data set to true. - Since no connection is made when this option is set - to false, the tables are not subscribed, and so + Since no connection is made when this option is + false, the tables are not subscribed, and so after you enable the subscription nothing will be replicated. It is required to run - ALTER SUBSCRIPTION ... REFRESH PUBLICATION in order + ALTER SUBSCRIPTION ... REFRESH PUBLICATION for tables to be subscribed. @@ -143,8 +143,8 @@ CREATE SUBSCRIPTION subscription_nameenabled (boolean) - Specifies whether the subscription should be actively replicating, - or whether it should be just setup but not started yet. The default + Specifies whether the subscription should be actively replicating + or whether it should be just set up but not started yet. The default is true. @@ -159,10 +159,10 @@ CREATE SUBSCRIPTION subscription_name - When slot_name is set to - NONE, there will be no replication slot - associated with the subscription. This can be used if the - replication slot will be created later manually. Such + Setting slot_name to NONE + means there will be no replication slot + associated with the subscription. Use this when you will be + creating the replication slot later manually. Such subscriptions must also have both enabled and create_slot set to false. @@ -183,14 +183,14 @@ CREATE SUBSCRIPTION subscription_namefalse. - Even when this option is enabled, only data types that have + Even when this option is enabled, only data types having binary send and receive functions will be transferred in binary. - When doing cross-version replication, it could happen that the + When doing cross-version replication, it could be that the publisher has a binary send function for some data type, but the - subscriber lacks a binary receive function for the type. In + subscriber lacks a binary receive function for that type. In such a case, data transfer will fail, and the binary option cannot be used. @@ -201,8 +201,8 @@ CREATE SUBSCRIPTION subscription_namecopy_data (boolean) - Specifies whether the existing data in the publications that are - being subscribed to should be copied once the replication starts. + Specifies whether to copy the existing data in the publications + subscribed to once the replication starts. The default is true. @@ -212,9 +212,9 @@ CREATE SUBSCRIPTION subscription_namestreaming (boolean) - Specifies whether streaming of in-progress transactions should - be enabled for this subscription. By default, all transactions - are fully decoded on the publisher, and only then sent to the + Specifies whether to enable streaming of in-progress transactions + for this subscription. By default, all transactions + are fully decoded on the publisher and only then sent to the subscriber as a whole. @@ -261,17 +261,17 @@ CREATE SUBSCRIPTION subscription_name - When two-phase commit is enabled then the decoded transactions are sent + When two-phase commit is enabled the decoded transactions are sent to the subscriber on the PREPARE TRANSACTION. By default, the transaction prepared on the publisher is decoded as a normal transaction at commit. The two-phase commit implementation requires that the replication has - successfully passed the initial table synchronization phase. This means + successfully passed the initial table synchronization phase. So even when two_phase is enabled for the subscription, the internal two-phase state remains temporarily "pending" until the initialization - phase is completed. See column + phase completes. See column subtwophasestate of to know the actual two-phase state. -- 1.8.3.1