Search Postgresql Archives

Re: no pg_hba.conf entry for replication connection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux