From 0933fcee9851eb2afcd41db1ee4425153f4cbdd3 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 9 Jun 2017 17:11:46 -0400 Subject: [PATCH] doc: Document that subscriptions to same server might hang --- doc/src/sgml/ref/create_subscription.sgml | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/doc/src/sgml/ref/create_subscription.sgml b/doc/src/sgml/ref/create_subscription.sgml index 2c91eb6f50..dd5eda043a 100644 --- a/doc/src/sgml/ref/create_subscription.sgml +++ b/doc/src/sgml/ref/create_subscription.sgml @@ -226,6 +226,19 @@ CREATE SUBSCRIPTION subscription_name + + + Creating a subscription that connects to the same database cluster (for + example, to replicate between databases in the same cluster or to replicate + within the same database) will only succeed if the replication slot is not + created as part of the same command. Otherwise, the CREATE + SUBSCRIPTION call will hang. To make this work, create the + replication slot separately (using the + function pg_create_logical_replication_slot with the + plugin name pgoutput) and create the subscription using + the parameter create_slot = false. This is an + implementation restriction that might be lifted in a future release. + -- 2.40.0