Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitaeebb8b

Browse files
author
Amit Kapila
committed
Fix grammatical errors and typos in logical replication docs.
Author: Justin PryzbyReviewed By: Masahiko SawadaDiscussion:https://postgr.es/m/20220411020336.GB26620@telsasoft.com
1 parent3603f7c commitaeebb8b

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 thatproduces conflict can be skipped by using
366+
transaction thatproduced 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-
temporarilyeither 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 transactioninclude skipping changes that
380+
Please note that skipping the whole transactionincludes 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 usingthe<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+
Afterthelogical replication worker successfully skips the transaction or
228+
finishes a transaction,theLSN (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 individualsubtransaction is not supported. Setting
247+
Skipping individualsubtransactions is not supported. Setting
248248
<literal>NONE</literal> resets the LSN.
249249
</para>
250250
</listitem>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp