Re: 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(dot)klaver(at)aklaver(dot)com