{"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)"}],"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"],"short_desc":"Reports the version number of the server.","short_desc_zh":"","source_rev":"english-manuals:f9670d104c5d03a6a9eaa1ac578c7e161e13c249c91b0c9b8a5a05950a1794d7","unit":"","vartype":"string"}},"Definition":{"Collection":"guc","Key":"server_version","SourceDatabase":"center","Version":"18","SourceTable":"guc","SourceKey":"server_version","SourceRevision":"english-manuals:f9670d104c5d03a6a9eaa1ac578c7e161e13c249c91b0c9b8a5a05950a1794d7","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.","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","unit":null,"vartype":"string"},"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":"english-manuals:f9670d104c5d03a6a9eaa1ac578c7e161e13c249c91b0c9b8a5a05950a1794d7","ContentHash":"e55f0e370d0c1beba2a7a60c52faa6531ec0d9d95273d76910d7b0bbf341864d","Payload":{"description":"Reports the version number of the server. It is determined by the value of PG_VERSION when building the server."}},"RequestedLocale":"zh-Hans","Fallback":true,"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"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}