no pg_hba.conf entry for replication connection

From: armand pirvu <armand(dot)pirvu(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: no pg_hba.conf entry for replication connection
Date: 2017-08-16 20:26:43
Message-ID: 4B19ADD5-7B8F-46A0-B06C-F7AA1487843A@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thks for help

AP

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Samad 2017-08-16 22:25:17 Re: Begginers question
Previous Message Jerry Sievers 2017-08-16 19:57:41 Re: Logging failed connections