Re: logical replication in PG10 BETA

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Thomas Kellerer
Sent: Tuesday, May 23, 2017 9:46 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] logical replication in PG10 BETA

Igor Neyman schrieb am 22.05.2017 um 21:33:
> 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”

> could not send SSL negotiation packet

sounds more like a SSL setup problem between the two Postgres servers, not really related to logical replication.

Can you try to setup the connections without SSL?

________________________________________________________________________________________________________

That's what I thought when I first saw this error.
But, I don't understand why is it trying to use sockets.
I have ssl=off in postgresql.conf on both sides.

Regards,
Igor