重庆思庄Oracle、Redhat认证学习论坛

标题: 如何通过SQL语句查看pg_hba.conf的生效配置 [打印本页]

作者: 郑全 时间: 2024-9-27 13:46
标题: 如何通过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)

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)