Regular expression matching in pg_hba.conf and pg_ident.conf
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
Configuration Management
Description
Both pg_hba.conf and pg_ident.conf allow for regular expression matching on usernames. pg_hba.conf also supports regular expression matching on database names.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 414
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "regular-expression-matching-in-pg_hbaconf-and-pg_identconf",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Regular expression matching in pg_hba.conf and pg_ident.conf",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Regular expression matching in pg_hba.conf and pg_ident.conf",
"NameLocale": "en",
"GroupKey": "configuration-management",
"GroupName": "Configuration Management",
"GroupLocale": "en",
"Ordinal": 5,
"GroupOrder": 13,
"Facts": {
"feature": {
"description": "Both [`pg_hba.conf`](https://www.postgresql.org/docs/16/auth-pg-hba-conf.html) and [`pg_ident.conf`](https://www.postgresql.org/docs/16/auth-username-maps.html) allow for regular expression matching on usernames. `pg_hba.conf` also supports regular expression matching on database names.",
"name": "Regular expression matching in pg_hba.conf and pg_ident.conf",
"versions": {
"16": "Yes"
}
},
"group": "Configuration Management",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "13",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Regular expression matching in pg_hba.conf and pg_ident.conf",
"BodyHTML": "\u003cp\u003eBoth \u003ca href=\"https://www.postgresql.org/docs/16/auth-pg-hba-conf.html\" rel=\"nofollow\"\u003e\u003ccode\u003epg_hba.conf\u003c/code\u003e\u003c/a\u003e and \u003ca href=\"https://www.postgresql.org/docs/16/auth-username-maps.html\" rel=\"nofollow\"\u003e\u003ccode\u003epg_ident.conf\u003c/code\u003e\u003c/a\u003e allow for regular expression matching on usernames. \u003ccode\u003epg_hba.conf\u003c/code\u003e also supports regular expression matching on database names.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "14441fbbff2adeb3b94bdd65e7bfa671fd69ae09540d70046d2e34fe5f0f6b24",
"Payload": {
"description": "Both [`pg_hba.conf`](https://www.postgresql.org/docs/16/auth-pg-hba-conf.html) and [`pg_ident.conf`](https://www.postgresql.org/docs/16/auth-username-maps.html) allow for regular expression matching on usernames. `pg_hba.conf` also supports regular expression matching on database names.",
"name": "Regular expression matching in pg_hba.conf and pg_ident.conf",
"versions": {
"16": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "pg_hba.conf 与 pg_ident.conf 的正则表达式匹配",
"BodyHTML": "\u003cp\u003e\u003ccode\u003epg_hba.conf\u003c/code\u003e 和 \u003ccode\u003epg_ident.conf\u003c/code\u003e 现在都支持对数据库名和用户名使用正则表达式匹配。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "527bdaeb6e961149c5b832ffc049d3cb038d5fe0310fc621c4a4d543ed02ee0f",
"Payload": {
"description": "`pg_hba.conf` 和 `pg_ident.conf` 现在都支持对数据库名和用户名使用正则表达式匹配。",
"name": "pg_hba.conf 与 pg_ident.conf 的正则表达式匹配"
}
}
],
"GroupTitles": {
"en": "Configuration Management",
"zh-Hans": "配置管理"
},
"LegacyIDs": [
"414"
]
}