logical replication in PG10 BETA

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: logical replication in PG10 BETA
Date: 2017-05-22 19:33:13
Message-ID: DM5PR07MB2810212C52D7EE115E45B8D9DAF80@DM5PR07MB2810.namprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Does built-in logical replication work on Windows in PG10 BETA release?
I can't make it working so far.
I created Publication on "source" PG server, but when I'm trying to CREATE SUBSCRIPTION... on "destination" server, I'm getting:

"ERROR: could not connect to the publisher: could not send data to server: Socket is not connected (0x00002749/10057) could not send SSL negotiation packet: Socket is not connected (0x00002749/10057) SQL state: XX000"

In order to verify that connection works between "destination" and "source" server:
I created Postgres_fdw extension on "destination" server,
then I created server "fdw_server" foreign data wrapper postgres_fdw with the same connection options that I'm using when I'm trying to CREATE SUBSCRIPTION,
and it works fine: using this server (fdw_server) I can create foreign tables to access tables on the "source" server, and see select from these foreign tables.

Please let me know if my description is not clear.

Regards,
Igor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-05-22 23:56:25 Re: logical replication in PG10 BETA
Previous Message Siddhartha Sahu 2017-05-22 16:02:35 Please participate in a research survey on graphs