On Tue, 23 May 2017 15:15:46 +0000, Igor Neyman <ineyman@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
