On 05/22/2017 12:33 PM, Igor Neyman wrote:
Hi,
Does built-in logical replication work on Windows in PG10 BETA release?
Short version:
Maybe.
Long version:
AFAIK to run on Windows you need to build pglogical 2.0 from source
master branch.
So what version of pglogical and how did you install it?
See the issue below for more info on pglogical and Postgres 10 support.
https://github.com/2ndQuadrant/pglogical/issues/93
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:
Are both servers on Windows?
“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.
Please let me know if my description is not clear.
Regards,
Igor
--
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
