-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of George Neuner Sent: Tuesday, May 23, 2017 4:22 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: logical replication in PG10 BETA 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 ____________________________________________________________________________________________________ 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
