Skip to content

Commit aeebb8b

Browse files
author
Amit Kapila
committed
Fix grammatical errors and typos in logical replication docs.
Author: Justin Pryzby Reviewed By: Masahiko Sawada Discussion: https://postgr.es/m/20220411020336.GB26620@telsasoft.com
1 parent 3603f7c commit aeebb8b

File tree

2 files changed

+9
-9
lines changed

2 files changed

+9
-9
lines changed

doc/src/sgml/logical-replication.sgml

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -363,21 +363,21 @@ CONTEXT: processing remote data for replication origin "pg_16395" during "INSER
363363
The LSN of the transaction that contains the change violating the constraint and
364364
the replication origin name can be found from the server log (LSN 0/14C0378 and
365365
replication origin <literal>pg_16395</literal> in the above case). The
366-
transaction that produces conflict can be skipped by using
366+
transaction that produced the conflict can be skipped by using
367367
<command>ALTER SUBSCRIPTION ... SKIP</command> with the finish LSN
368368
(i.e., LSN 0/14C0378). The finish LSN could be an LSN at which the transaction
369369
is committed or prepared on the publisher. Alternatively, the transaction can
370370
also be skipped by calling the <link linkend="pg-replication-origin-advance">
371-
<function>pg_replication_origin_advance()</function></link> function
372-
transaction. Before using this function, the subscription needs to be disabled
373-
temporarily either by <command>ALTER SUBSCRIPTION ... DISABLE</command> or, the
371+
<function>pg_replication_origin_advance()</function></link> function.
372+
Before using this function, the subscription needs to be disabled temporarily
373+
either by <command>ALTER SUBSCRIPTION ... DISABLE</command> or, the
374374
subscription can be used with the <literal>disable_on_error</literal> option.
375375
Then, you can use <function>pg_replication_origin_advance()</function> function
376376
with the <parameter>node_name</parameter> (i.e., <literal>pg_16395</literal>)
377377
and the next LSN of the finish LSN (i.e., 0/14C0379). The current position of
378378
origins can be seen in the <link linkend="view-pg-replication-origin-status">
379379
<structname>pg_replication_origin_status</structname></link> system view.
380-
Please note that skipping the whole transaction include skipping changes that
380+
Please note that skipping the whole transaction includes skipping changes that
381381
might not violate any constraint. This can easily make the subscriber
382382
inconsistent.
383383
</para>

doc/src/sgml/ref/alter_subscription.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -219,13 +219,13 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO <
219219
<para>
220220
Skips applying all changes of the remote transaction. If incoming data
221221
violates any constraints, logical replication will stop until it is
222-
resolved. By using <command>ALTER SUBSCRIPTION ... SKIP</command> command,
222+
resolved. By using the <command>ALTER SUBSCRIPTION ... SKIP</command> command,
223223
the logical replication worker skips all data modification changes within
224224
the transaction. This option has no effect on the transactions that are
225225
already prepared by enabling <literal>two_phase</literal> on
226226
subscriber.
227-
After logical replication worker successfully skips the transaction or
228-
finishes a transaction, LSN (stored in
227+
After the logical replication worker successfully skips the transaction or
228+
finishes a transaction, the LSN (stored in
229229
<structname>pg_subscription</structname>.<structfield>subskiplsn</structfield>)
230230
is cleared. See <xref linkend="logical-replication-conflicts"/> for
231231
the details of logical replication conflicts. Using this command requires
@@ -244,7 +244,7 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO <
244244
Specifies the finish LSN of the remote transaction whose changes
245245
are to be skipped by the logical replication worker. The finish LSN
246246
is the LSN at which the transaction is either committed or prepared.
247-
Skipping individual subtransaction is not supported. Setting
247+
Skipping individual subtransactions is not supported. Setting
248248
<literal>NONE</literal> resets the LSN.
249249
</para>
250250
</listitem>

0 commit comments

Comments
 (0)