Re: logical replication in PG10 BETA

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Tuesday, May 23, 2017 5:48 PM
To: Igor Neyman <ineyman(at)perceptron(dot)com>; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 08:15 AM, Igor Neyman wrote:
>
> -----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?

I think you are going to need to be more specific. I see pglogical as the extension provided by 2ndQuadrant and builtin logical as provided by the core server. If you are referring to the extension then see my post upstream where I reference the pglogical issue that addresses this at least partly.

>
> Regards,
> Igor
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
______________________________________________________________________________________________________

From the very beginning in this thread I was talking about logical replication built-in core server PG10 BETA, not pglogical extension.
Sorry, if I didn't make it clear.

Regards,
Igor