Re: 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

> Regards,
> Igor Neyman
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com