Re: [GENERAL] logical replication in PG10 BETA - Mailing list pgsql-general

On 05/23/2017 01:38 PM, Igor Neyman wrote:
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] 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
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

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@aklaver.com