Re: [GENERAL] logical replication in PG10 BETA

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of George Neuner
Sent: Tuesday, May 23, 2017 4:22 PM
To: pgsql-general@postgresql.org
Subject: 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
withany 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