DBA Hub

📋Steps in this guide1/1

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
1

Find pg_hba.conf file content

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
-- 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)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!