{"Entry":{"collection":"guc","key":"server_version","name":"server_version","aliases":[],"metadata":{"baseline":false,"boot_human":"Not specified","boot_val":null,"category":"Preset Options","category_zh":"","changed_in":["9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19"],"changes":[{"documentation_changed":false,"fields":{},"from":"7.4","status":"added","to":"8.0"},{"documentation_changed":true,"fields":{},"from":"8.0","status":"changed","to":"8.1"},{"documentation_changed":false,"fields":{"boot_val":{"from":"9.0.23","to":"9.1.24"}},"from":"9.0","status":"changed","to":"9.1"},{"documentation_changed":false,"fields":{"boot_val":{"from":"9.1.24","to":"9.2.23"}},"from":"9.1","status":"changed","to":"9.2"},{"documentation_changed":false,"fields":{"boot_val":{"from":"9.2.23","to":"9.3.25"}},"from":"9.2","status":"changed","to":"9.3"},{"documentation_changed":false,"fields":{"boot_val":{"from":"9.3.25","to":"9.4.26"}},"from":"9.3","status":"changed","to":"9.4"},{"documentation_changed":false,"fields":{"boot_val":{"from":"9.4.26","to":"9.5.25"}},"from":"9.4","status":"changed","to":"9.5"},{"documentation_changed":false,"fields":{"boot_val":{"from":"9.5.25","to":"9.6.24"}},"from":"9.5","status":"changed","to":"9.6"},{"documentation_changed":false,"fields":{"boot_val":{"from":"9.6.24","to":"10.23 (Debian 10.23-1.pgdg110+1)"}},"from":"9.6","status":"changed","to":"10"},{"documentation_changed":false,"fields":{"boot_val":{"from":"10.23 (Debian 10.23-1.pgdg110+1)","to":"11.22 (Debian 11.22-1.pgdg120+1)"}},"from":"10","status":"changed","to":"11"},{"documentation_changed":false,"fields":{"boot_val":{"from":"11.22 (Debian 11.22-1.pgdg120+1)","to":"12.22 (Debian 12.22-1.pgdg120+1)"}},"from":"11","status":"changed","to":"12"},{"documentation_changed":false,"fields":{"boot_val":{"from":"12.22 (Debian 12.22-1.pgdg120+1)","to":"13.23 (Debian 13.23-1.pgdg13+1)"}},"from":"12","status":"changed","to":"13"},{"documentation_changed":false,"fields":{"boot_val":{"from":"13.23 (Debian 13.23-1.pgdg13+1)","to":"14.24 (Debian 14.24-1.pgdg13+2)"}},"from":"13","status":"changed","to":"14"},{"documentation_changed":false,"fields":{"boot_val":{"from":"14.24 (Debian 14.24-1.pgdg13+2)","to":"15.19 (Debian 15.19-1.pgdg13+2)"}},"from":"14","status":"changed","to":"15"},{"documentation_changed":false,"fields":{"boot_val":{"from":"15.19 (Debian 15.19-1.pgdg13+2)","to":"16.15 (Debian 16.15-1.pgdg13+2)"}},"from":"15","status":"changed","to":"16"},{"documentation_changed":false,"fields":{"boot_val":{"from":"16.15 (Debian 16.15-1.pgdg13+2)","to":"17.11 (Debian 17.11-1.pgdg13+2)"}},"from":"16","status":"changed","to":"17"},{"documentation_changed":false,"fields":{"boot_val":{"from":"17.11 (Debian 17.11-1.pgdg13+2)","to":"18.6 (Debian 18.6-1.pgdg13+2)"}},"from":"17","status":"changed","to":"18"},{"documentation_changed":false,"fields":{"boot_val":{"from":"18.6 (Debian 18.6-1.pgdg13+2)","to":"19beta4 (Debian 19~beta4-1.pgdg13+1)"}},"from":"18","status":"changed","to":"19"}],"content_hash":"47099f5ccf13937690f70e8c46f900fd2328a6fe9a9e139254bfba118b6a3fe3","context":"","default_changed_in":["9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19"],"default_history":[{"from":"9.0","to":"9.0","value":"9.0.23"},{"from":"9.1","to":"9.1","value":"9.1.24"},{"from":"9.2","to":"9.2","value":"9.2.23"},{"from":"9.3","to":"9.3","value":"9.3.25"},{"from":"9.4","to":"9.4","value":"9.4.26"},{"from":"9.5","to":"9.5","value":"9.5.25"},{"from":"9.6","to":"9.6","value":"9.6.24"},{"from":"10","to":"10","value":"10.23 (Debian 10.23-1.pgdg110+1)"},{"from":"11","to":"11","value":"11.22 (Debian 11.22-1.pgdg120+1)"},{"from":"12","to":"12","value":"12.22 (Debian 12.22-1.pgdg120+1)"},{"from":"13","to":"13","value":"13.23 (Debian 13.23-1.pgdg13+1)"},{"from":"14","to":"14","value":"14.24 (Debian 14.24-1.pgdg13+2)"},{"from":"15","to":"15","value":"15.19 (Debian 15.19-1.pgdg13+2)"},{"from":"16","to":"16","value":"16.15 (Debian 16.15-1.pgdg13+2)"},{"from":"17","to":"17","value":"17.11 (Debian 17.11-1.pgdg13+2)"},{"from":"18","to":"18","value":"18.6 (Debian 18.6-1.pgdg13+2)"},{"from":"19","to":"19","value":"19beta4 (Debian 19~beta4-1.pgdg13+1)"}],"derived_content_hash":"39a89006706fbfd8f9e710902f7aadb1ce7b450cb519cc9e7ad691d65439dbc8","editorial":{"advice":{"olap":"Not tunable. Use server_version to verify format, build, or resource assumptions on analytical nodes and keep every read/write candidate compatible.","oltp":"Not tunable. Record server_version as a deployment/capability fact; if it is unexpected, fix the binary, initdb, or database-creation process rather than trying SET.","small":"Not tunable. Preserve it in inventory and incident reports; do not custom-build or rebuild merely to change it without a demonstrated compatibility need."},"mechanism":["Shows the server version. It is read-only and cannot be changed with SET or configuration-file edits.","It is the human-readable server build/version string and may include vendor packaging text; it is not safe for numeric ordering.","Interpret it with server_version_num, server_encoding, ssl_library. Applications and operations tooling may read server_version for capability or environment detection, but cannot SET it; cross-cluster comparisons must account for build, initdb, and current-database differences."],"pitfalls":["Trying to change read-only server_version with SET or a configuration file.","Assuming every cluster, database, or vendor build reports the same value.","Ignoring the value in file-format or feature-compatibility checks.","Treating reported metadata as a performance target instead of an environment fact."],"references":[{"title":"PostgreSQL 19 Beta 4: server_version","url":"https://www.postgresql.org/docs/19/runtime-config-preset.html#GUC-SERVER-VERSION"},{"title":"PostgreSQL 19 release notes","url":"https://www.postgresql.org/docs/19/release-19.html"}],"related":["server_version_num","server_encoding","ssl_library","integer_datetimes","debug_assertions","block_size"],"summary":"server_version — Shows the server version. Observed in PG9.0–19 Beta 4; its last measured boot default is 19beta4 (Debian 19~beta4-1.pgdg13+1) in PG19 Beta 4, with internal context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA."},"enumvals":[],"first_version":"8.0","group":"Preset Options","group_slug":"preset","imported_at":"2026-09-27T17:57:31.94862+08:00","intro_commit":{},"key":"server_version","last_version":"20","max_val":"","min_val":"","name":"server_version","position":353,"present_in":["8.0","8.1","8.2","8.3","8.4","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"],"repair_provenance":{"original_source_revision":"english-manuals:f9670d104c5d03a6a9eaa1ac578c7e161e13c249c91b0c9b8a5a05950a1794d7","receipt_sha256":"2352a6869159d6d68ab944d18ef9b45ced877a8a7e0ecdff1981fbe24385313b","repair":"wiki-repair-20261023"},"short_desc":"Reports the version number of the server.","short_desc_zh":"","source_rev":"wiki-repair-20261023:dc663636d8ace0c1d83d109c6d629761101b543d73c76be6a462637087b2def3","unit":"","vartype":"string"}},"Definition":{"Collection":"guc","Key":"server_version","SourceDatabase":"center","Version":"18","SourceTable":"guc","SourceKey":"server_version","SourceRevision":"wiki-repair-20261023:dc663636d8ace0c1d83d109c6d629761101b543d73c76be6a462637087b2def3","Facts":{"boot_val":"18.6 (Debian 18.6-1.pgdg13+2)","category":"Preset Options","context":"internal","description":"Reports the version number of the server. It is determined by the value of PG_VERSION when building the server.","description_zh":"报告服务器的版本号。它是由编译服务器时的 PG_VERSION 值决定的。","description_zh_html":"\u003cp\u003e\n        报告服务器的版本号。它是由编译服务器时的 \u003ccode class=\"literal\"\u003ePG_VERSION\u003c/code\u003e 值决定的。\n       \u003c/p\u003e","doc":{"anchor":"GUC-SERVER-VERSION","file":"runtime-config-preset.html","lang":"en","sha256":"4dbfec727b9cee838adefb8a766217748d91ab90190b452a58cec737459582ce","slug":"18"},"documented":true,"enumvals":null,"extra_desc":null,"lang":"en","max_val":null,"metadata_version":"18","min_val":null,"name":"server_version","short_desc":"Shows the server version.","source":"pg-settings-source-snapshot","translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/runtime-config-preset.html","sha256":"d0e95b9a81d5fdf853df26eba7dc096d96b9b45dadda13e0d0353aa72ac7a7b9"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"unit":null,"vartype":"string","zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"GUC-SERVER-VERSION","file":"runtime-config-preset.html","lang":"en","sha256":"4dbfec727b9cee838adefb8a766217748d91ab90190b452a58cec737459582ce","slug":"18"}},"MeasuredEvidence":{"metadata_version":"18"}},"Text":{"Collection":"guc","Key":"server_version","SourceDatabase":"center","Version":"18","Locale":"en","Title":"server_version","Summary":"Reports the version number of the server. It is determined by the value of PG_VERSION when building the server.","BodyHTML":"\u003cp\u003eReports the version number of the server. It is determined by the value of PG_VERSION when building the server.\u003c/p\u003e","SourceRevision":"wiki-repair-20261023:dc663636d8ace0c1d83d109c6d629761101b543d73c76be6a462637087b2def3","ContentHash":"ef5aed9de10dfe2c73342d9ae4409ca5d8d8e6fe73a15c0a27a3084b5953bfb1","Payload":{"description":"Reports the version number of the server. It is determined by the value of PG_VERSION when building the server."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}