no pg_hba.conf entry for replication connection

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Yep relaoded

But darn typo

Finger going too fast I guess

Thanks bunch
AP