Re: [GENERAL] logical replication in PG10 BETA

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com] 
Sent: Tuesday, May 23, 2017 9:26 AM
To: Igor Neyman <ineyman@perceptron.com>; pgsql-general@postgresql.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
ofthe 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.klaver@aklaver.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
optionsas I'm using in CREATE SUBSCRIPTION, and foreign server works fine, which to me proves that there is no issues
withpg_hba.conf.
 

Regards,
Igor