From: | Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com> |
---|---|
To: | armand pirvu <armand(dot)pirvu(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: no pg_hba.conf entry for replication connection |
Date: | 2017-08-17 01:03:51 |
Message-ID: | b9a9e082-7f34-55e8-ffc7-d21f6e097c1f@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | armand pirvu | 2017-08-17 02:29:59 | Re: no pg_hba.conf entry for replication connection |
Previous Message | Ian Barwick | 2017-08-17 00:51:38 | Re: cluster question |