Search Postgresql Archives

Re: logical replication in PG10 BETA

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux