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.
Number of this rule, if valid, otherwise
Name of the file containing this rule
Line number of this rule in
Type of connection
List of database name(s) to which this rule applies
List of user and group name(s) to which this rule applies
Host name or IP address, or one of
IP address mask, or null if not applicable
Options specified for authentication method, if any
If not null, an error message indicating why this line could not be processed
Usually, a row reflecting an incorrect entry will have values for only the
See Chapter 21 for more information about client authentication configuration.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.