On 05/23/2017 01:38 PM, Igor Neyman wrote:
-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of George Neuner
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
So take the local line out of pg_hba. Then from the machine that is the subscriber do:
psql -d repl -h pub_machine -p 5432 -U repl_user
Regards, Igor
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
