Thread: [GENERAL] no pg_hba.conf entry for replication connection
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 connectionfrom 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
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 connectionfrom 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
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.barwick@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/
PostgreSQL Development, 24x7 Support, Training & Services