Yep relaoded
But darn typo
Finger going too fast I guess
Thanks bunch
AP
> On Aug 16, 2017, at 8:03 PM, Ian Barwick <ian.barw...@2ndquadrant.com> wrote:
>
> On 08/17/2017 05:26 AM, armand pirvu wrote:
>> Hi
>> master (172.16.26.7) and slave (172.16.26.4)
>> master runs on port 5433 though
>> SELECT pglogical.create_subscription( subscription_name := 'shw_sub',
>> replication_sets := '{shw_set}',
>> provider_dsn := 'host=172.16.26.7 port=5433 dbname=levregdb user=repuser');
>> ERROR: could not connect to the postgresql server in replication mode:
>> FATAL: no pg_hba.conf entry for replication connection from host
>> "172.16.26.4", user "repuser", SSL off
>> DETAIL: dsn was: host=172.16.26.7 port=5433 dbname=levregdb user=repuser
>> My pg_hba.conf from both
>> local replication repuser md5
>> host replication repuser 127.0.0.1/32 mds5
>> host replication repuser 0.0.0.0/0 mds5
>> local all repuser md5
>> host all repuser 127.0.0.1/32 md5
>> host all repuser 0.0.0.0/0 md5
>> So what am I missing ?
>> Strange is that I followed
>
> Did you reload the configuration after changing pg_hba.conf, e.g.
> "SELECT pg_reload_conf()"?
>
> Also, looks like you have a typo:
>
> > host replication repuser 127.0.0.1/32 mds5
> > host replication repuser 0.0.0.0/0 mds5
>
> mds5 -> md5
>
>
> Regards
>
> Ian Barwick
>
> --
> Ian Barwick http://www.2ndQuadrant.com/
> <http://www.2ndquadrant.com/>
> PostgreSQL Development, 24x7 Support, Training & Services
