I tried setting up logical replication on the same server between two
different databases, and got, from database test:
test=> CREATE TABLE test (x INT PRIMARY KEY);CREATE TABLEtest=>test=> INSERT INTO test VALUES (1);INSERT 0 1test=>
CREATEPUBLICATION mypub FOR TABLE test;CREATE PUBLICATION
then from database test2:
test2=> CREATE TABLE test (x INT PRIMARY KEY);CREATE TABLEtest2=> CREATE SUBSCRIPTION mysub CONNECTION 'dbname=test
port=5432'PUBLICATIONmypub;NOTICE: synchronized table states
and it just hangs. My server logs say:
2017-04-26 12:50:53.694 EDT [29363] LOG: logical decoding found initialstarting point at 0/15FF3E02017-04-26
12:50:53.694EDT [29363] DETAIL: 1 transaction needs tofinish.
Is this expected? I can get it working from two different clusters.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
