{"Entry":{"collection":"catalog","key":"pg_file_settings","name":"pg_file_settings","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.4","order":false,"removed":[],"status":"added","to":"9.5","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.5","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.6","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]}],"column_count":7,"content_hash":"f0c827e5f82153bc185efaa4a8f918bbe4011d56db142afc27cd61c3608de78f","derived_content_hash":"16400eb848b8a7c109df29d49d23d067e6347adf5e2df7a555527cd326b92111","first_version":"9.5","imported_at":"2026-09-30T00:40:55.532583+08:00","kind":"view","last_version":"20","name":"pg_file_settings","position":29,"present_in":["9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:86cee67e75c1c3616e715dc968c19597557cda1d96018995540aa00a91f9342d","summary":"The view pg_file_settings provides a summary of the contents of the server's configuration file(s).","summary_zh":"视图 pg_file_settings 提供了服务器配置文件的内容摘要。每个“name = value”条目在文件中出现时，此视图中会出现一行，并附有标注，指示该值是否能够成功应用。还可能出现额外的行，用于表示与“name = value”条目无关的问题，例如文件中的语法错误。"}},"Definition":{"Collection":"catalog","Key":"pg_file_settings","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_file_settings","SourceRevision":"catalog-bilingual-repair:86cee67e75c1c3616e715dc968c19597557cda1d96018995540aa00a91f9342d","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Full path name of the configuration file","description_zh":"配置文件的完整路径名","documented":true,"documented_name":"sourcefile","hidden":false,"name":"sourcefile","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Line number within the configuration file where the entry appears","description_zh":"该项在配置文件中出现的行号","documented":true,"documented_name":"sourceline","hidden":false,"name":"sourceline","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Order in which the entries are processed (1..n)","description_zh":"项被处理的顺序（1..n）","documented":true,"documented_name":"seqno","hidden":false,"name":"seqno","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Configuration parameter name","description_zh":"配置参数名","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Value to be assigned to the parameter","description_zh":"将赋给该参数的值","documented":true,"documented_name":"setting","hidden":false,"name":"setting","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"True if the value can be applied successfully","description_zh":"如果该值能够成功应用则为真","documented":true,"documented_name":"applied","hidden":false,"name":"applied","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"If not null, an error message indicating why this entry could not be applied","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_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each “name = value” entry appearing in the files, with annotations indicating whether the value could be applied successfully. Additional row(s) may appear for problems not linked to a “name = value” entry, such as syntax errors in the files.\n\nThis view is helpful for checking whether planned changes in the configuration files will work, or for diagnosing a previous failure. Note that this view reports on the current contents of the files, not on what was last applied by the server. (The pg_settings view is usually sufficient to determine that.)\n\nBy default, the pg_file_settings view can be read only by superusers.","description_zh":"视图 pg_file_settings 提供了服务器配置文件的内容摘要。每个“name = value”条目在文件中出现时，此视图中会出现一行，并附有标注，指示该值是否能够成功应用。还可能出现额外的行，用于表示与“name = value”条目无关的问题，例如文件中的语法错误。\n\n这个视图对于检查计划中的配置文件变更是否有效，或者诊断之前的故障很有帮助。请注意，这个视图报告的是文件的当前内容，而不是服务器上最后应用的内容。（通常可以通过 pg_settings 视图确定最后一次由服务器应用的内容。）\n\n默认情况下，pg_file_settings 视图只能被超级用户读取。","description_zh_html":"\u003cp\u003e视图 pg_file_settings 提供了服务器配置文件的内容摘要。每个“name = value”条目在文件中出现时，此视图中会出现一行，并附有标注，指示该值是否能够成功应用。还可能出现额外的行，用于表示与“name = value”条目无关的问题，例如文件中的语法错误。\u003c/p\u003e\n\u003cp\u003e这个视图对于检查计划中的配置文件变更是否有效，或者诊断之前的故障很有帮助。请注意，这个视图报告的是文件的当前内容，而不是服务器上最后应用的内容。（通常可以通过 pg_settings 视图确定最后一次由服务器应用的内容。）\u003c/p\u003e\n\u003cp\u003e默认情况下，pg_file_settings 视图只能被超级用户读取。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.12.6","file":"view-pg-file-settings.html","lang":"en","sha256":"cfdfe9675c1c977429a34df071b53436e2b99dba22e01c6e2beefa676b2881db","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["sourcefile","sourceline","seqno","name","setting","applied","error"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-file-settings.html","sha256":"94db4fbed19e9395947d54b88ad6d148162763c8dd4f812539f7293d30b2ad7c","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:ee48347897d948ce97aba9a8055e8d115090b1823281bc0da4e4b9e7a5595c65","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.12.6","file":"view-pg-file-settings.html","lang":"en","sha256":"cfdfe9675c1c977429a34df071b53436e2b99dba22e01c6e2beefa676b2881db","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-file-settings.html","sha256":"94db4fbed19e9395947d54b88ad6d148162763c8dd4f812539f7293d30b2ad7c","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:ee48347897d948ce97aba9a8055e8d115090b1823281bc0da4e4b9e7a5595c65","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["sourcefile","sourceline","seqno","name","setting","applied","error"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_file_settings","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_file_settings","Summary":"The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each “name = value” entry appearing in the files, with annotations indicating whether the value could be applied successfully. Additional row(s) may appear for problems not linked to a “name = value” entry, such as syntax errors in the files.\n\nThis view is helpful for checking whether planned changes in the configuration files will work, or for diagnosing a previous failure. Note that this view reports on the current contents of the files, not on what was last applied by the server. (The pg_settings view is usually sufficient to determine that.)\n\nBy default, the pg_file_settings view can be read only by superusers.","BodyHTML":"\u003cp\u003eThe view pg_file_settings provides a summary of the contents of the server\u0026#39;s configuration file(s). A row appears in this view for each “name = value” entry appearing in the files, with annotations indicating whether the value could be applied successfully. Additional row(s) may appear for problems not linked to a “name = value” entry, such as syntax errors in the files.\n\nThis view is helpful for checking whether planned changes in the configuration files will work, or for diagnosing a previous failure. Note that this view reports on the current contents of the files, not on what was last applied by the server. (The pg_settings view is usually sufficient to determine that.)\n\nBy default, the pg_file_settings view can be read only by superusers.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:86cee67e75c1c3616e715dc968c19597557cda1d96018995540aa00a91f9342d","ContentHash":"ae686e8351a9cf5125ef34461ed65d28cd5271bb2627094e023f8b863a5f8556","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Full path name of the configuration file","description_zh":"配置文件的完整路径名","documented":true,"documented_name":"sourcefile","hidden":false,"name":"sourcefile","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Line number within the configuration file where the entry appears","description_zh":"该项在配置文件中出现的行号","documented":true,"documented_name":"sourceline","hidden":false,"name":"sourceline","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Order in which the entries are processed (1..n)","description_zh":"项被处理的顺序（1..n）","documented":true,"documented_name":"seqno","hidden":false,"name":"seqno","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Configuration parameter name","description_zh":"配置参数名","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Value to be assigned to the parameter","description_zh":"将赋给该参数的值","documented":true,"documented_name":"setting","hidden":false,"name":"setting","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"True if the value can be applied successfully","description_zh":"如果该值能够成功应用则为真","documented":true,"documented_name":"applied","hidden":false,"name":"applied","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"If not null, an error message indicating why this entry could not be applied","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_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each “name = value” entry appearing in the files, with annotations indicating whether the value could be applied successfully. Additional row(s) may appear for problems not linked to a “name = value” entry, such as syntax errors in the files.\n\nThis view is helpful for checking whether planned changes in the configuration files will work, or for diagnosing a previous failure. Note that this view reports on the current contents of the files, not on what was last applied by the server. (The pg_settings view is usually sufficient to determine that.)\n\nBy default, the pg_file_settings view can be read only by superusers."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}