Re: logical replication in PG10 BETA

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Tuesday, May 23, 2017 9:26 AM
To: Igor Neyman <ineyman(at)perceptron(dot)com>; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] logical replication in PG10 BETA

On 05/23/2017 06:17 AM, Igor Neyman wrote:
> -----Original Message-----

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

> 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 of the core, so I should not be required to build pglogical 2.0 separately.
> The issue you referenced concern building pglogical.

Yeah, my mistake I was working with pglogical and it got stuck in my head.
>
> Any other ideas?

Have you gone through these sections of the docs?:

https://www.postgresql.org/docs/10/static/logical-replication-config.html

https://www.postgresql.org/docs/10/static/logical-replication-quick-setup.html
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
_______________________________________________________________________________________________________

Yes. All parameters mentioned in the docs configured properly.
CREATE PUBLICATION works fine.

pg_hba.conf modified to allow "replication" user to connect to the server.
In the original email I mentioned that I configured Postgres_fdw foreign server that connects using the same connection options as I'm using in CREATE SUBSCRIPTION, and foreign server works fine, which to me proves that there is no issues with pg_hba.conf.

Regards,
Igor