Re: logical replication in PG10 BETA

On 05/23/2017 01:38 PM, Igor Neyman wrote:
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)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 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(dot)klaver(at)aklaver(dot)com