[GENERAL] logical replication in PG10 BETA

Поиск
Список
Период
Сортировка
Искать
От
Igor Neyman
Тема
[GENERAL] logical replication in PG10 BETA
Дата
в 22:33:13
Msg-id
DM5PR07MB2810212C52D7EE115E45B8D9DAF80@DM5PR07MB2810.namprd07.prod.outlook.com
Список
Дерево обсуждения
[GENERAL] logical replication in PG10 BETA Igor Neyman <ineyman@perceptron.com>
Re: [GENERAL] logical replication in PG10 BETA Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] logical replication in PG10 BETA Igor Neyman <ineyman@perceptron.com>
Re: [GENERAL] logical replication in PG10 BETA Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] logical replication in PG10 BETA Igor Neyman <ineyman@perceptron.com>
Re: [GENERAL] logical replication in PG10 BETA Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] logical replication in PG10 BETA Igor Neyman <ineyman@perceptron.com>
Re: [GENERAL] logical replication in PG10 BETA Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] logical replication in PG10 BETA Igor Neyman <ineyman@perceptron.com>
Re: [GENERAL] logical replication in PG10 BETA Thomas Kellerer <spam_eater@gmx.net>
Re: [GENERAL] logical replication in PG10 BETA Igor Neyman <ineyman@perceptron.com>
Re: [GENERAL] logical replication in PG10 BETA Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] logical replication in PG10 BETA Igor Neyman <ineyman@perceptron.com>
Re: [GENERAL] logical replication in PG10 BETA Adrian Klaver <adrian.klaver@aklaver.com>
Re: [GENERAL] logical replication in PG10 BETA Igor Neyman <ineyman@perceptron.com>

Hi,

 

Does built-in logical replication work on Windows in PG10 BETA release?

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:

 

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

 

В списке pgsql-general по дате отправления
От: Siddhartha Sahu
Дата:
От: Adrian Klaver
Дата:
FAQ