Find pg_hba.conf file content
-- This provides a summary of contents of client authentication config file pg_hba.conf
postgresql configurationintermediate
by PostgreSQL
17 views
-- This provides a summary of contents of client authentication config file pg_hba.conf
12345678910111213
-- This provides a summary of contents of client authentication config file pg_hba.conf
postgres=#
select * from pg_hba_file_rules;
line_number | type | database | user_name | address | netmask | auth_method | options | error
-------------+-------+---------------+-----------+---------------+-----------------------------------------+-------------+---------+-------
80 | local | {all} | {all} | | | md5 | |
82 | host | {all} | {all} | 127.0.0.1 | 255.255.255.255 | ident | |
84 | host | {all} | {all} | ::1 | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | ident | |
85 | host | {all} | {all} | 172.21.19.148 | 255.255.255.255 | trust | |
88 | local | {replication} | {all} | | | peer | |
89 | host | {replication} | {all} | 127.0.0.1 | 255.255.255.255 | ident | |
90 | host | {replication} | {all} | ::1 | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff | ident | |
(7 rows)Please to add comments
No comments yet. Be the first to comment!