@@ -363,21 +363,21 @@ CONTEXT: processing remote data for replication origin "pg_16395" during "INSER
363
363
The LSN of the transaction that contains the change violating the constraint and
364
364
the replication origin name can be found from the server log (LSN 0/14C0378 and
365
365
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
367
367
<command>ALTER SUBSCRIPTION ... SKIP</command> with the finish LSN
368
368
(i.e., LSN 0/14C0378). The finish LSN could be an LSN at which the transaction
369
369
is committed or prepared on the publisher. Alternatively, the transaction can
370
370
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
374
374
subscription can be used with the <literal>disable_on_error</literal> option.
375
375
Then, you can use <function>pg_replication_origin_advance()</function> function
376
376
with the <parameter>node_name</parameter> (i.e., <literal>pg_16395</literal>)
377
377
and the next LSN of the finish LSN (i.e., 0/14C0379). The current position of
378
378
origins can be seen in the <link linkend="view-pg-replication-origin-status">
379
379
<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
381
381
might not violate any constraint. This can easily make the subscriber
382
382
inconsistent.
383
383
</para>
0 commit comments