On 08/17/2017 05:26 AM, armand pirvu wrote:
Himaster (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
