SYSTEM CATALOGS / SYSTEM VIEWS
pg_hba_file_rules
Read PG 18 manual ↗The view pg_hba_file_rules provides a summary of the contents of the client authentication configuration file, pg_hba.conf.
- Kind
- System views
- Columns in this snapshot
- 11
- Definition source
- English manual
Columns 11
| Column | Type | Description / reference |
|---|---|---|
rule_number | int4 | Number of this rule, if valid, otherwise NULL. This indicates the order in which each rule is considered until a match is found during authentication. |
file_name | text | Name of the file containing this rule |
line_number | int4 | Line number of this rule in file_name |
type | text | Type of connection |
database | text[] | List of database name(s) to which this rule applies |
user_name | text[] | List of user and group name(s) to which this rule applies |
address | text | Host name or IP address, or one of all, samehost, or samenet, or null for local connections |
netmask | text | IP address mask, or null if not applicable |
auth_method | text | Authentication method |
options | text[] | Options specified for authentication method, if any |
error | text | If not null, an error message indicating why this line could not be processed |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
line_number | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
type | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
database | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
user_name | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
address | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
netmask | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
auth_method | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
options | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
error | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
rule_number | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● |
file_name | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● |
Version history 2
- PG 15 → 16changed
- PG 9.6 → 10added
Definition snapshot: english-manuals:be5417acf295e6b483b2c80f1a1… · English manual source