Re: logical replication in PG10 BETA

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of George Neuner
Sent: Tuesday, May 23, 2017 4:22 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] logical replication in PG10 BETA
On Tue, 23 May 2017 15:15:46 +0000, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:

>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?

Windows does not support "local" domain sockets as in Unix/Linux.

Local loopback connections on Windows are made using normal TCP or UDP sockets. You need to configure permissions as with any remote client, only specifying the localhost addresses 127.0.0.1 and/or ::1.

George
____________________________________________________________________________________________________

Well, I have that in pg_hba:

# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all repl_user 0.0.0.0/0 md5
# IPv6 local connections
host all all ::1/128 md5

Regards,
Igor