{"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":"aadbc2395447f6ec8878783be7f33e6dfd378902433efc0c053e4f880e3d4e3c","derived_content_hash":"4be4f9cd58d8cb2f363d271c28afd4e3978f220dfd1a83b4410c1fe1de8aa59e","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":"catalog-bilingual-repair:2cf4afc9f2088b8165d178395356c654d06de6014f37bd753c8a183495b0886e","summary":"The view pg_hba_file_rules provides a summary of the contents of the client authentication configuration file, pg_hba.conf.","summary_zh":"视图 pg_hba_file_rules 提供客户端认证配置文件 pg_hba.conf 内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该规则是否能成功应用。"}},"Definition":{"Collection":"catalog","Key":"pg_hba_file_rules","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_hba_file_rules","SourceRevision":"catalog-bilingual-repair:2cf4afc9f2088b8165d178395356c654d06de6014f37bd753c8a183495b0886e","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":"如果该规则有效，则为其编号；否则为 NULL。这表示认证期间在找到匹配项之前，各条规则被考虑的顺序。","documented":true,"documented_name":"rule_number","hidden":false,"name":"rule_number","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Line number of this rule in file_name","description_zh":"该规则在 file_name 中的行号","documented":true,"documented_name":"line_number","hidden":false,"name":"line_number","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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":"主机名或 IP 地址，或者 all、samehost、samenet 之一，对于本地连接为 NULL","documented":true,"documented_name":"address","hidden":false,"name":"address","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"IP address mask, or null if not applicable","description_zh":"IP 地址掩码，如果不适用则为 NULL","documented":true,"documented_name":"netmask","hidden":false,"name":"netmask","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"}],"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":"视图 pg_hba_file_rules 提供客户端认证配置文件 pg_hba.conf 内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该规则是否能成功应用。\n\n该视图有助于检查认证配置文件中的计划变更是否可行，或诊断先前的失败。请注意，该视图报告的是文件的当前内容，而不是服务器上次加载的内容。\n\n默认情况下，pg_hba_file_rules 视图只能由超级用户读取。","description_zh_html":"\u003cp\u003e视图 pg_hba_file_rules 提供客户端认证配置文件 pg_hba.conf 内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该规则是否能成功应用。\u003c/p\u003e\n\u003cp\u003e该视图有助于检查认证配置文件中的计划变更是否可行，或诊断先前的失败。请注意，该视图报告的是文件的当前内容，而不是服务器上次加载的内容。\u003c/p\u003e\n\u003cp\u003e默认情况下，pg_hba_file_rules 视图只能由超级用户读取。\u003c/p\u003e","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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-hba-file-rules.html","sha256":"5dd57b4e214b07cd352c26f5ce4e20441f2272cd94ec325d8b4ea5e7d3dfce31","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:c574d4053d527ea1c34ad31da3add262731680b24ac988658504bdb1b0fd5ae2","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.14.6","file":"view-pg-hba-file-rules.html","lang":"en","sha256":"37122eec67ba83fbfaa3683d6873ee5058079cdedf510eaff8369a558fa014b0","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-hba-file-rules.html","sha256":"5dd57b4e214b07cd352c26f5ce4e20441f2272cd94ec325d8b4ea5e7d3dfce31","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:c574d4053d527ea1c34ad31da3add262731680b24ac988658504bdb1b0fd5ae2","version":"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":"center","Version":"18","Locale":"en","Title":"pg_hba_file_rules","Summary":"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.","BodyHTML":"\u003cp\u003eThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:2cf4afc9f2088b8165d178395356c654d06de6014f37bd753c8a183495b0886e","ContentHash":"26104a3193e7fa734fcf4a93edffbb3098f3f9c49b15a909ff4b491a2ece8149","Payload":{"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":"如果该规则有效，则为其编号；否则为 NULL。这表示认证期间在找到匹配项之前，各条规则被考虑的顺序。","documented":true,"documented_name":"rule_number","hidden":false,"name":"rule_number","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Line number of this rule in file_name","description_zh":"该规则在 file_name 中的行号","documented":true,"documented_name":"line_number","hidden":false,"name":"line_number","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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":"主机名或 IP 地址，或者 all、samehost、samenet 之一，对于本地连接为 NULL","documented":true,"documented_name":"address","hidden":false,"name":"address","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"IP address mask, or null if not applicable","description_zh":"IP 地址掩码，如果不适用则为 NULL","documented":true,"documented_name":"netmask","hidden":false,"name":"netmask","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"}],"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."}},"RequestedLocale":"en","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}