Sample Header Ad - 728x90

pg_hba error while setting up repmgr

2 votes
1 answer
1660 views
Please help me to figure it out, help is much appreciated! ERROR: FATAL: no pg_hba.conf entry for replication connection from host "172.18.0.4", user "repmgr", SSL on The following is a list of my pg_hba entries:enter image description here The following is the query output from pg_hba_file_rules: line_number | type | database | user_name | address | netmask | auth_method | options | error ------------+-------+---------------+------------+------------+-----------------------------------------+-------------+---------+------- 85 | local | {all} | {postgres} | | | peer | | 90 | local | {all} | {all} | | | peer | | 92 | host | {all} | {all} | 127.0.0.1 | 255.255.255.255 | md5 | | 94 | host | {all} | {all} | ::1 | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | md5 | | 97 | local | {replication} | {all} | | | peer | | 98 | host | {replication} | {all} | 127.0.0.1 | 255.255.255.255 | md5 | | 99 | host | {replication} | {all} | ::1 | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | md5 | | 101 | host | {all} | {repmgr} | 172.18.0.0 | 255.255.255.0 | trust | | 102 | host | {replication} | {repmgr} | 172.18.0.0 | 255.255.255.0 | trust | | As you can see, the pg_hba.conf did get loaded to the database. Where did I do wrong?
Asked by CJ Chang (295 rep)
Feb 12, 2019, 02:04 PM
Last activity: Sep 24, 2022, 03:04 PM