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