From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: logical replication in PG10 BETA |
Date: | 2017-05-23 15:15:46 |
Message-ID: | DM5PR07MB2810374390673ED05EA6518BDAF90@DM5PR07MB2810.namprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Adrian Klaver
Sent: Tuesday, May 23, 2017 10:04 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 06:52 AM, Igor Neyman wrote:
>
>
> sounds more like a SSL setup problem between the two Postgres servers, not really related to logical replication.
>
> Can you try to setup the connections without SSL?
>
> ______________________________________________________________________
> __________________________________
>
> That's what I thought when I first saw this error.
> But, I don't understand why is it trying to use sockets.
> I have ssl=off in postgresql.conf on both sides.
AFAIK on Windows Postgres maps sockets to localhost.
Anyway that was why I was asking about your pg_hba.conf and PUBLICATION and SUBSCRIPTION settings, to see what is actually being requested?
>
> Regards,
> Igor
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
_________________________________________________________________________________________________________________
Interestingly, when I add this line to pg_hba.conf:
local all all md5
Postgres is not starting with the following error in the log file:
2017-05-23 11:02:10.397 EDT [4796] LOG: local connections are not supported by this build
2017-05-23 11:02:10.397 EDT [4796] CONTEXT: line 1 of configuration file "C:/PostgreSQL/10/data/pg_hba.conf"
2017-05-23 11:02:10.398 EDT [4796] FATAL: could not load pg_hba.conf
2017-05-23 11:02:10.403 EDT [4796] LOG: database system is shut down
The line I added is the first line.
" LOG: local connections are not supported by this build" - is this related to my problems with CREATE SUBSCRIPTION?
And another question:
Anyone from 2ndQuadrant could verify that pglogical included in the core PG10 BETA (packed by EnterpriseDB) supports Windows?
Regards,
Igor
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2017-05-23 15:18:02 | Re: libpg sources |
Previous Message | John McKown | 2017-05-23 14:54:13 | Re: libpg sources |