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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
