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

Commit0933fce

Browse files
committed
doc: Document that subscriptions to same server might hang
1 parent493490c commit0933fce

File tree

1 file changed

+13
-0
lines changed

1 file changed

+13
-0
lines changed

‎doc/src/sgml/ref/create_subscription.sgml

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -226,6 +226,19 @@ CREATE SUBSCRIPTION <replaceable class="PARAMETER">subscription_name</replaceabl
226226
how to configure access control between the subscription and the
227227
publication instance.
228228
</para>
229+
230+
<para>
231+
Creating a subscription that connects to the same database cluster (for
232+
example, to replicate between databases in the same cluster or to replicate
233+
within the same database) will only succeed if the replication slot is not
234+
created as part of the same command. Otherwise, the <command>CREATE
235+
SUBSCRIPTION</command> call will hang. To make this work, create the
236+
replication slot separately (using the
237+
function <function>pg_create_logical_replication_slot</function> with the
238+
plugin name <literal>pgoutput</literal>) and create the subscription using
239+
the parameter <literal>create_slot = false</literal>. This is an
240+
implementation restriction that might be lifted in a future release.
241+
</para>
229242
</refsect1>
230243

231244
<refsect1>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp