Logical replication in the same cluster

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 +

Responses

Browse pgsql-hackers by date

  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