53.10. pg_hba_file_rules
pg_hba_file_rules
The view pg_hba_file_rules provides a summary of the contents of the client authentication configuration file, pg_hba.conf.
A row appears in this view for each non-empty, non-comment line in the file, with annotations indicating whether the rule could be applied successfully.
This view can be helpful for checking whether planned changes in the authentication configuration file will work, or for diagnosing a previous failure. Note that this view reports on the current contents of the file, not on what was last loaded by the server.
By default, the pg_hba_file_rules view can be read only by superusers.
Column Type Description |
|---|
rule_number Number of this rule, if valid, otherwise |
file_name Name of the file containing this rule |
line_number Line number of this rule in |
type Type of connection |
database List of database name(s) to which this rule applies |
user_name List of user and group name(s) to which this rule applies |
address Host name or IP address, or one of |
netmask IP address mask, or null if not applicable |
auth_method Authentication method |
options Options specified for authentication method, if any |
error If not null, an error message indicating why this line could not be processed |
: pg_hba_file_rules Columns
Usually, a row reflecting an incorrect entry will have values for only the line_number and error fields.
See Client Authentication for more information about client authentication configuration.