Re: [GENERAL] logical replication in PG10 BETA

On Tue, 23 May 2017 15:15:46 +0000, Igor Neyman
<ineyman@perceptron.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