设置repmgr时出现pg_hba错误

Question

请帮助我解决它，帮助是非常感谢的！

错误：

FATAL:  no pg_hba.conf entry for replication connection from host "172.18.0.4", user "repmgr", SSL on

以下是我的pg_hba条目列表：

以下是来自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       |         |

如您所见，pg_hba.conf确实被加载到数据库中。我哪里做错了？

Answer 1

终于成功了！

由于每次连接尝试都会对pg_hba.conf记录进行顺序检查，因此记录的顺序是重要的。通常，早期记录将具有紧密的连接匹配参数和较弱的身份验证方法，而稍后的记录将具有更松散的匹配参数和更强的身份验证方法。