如何通过SQL语句查看pg_hba.conf的生效配置

有时，我们修改了PG_HBA.conf文件内容，感觉没有生效，或则想看看当前生效的配置信息是什么，如何查呢

其实，可以通过SQL语句查询的

使用 select * from pg_hba_file_rules;即可

postgres=# select * from pg_hba_file_rules ;
rule_number | file_name | line_number | type | database | user_name | address |
netmask | auth_method | options | error
-------------+--------------------------------------+-------------+-------+---------------+-----------+-----------+---
--------------------------------------+-------------+---------+-------
1 | /u01/app/postgres/pgdata/pg_hba.conf | 117 | local | {all} | {all} | |
| md5 | |
2 | /u01/app/postgres/pgdata/pg_hba.conf | 119 | host | {all} | {all} | 127.0.0.1 | 25
5.255.255.255 | md5 | |
3 | /u01/app/postgres/pgdata/pg_hba.conf | 121 | host | {all} | {all} | ::1 | ff
ff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | md5 | |
4 | /u01/app/postgres/pgdata/pg_hba.conf | 124 | local | {replication} | {all} | |
| trust | |
5 | /u01/app/postgres/pgdata/pg_hba.conf | 125 | host | {replication} | {all} | 127.0.0.1 | 25
5.255.255.255 | trust | |
6 | /u01/app/postgres/pgdata/pg_hba.conf | 126 | host | {replication} | {all} | ::1 | ff
ff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | trust | |
7 | /u01/app/postgres/pgdata/pg_hba.conf | 128 | host | {all} | {all} | 0.0.0.0 | 0.
0.0.0 | md5 | |
(7 rows)