1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
It is possible that you have hit this -
When creating a replication slot (the default behavior), CREATE SUBSCRIPTION cannot be executed inside a transaction block.
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.
[+] https://www.postgresql.org/docs/11/sql-createsubscription.html
回答済み 2年前
関連するコンテンツ
- 質問済み 6年前
AWS公式更新しました 1年前
