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
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 |