[GENERAL] no pg_hba.conf entry for replication connection

Поиск
Список
Период
Сортировка
От armand pirvu
Тема [GENERAL] no pg_hba.conf entry for replication connection
Дата
Msg-id 4B19ADD5-7B8F-46A0-B06C-F7AA1487843A@gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] no pg_hba.conf entry for replication connection  (Ian Barwick <ian.barwick@2ndquadrant.com>)
Список 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
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





В списке pgsql-general по дате отправления:

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: [GENERAL] Logging failed connections
Следующее
От: Alex Samad
Дата:
Сообщение: Re: [GENERAL] Begginers question