From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Logical replication in the same cluster |
Date: | 2017-04-26 16:59:54 |
Message-ID: | 20170426165954.GK14000@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 TABLE
test=>
test=> INSERT INTO test VALUES (1);
INSERT 0 1
test=> CREATE PUBLICATION mypub FOR TABLE test;
CREATE PUBLICATION
then from database test2:
test2=> CREATE TABLE test (x INT PRIMARY KEY);
CREATE TABLE
test2=> CREATE SUBSCRIPTION mysub CONNECTION 'dbname=test port=5432'
PUBLICATION mypub;
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 initial
starting point at 0/15FF3E0
2017-04-26 12:50:53.694 EDT [29363] DETAIL: 1 transaction needs to
finish.
Is this expected? I can get it working from two different clusters.
--
Bruce Momjian <bruce(at)momjian(dot)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 +
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2017-04-26 17:01:28 | Re: StandbyRecoverPreparedTransactions recovers subtrans links incorrectly |
Previous Message | Tom Lane | 2017-04-26 16:57:54 | Re: scram and \password |