-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Monday, May 22, 2017 7:56 PM
To: Igor Neyman <ineyman@perceptron.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/22/2017 12:33 PM, Igor Neyman wrote:
> Hi,
>
> Does built-in logical replication work on Windows in PG10 BETA release?
Short version:
Maybe.
Long version:
AFAIK to run on Windows you need to build pglogical 2.0 from source master branch.
So what version of pglogical and how did you install it?
See the issue below for more info on pglogical and Postgres 10 support.
https://github.com/2ndQuadrant/pglogical/issues/93
>
> 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:
Are both servers on Windows?
>
> "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
>
--
Adrian Klaver
adrian.klaver@aklaver.com
________________________________________________________________________________________
Answers to Adrian questions:
Both servers run on Windows.
To install 10BETA I used installer from EnterpriseDB. Logical Replication (including Windows platform) should be part
ofthe core, so I should not be required to build pglogical 2.0 separately.
The issue you referenced concern building pglogical.
Any other ideas?
Regards,
Igor Neyman