| 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: | Whole Thread | Raw Message | 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 |