8000 Doc: Update caveats in synchronous logical replication. · postgres/postgres@f365151 · GitHub
[go: up one dir, main page]

Skip to content

Commit f365151

Browse files
author
Amit Kapila
committed
Doc: Update caveats in synchronous logical replication.
Reported-by: Simon Riggs Author: Takamichi Osumi Reviewed-by: Amit Kapila Backpatch-through: 9.6 Discussion: https://www.postgresql.org/message-id/20210222222847.tpnb6eg3yiykzpky@alap3.anarazel.de
1 parent 5cb74a8 commit f365151

File tree

1 file changed

+11
-5
lines changed

1 file changed

+11
-5
lines changed

doc/src/sgml/logicaldecoding.sgml

Lines changed: 11 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -722,16 +722,18 @@ OutputPluginWrite(ctx, true);
722722

723723
<para>
724724
In synchronous replication setup, a deadlock can happen, if the transaction
725-
has locked [user] catalog tables exclusively. This is because logical decoding of
726-
transactions can lock catalog tables to access them. To avoid this users
727-
must refrain from taking an exclusive lock on [user] catalog tables. This can
728-
happen in the following ways:
725+
has locked [user] catalog tables exclusively. See
726+
<xref linkend="logicaldecoding-capabilities"> for information on user
727+
catalog tables. This is because logical decoding of transactions can lock
728+
catalog tables to access them. To avoid this users must refrain from taking
729+
an exclusive lock on [user] catalog tables. This can happen in the following
730+
ways:
729731

730732
<itemizedlist>
731733
<listitem>
732734
<para>
733735
Issuing an explicit <command>LOCK</command> on <structname>pg_class</structname>
734-
(or any other catalog table) in a transaction.
736+
in a transaction.
735737
</para>
736738
</listitem>
737739

@@ -749,6 +751,10 @@ OutputPluginWrite(ctx, true);
749751
</para>
750752
</listitem>
751753
</itemizedlist>
754+
755+
Note that these commands that can cause deadlock apply to not only explicitly
756+
indicated system catalog tables above but also to any other [user] catalog
757+
table.
752758
</para>
753759
</sect2>
754760
</sect1>

0 commit comments

Comments
 (0)
0