{"Entry":{"collection":"catalog","key":"pg_hba_file_rules","name":"pg_hba_file_rules","aliases":[],"metadata":{"changed_in":["16"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":["rule_number","file_name"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Line number of this rule in pg_hba.conf","name":"line_number","to":"Line number of this rule in file_name"}],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]}],"column_count":11,"content_hash":"beb57839fa533cd56e8c538198d15c0b2cb422168052f4b51de0ab9a5bf7ab13","first_version":"10","imported_at":"2026-09-30T00:40:55.555949+08:00","kind":"view","last_version":"20","name":"pg_hba_file_rules","position":34,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:c574d4053d527ea1c34ad31da3add262731680b24ac988658504bdb1b0fd5ae2","summary":"The view pg_hba_file_rules provides a summary of the contents of the client authentication configuration file, pg_hba.conf.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_hba_file_rules","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_hba_file_rules","SourceRevision":"english-manuals:c574d4053d527ea1c34ad31da3add262731680b24ac988658504bdb1b0fd5ae2","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"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.","description_zh":"","documented":true,"documented_name":"rule_number","hidden":false,"name":"rule_number","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":2,"description":"Name of the file containing this rule","description_zh":"","documented":true,"documented_name":"file_name","hidden":false,"name":"file_name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":3,"description":"Line number of this rule in file_name","description_zh":"","documented":true,"documented_name":"line_number","hidden":false,"name":"line_number","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":4,"description":"Type of connection","description_zh":"","documented":true,"documented_name":"type","hidden":false,"name":"type","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":5,"description":"List of database name(s) to which this rule applies","description_zh":"","documented":true,"documented_name":"database","hidden":false,"name":"database","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009},{"array_dimensions":0,"attnum":6,"description":"List of user and group name(s) to which this rule applies","description_zh":"","documented":true,"documented_name":"user_name","hidden":false,"name":"user_name","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009},{"array_dimensions":0,"attnum":7,"description":"Host name or IP address, or one of all, samehost, or samenet, or null for local connections","description_zh":"","documented":true,"documented_name":"address","hidden":false,"name":"address","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":8,"description":"IP address mask, or null if not applicable","description_zh":"","documented":true,"documented_name":"netmask","hidden":false,"name":"netmask","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":9,"description":"Authentication method","description_zh":"","documented":true,"documented_name":"auth_method","hidden":false,"name":"auth_method","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":10,"description":"Options specified for authentication method, if any","description_zh":"","documented":true,"documented_name":"options","hidden":false,"name":"options","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009},{"array_dimensions":0,"attnum":11,"description":"If not null, an error message indicating why this line could not be processed","description_zh":"","documented":true,"documented_name":"error","hidden":false,"name":"error","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25}],"description":"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.\n\nThis 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.\n\nBy default, the pg_hba_file_rules view can be read only by superusers.","description_zh":"","doc":{"anchor":"id-1.10.5.14.6","file":"view-pg-hba-file-rules.html","lang":"en","sha256":"37122eec67ba83fbfaa3683d6873ee5058079cdedf510eaff8369a558fa014b0","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["rule_number","file_name","line_number","type","database","user_name","address","netmask","auth_method","options","error"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.14.6","file":"view-pg-hba-file-rules.html","lang":"en","sha256":"37122eec67ba83fbfaa3683d6873ee5058079cdedf510eaff8369a558fa014b0","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["rule_number","file_name","line_number","type","database","user_name","address","netmask","auth_method","options","error"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_hba_file_rules","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_hba_file_rules","Summary":"视图pg_hba_file_rules提供客户端认证配置文件 pg_hba.conf 内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该规则是否能成功应用。\n\n该视图有助于检查认证配置文件中的计划变更是否可行，或诊断先前的失败。请注意，该视图报告的是文件的当前内容，而不是服务器上次加载的内容。\n\n默认情况下，pg_hba_file_rules 视图只能由超级用户读取。","BodyHTML":"\u003cp\u003e视图pg_hba_file_rules提供客户端认证配置文件 pg_hba.conf 内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该规则是否能成功应用。\n\n该视图有助于检查认证配置文件中的计划变更是否可行，或诊断先前的失败。请注意，该视图报告的是文件的当前内容，而不是服务器上次加载的内容。\n\n默认情况下，pg_hba_file_rules 视图只能由超级用户读取。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"c28c828a6d75c742ae2632a19b47b801ac5e633671477f2efa0f29d295ef4777","Payload":{"columns":[{"description_zh":"如果该规则有效，则为其编号；否则为 NULL。这表示认证期间在找到匹配项之前，各条规则被考虑的顺序。","name":"rule_number","type":"integer","zh_from":"doc"},{"description_zh":"包含此规则的文件名称","name":"file_name","type":"text","zh_from":"doc"},{"description_zh":"该规则在 file_name 中的行号","name":"line_number","type":"integer","zh_from":"doc"},{"description_zh":"连接类型","name":"type","type":"text","zh_from":"doc"},{"description_zh":"这条规则应用的数据库名列表","name":"database","type":"text[]","zh_from":"doc"},{"description_zh":"这条规则应用的用户及组名列表","name":"user_name","type":"text[]","zh_from":"doc"},{"description_zh":"主机名或IP地址，或者all、samehost、samenet之一，对于本地连接为 NULL","name":"address","type":"text","zh_from":"doc"},{"description_zh":"IP地址掩码，如果不适用则为 NULL","name":"netmask","type":"text","zh_from":"doc"},{"description_zh":"认证方法","name":"auth_method","type":"text","zh_from":"doc"},{"description_zh":"为认证方法指定的选项（如果有）","name":"options","type":"text[]","zh_from":"doc"},{"description_zh":"如果非空，则为说明为什么该行无法处理的错误消息","name":"error","type":"text","zh_from":"doc"}],"description_zh":"视图pg_hba_file_rules提供客户端认证配置文件 pg_hba.conf 内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该规则是否能成功应用。\n\n该视图有助于检查认证配置文件中的计划变更是否可行，或诊断先前的失败。请注意，该视图报告的是文件的当前内容，而不是服务器上次加载的内容。\n\n默认情况下，pg_hba_file_rules 视图只能由超级用户读取。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}