From: | ineyman(at)perceptron(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14669: logical replication isn't working |
Date: | 2017-05-24 17:36:44 |
Message-ID: | 20170524173644.1440.53348@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14669
Logged by: Igor Neyman
Email address: ineyman(at)perceptron(dot)com
PostgreSQL version: 10beta1
Operating system: Windows
Description:
Installed 10BETA1 which I downloaded from EnterpriseDB. Can't make logical
replication working.
Created Publication on “source” PG server just fine, 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”
servers:
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.
So, it looks like a problem with logical replication and not with my
setup/configuration.
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2017-05-24 20:22:16 | Re: BUG #14666: Question on money type as the key of partitioned table |
Previous Message | Michael Paquier | 2017-05-24 15:43:06 | Re: Can't restore view with pg_restore |