[HACKERS] Logical replication in the same cluster
От | Bruce Momjian |
---|---|
Тема | [HACKERS] Logical replication in the same cluster |
Дата | |
Msg-id | 20170426165954.GK14000@momjian.us обсуждение исходный текст |
Ответы |
Re: [HACKERS] Logical replication in the same cluster
|
Список | pgsql-hackers |
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 +
В списке pgsql-hackers по дате отправления: