Re: [GENERAL] logical replication in PG10 BETA

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com] 
Sent: Tuesday, May 23, 2017 10:31 AM
To: Igor Neyman <ineyman@perceptron.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA


On 05/23/2017 07:05 AM, Igor Neyman wrote:

>>
>> pg_hba.conf modified to allow "replication" user to connect to the server.
>> In the original email I mentioned that I configured Postgres_fdw foreign server that connects using the same
connectionoptions as I'm using in CREATE SUBSCRIPTION, and foreign server works fine, which to me proves that there is
noissues with pg_hba.conf.
 
>
> What are the contents of the pg_hba.conf file?
>
> What are the CREATE PUBLICATION and CREATE SUBSCRIPTION commands you are using?
>
>
>>
>> Regards,
>> Igor
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
> ______________________________________________________________________
> _____________________________________
>
> These two systems are my "sandboxes".

Define sandbox:

Are they on VMs on a single machine or something else?

>
> So, here is pg_hba on the publishing server:
>
> # 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

I do not see an IPv6 all hosts entry for repl_user, Something like:

host    all   repl_user  ::/0  md5

_______________________________________________________________________________________

Not a single machine.
Publisher is on a physical machine.
Subscriber is on VM.

Nothing changed after I added IPV6 entry:

host    all   repl_user  ::/0  md5

on publishing machine.

Regards,
Igor