对于运行 9.0.X 的用户，不需要进行转储/恢复。
\n不过，如果你是从早于 9.0.6 的版本升级，请参见第 E.18 节。
", "compatibility_count": 0, "label": "9.0.8", "status_label": "历史版本", "eol": "2015-10-08", "age_days": 5231, "support_days": -4010}, "groups": [{"date": "2012-06-04", "build": "9.0.8", "major": "9.0", "minor": 8, "manual": "9.0", "status": "stable", "doc_git": "", "version": "9.0.8", "eol_date": "2015-10-08", "date_text": "2012-06-04", "supported": false, "manual_url": "/docs/9.0/release-9-0-8.html", "source_url": "/docs/release/9.0.8/", "entry_count": 27, "placeholder": false, "content_hash": "84dc39e4117bfcbc39211cf81fb642146eff82475be41e71aa8f75a6b89a586d", "manual_build": "9.0.23", "source_as_of": "", "changes_count": 27, "doc_loaded_at": "2026-09-26T02:56:48.570247", "migration_html": "对于运行 9.0.X 的用户，不需要进行转储/恢复。
\n不过，如果你是从早于 9.0.6 的版本升级，请参见第 E.18 节。
", "compatibility_count": 0, "label": "9.0.8", "status_label": "历史版本", "eol": "2015-10-08", "age_days": 5231, "support_days": -4010, "entries": [{"id": "9.0.8-f7e027714cbe55a9", "cves": ["CVE-2012-2143"], "html": "修复 contrib/pgcrypto 的 DES crypt() 函数中不正确的口令变换（Solar Designer）
如果口令串包含字节值 0x80，口令的其余部分会被忽略，使口令比看起来弱得多。修复后，字符串的其余部分会被正确纳入 DES 哈希。因此，受此缺陷影响的任何已存储口令值将不再匹配，所以可能需要更新已存储的值。（CVE-2012-2143）
忽略过程语言调用处理程序的 SECURITY DEFINER 和 SET 属性（Tom Lane）
把这类属性应用于调用处理程序可能导致服务器崩溃。（CVE-2012-2655）
", "text": "忽略过程语言调用处理程序的 SECURITY DEFINER 和 SET 属性（Tom Lane） 把这类属性应用于调用处理程序可能导致服务器崩溃。（CVE-2012-2655）", "title": "忽略过程语言调用处理程序的 SECURITY DEFINER 和 SET 属性", "commits": [], "section": "变更", "category": "security", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "bbdb239a6841f1e9d3da8a3a37b3e91395b788f87fd1a80b91653ba2dd93352c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Ignore SECURITY DEFINER and SET attributes for a procedural language's call handler (Tom Lane) Applying such attributes to a call handler could crash the server. (CVE-2012-2655)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/002", "db_id": "2dc791f135e8a00bb8117ee8ba9bbf9f", "patch_ids": [], "statement_hash": "3a45f8c9f78d68b6bb81173d47eee8e0f3bfb011cdfceb55b611990b4bfde531", "relations": [{"rule": 2, "type": "equivalent", "target": "1e9aa9dadb7f705940e29fe92ef4e58c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a45f8c9f78d68b6bb81173d47eee8e0f3bfb011cdfceb55b611990b4bfde531"}}], "version": "9.0.8", "category_label": "安全相关", "also_in": [], "variants": [], "related_changes": [{"db_id": "1e9aa9dadb7f705940e29fe92ef4e58c", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "忽略过程语言调用处理程序的 SECURITY DEFINER 和 SET 属性", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3a45f8c9f78d68b6bb81173d47eee8e0f3bfb011cdfceb55b611990b4bfde531"}, "url": "/docs/compare/?release=9.1.4#9.1.4-950752998fe1f2a1", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-c62fc7c46c9b6370", "cves": [], "html": "允许 timestamp 输入中的数字时区偏移距 UTC 最多 16 小时（Tom Lane）
一些历史时区的偏移超过此前 15 小时的限制。这可能导致转储的数据值在重载期间被拒绝。
", "text": "允许 timestamp 输入中的数字时区偏移距 UTC 最多 16 小时（Tom Lane） 一些历史时区的偏移超过此前 15 小时的限制。这可能导致转储的数据值在重载期间被拒绝。", "title": "允许 timestamp 输入中的数字时区偏移距 UTC 最多 16 小时", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "095455017b66c55da7ed039aa3f5560a3263adfea20dda6aa302de82de828030", "section_path": ["变更"], "commit_groups": [], "identity_text": "Allow numeric timezone offsets in timestamp input to be up to 16 hours away from UTC (Tom Lane) Some historical time zones have offsets larger than 15 hours, the previous limit. This could result in dumped data values being rejected during reload.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/003", "db_id": "66dfcc585e0253d76efafa427b1cfacf", "patch_ids": [], "statement_hash": "c3e3ec0ac5c3d36697ec4d7790092641fb62939d3e45a1ab5fb07e9627be88e7", "relations": [{"rule": 2, "type": "equivalent", "target": "148a0e4a0398fc58c07421da3704ba28", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3e3ec0ac5c3d36697ec4d7790092641fb62939d3e45a1ab5fb07e9627be88e7"}}], "version": "9.0.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "148a0e4a0398fc58c07421da3704ba28", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "允许 timestamp 输入中的数字时区偏移距 UTC 最多 16 小时", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c3e3ec0ac5c3d36697ec4d7790092641fb62939d3e45a1ab5fb07e9627be88e7"}, "url": "/docs/compare/?release=9.1.4#9.1.4-c62fc7c46c9b6370", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-8d118edb2ae197ca", "cves": [], "html": "修复时间戳转换，使其在给定时间恰好是当前时区最后一次夏令时转换时间时能正确处理（Tom Lane）
\n这一疏忽已存在很长时间，但此前未被注意到，因为大多数使用夏令时的时区被假定有无限的未来夏令时转换序列。
", "text": "修复时间戳转换，使其在给定时间恰好是当前时区最后一次夏令时转换时间时能正确处理（Tom Lane） 这一疏忽已存在很长时间，但此前未被注意到，因为大多数使用夏令时的时区被假定有无限的未来夏令时转换序列。", "title": "修复时间戳转换，使其在给定时间恰好是当前时区最后一次夏令时转换时间时能正确处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "dcb250ef64a23c07160dcef95f88732260b4bea6fb201bd5fc62375f81319c48", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix timestamp conversion to cope when the given time is exactly the last DST transition time for the current timezone (Tom Lane) This oversight has been there a long time, but was not noticed previously because most DST-using zones are presumed to have an indefinite sequence of future DST transitions.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/004", "db_id": "adbae31d5c047fe31754c449e1bbaa24", "patch_ids": [], "statement_hash": "83fe48e3588100d31ea25ded9b792e4acf012f89a6827c2e26ad123c24092655", "relations": [{"rule": 2, "type": "equivalent", "target": "dba677f0792ea4293b27390098dc3d6d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83fe48e3588100d31ea25ded9b792e4acf012f89a6827c2e26ad123c24092655"}}], "version": "9.0.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "dba677f0792ea4293b27390098dc3d6d", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "修复时间戳转换，使其在给定时间恰好是当前时区最后一次夏令时转换时间时能正确处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83fe48e3588100d31ea25ded9b792e4acf012f89a6827c2e26ad123c24092655"}, "url": "/docs/compare/?release=9.1.4#9.1.4-8d118edb2ae197ca", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-cb1403d26eab4c62", "cves": [], "html": "修复 text 到 name 以及 char 到 name 的转换，使其在多字节编码下正确执行字符串截断（Karl Schnaitter）
修复 to_tsquery() 中的内存复制缺陷（Heikki Linnakangas）
确保 txid_current() 在热备中执行时报告正确的纪元（epoch）（Simon Riggs）
修复规划器对子查询内外层 PlaceHolderVar 的处理（Tom Lane）
\n该缺陷涉及引用来自外层查询外连接可空侧变量的子 SELECT。在 9.1 中，受此缺陷影响的查询会报 “ERROR: Upper-level PlaceHolderVar found where not expected” 失败。但在 9.0 和 8.4 中，你会静默地得到可能错误的答案，因为传入子查询的值不会在该为空时变为空。
", "text": "修复规划器对子查询内外层 PlaceHolderVar 的处理（Tom Lane） 该缺陷涉及引用来自外层查询外连接可空侧变量的子 SELECT。在 9.1 中，受此缺陷影响的查询会报 “ERROR: Upper-level PlaceHolderVar found where not expected” 失败。但在 9.0 和 8.4 中，你会静默地得到可能错误的答案，因为传入子查询的值不会在该为空时变为空。", "title": "修复规划器对子查询内外层 PlaceHolderVar 的处理", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "74402dad6b2aa4c05f2ded5ac17ec2100eab3cb773d7b741805a6b81b4c7e85b", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix planner's handling of outer PlaceHolderVars within subqueries (Tom Lane) This bug concerns sub-SELECTs that reference variables coming from the nullable side of an outer join of the surrounding query. In 9.1, queries affected by this bug would fail with ERROR: Upper-level PlaceHolderVar found where not expected. But in 9.0 and 8.4, you'd silently get possibly-wrong answers, since the value transmitted into the subquery wouldn't go to null when it should.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/008", "db_id": "19a6e1973e59e9da729551e85bc3d665", "patch_ids": [], "statement_hash": "8ee28efc2fbfda74cb453da5f680773337fd25421ee1855c571078dd937bb706", "relations": [{"rule": 2, "type": "equivalent", "target": "ef188976cac2505dda8376e40a42b5d1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ee28efc2fbfda74cb453da5f680773337fd25421ee1855c571078dd937bb706"}}], "version": "9.0.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ef188976cac2505dda8376e40a42b5d1", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "修复规划器对子查询内外层 PlaceHolderVar 的处理", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ee28efc2fbfda74cb453da5f680773337fd25421ee1855c571078dd937bb706"}, "url": "/docs/compare/?release=9.1.4#9.1.4-6c756bffcdb78f66", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-0ee6a4c6ae8c98fb", "cves": [], "html": "修复 pg_attribute 非常大会话启动缓慢的问题（Tom Lane）
如果 pg_attribute 超过 shared_buffers 的四分之一，会话启动期间有时需要的缓存重建代码就会触发同步扫描逻辑，使其耗时比正常情况多数倍。如果许多新会话同时启动，问题尤为严重。
确保顺序扫描以合理的频率检查查询取消（Merlin Moncure）
\n遇到许多不含存活元组的连续页面的扫描在此期间不会响应中断。
", "text": "确保顺序扫描以合理的频率检查查询取消（Merlin Moncure） 遇到许多不含存活元组的连续页面的扫描在此期间不会响应中断。", "title": "确保顺序扫描以合理的频率检查查询取消", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "48f014989507f574f50e0319eea1787d248a8c0acb89c83bd8cb242202121d25", "section_path": ["变更"], "commit_groups": [], "identity_text": "Ensure sequential scans check for query cancel reasonably often (Merlin Moncure) A scan encountering many consecutive pages that contain no live tuples would not respond to interrupts meanwhile.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/010", "db_id": "1adeba20bc22f27bf9f5441c733c00fe", "patch_ids": [], "statement_hash": "32c4ebad7086dd8ff0fb67a82b5d81e2020c0da9c949bd90c1da163f46f80891", "relations": [{"rule": 2, "type": "equivalent", "target": "bd6436e92343187447f9bd25be2155e3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "32c4ebad7086dd8ff0fb67a82b5d81e2020c0da9c949bd90c1da163f46f80891"}}], "version": "9.0.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "bd6436e92343187447f9bd25be2155e3", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "确保顺序扫描以合理的频率检查查询取消", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "32c4ebad7086dd8ff0fb67a82b5d81e2020c0da9c949bd90c1da163f46f80891"}, "url": "/docs/compare/?release=9.1.4#9.1.4-dd3e7759287e444a", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-a6be6a0fdf406fc1", "cves": [], "html": "确保 PGSemaphoreLock() 的 Windows 实现在返回前清除 ImmediateInterruptOK（Tom Lane）
这一疏忽意味着同一查询稍后收到的查询取消中断可能在不安全的时刻被接受，后果不可预测且不好。
", "text": "确保 PGSemaphoreLock() 的 Windows 实现在返回前清除 ImmediateInterruptOK（Tom Lane） 这一疏忽意味着同一查询稍后收到的查询取消中断可能在不安全的时刻被接受，后果不可预测且不好。", "title": "确保 PGSemaphoreLock() 的 Windows 实现在返回前清除 ImmediateInterruptOK", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "0515df05c357e80f06528ed45102c74a7345c0c78656281ee72ab3a2948a8f1b", "section_path": ["变更"], "commit_groups": [], "identity_text": "Ensure the Windows implementation of PGSemaphoreLock() clears ImmediateInterruptOK before returning (Tom Lane) This oversight meant that a query-cancel interrupt received later in the same query could be accepted at an unsafe time, with unpredictable but not good consequences.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/011", "db_id": "621e08ded86dac462543a1b66528aedf", "patch_ids": [], "statement_hash": "475baa30bf05e7068b9227b884192b9296ffb209bb282f734ab8b4f1bad76d95", "relations": [{"rule": 2, "type": "equivalent", "target": "db01691604fa124e6f972589c146118e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "475baa30bf05e7068b9227b884192b9296ffb209bb282f734ab8b4f1bad76d95"}}], "version": "9.0.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "db01691604fa124e6f972589c146118e", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "确保 PGSemaphoreLock() 的 Windows 实现在返回前清除 ImmediateInterruptOK", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "475baa30bf05e7068b9227b884192b9296ffb209bb282f734ab8b4f1bad76d95"}, "url": "/docs/compare/?release=9.1.4#9.1.4-a6be6a0fdf406fc1", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-37785b7bff0bb5e4", "cves": [], "html": "在打印视图或规则时安全地显示整行变量（Abbas Butt、Tom Lane）
\n涉及有歧义名称（即该名称既可能是查询的表名也可能是列名）的极端情况此前以有歧义的方式打印，存在视图或规则在转储和重载后被不同解释的风险。现通过附加无操作转换来避免歧义情况。
", "text": "在打印视图或规则时安全地显示整行变量（Abbas Butt、Tom Lane） 涉及有歧义名称（即该名称既可能是查询的表名也可能是列名）的极端情况此前以有歧义的方式打印，存在视图或规则在转储和重载后被不同解释的风险。现通过附加无操作转换来避免歧义情况。", "title": "在打印视图或规则时安全地显示整行变量", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "3e74b472e7c0b99515ebc321a5a5838a351a6c867b3a9ba9b84464243793b519", "section_path": ["变更"], "commit_groups": [], "identity_text": "Show whole-row variables safely when printing views or rules (Abbas Butt, Tom Lane) Corner cases involving ambiguous names (that is, the name could be either a table or column name of the query) were printed in an ambiguous way, risking that the view or rule would be interpreted differently after dump and reload. Avoid the ambiguous case by attaching a no-op cast.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/012", "db_id": "046268baafb6eb208a178d325c4f509f", "patch_ids": [], "statement_hash": "b08bd7aedbfa17f2c0ae9439b638e1f95a9356d905183fa9049d8bf16d7b6dcb", "relations": [{"rule": 2, "type": "equivalent", "target": "4c8e9274b22ace290b1f223746068ee3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b08bd7aedbfa17f2c0ae9439b638e1f95a9356d905183fa9049d8bf16d7b6dcb"}}], "version": "9.0.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "4c8e9274b22ace290b1f223746068ee3", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "在打印视图或规则时安全地显示整行变量", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b08bd7aedbfa17f2c0ae9439b638e1f95a9356d905183fa9049d8bf16d7b6dcb"}, "url": "/docs/compare/?release=9.1.4#9.1.4-37785b7bff0bb5e4", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-829dca33ef5c035f", "cves": [], "html": "修复 COPY FROM，使其正确处理对应无效编码的空值标记串（Tom Lane）
诸如 E'\\\\0' 这样的空值标记串本应有效，过去也确实有效，但该情况在 8.4 中被破坏。
确保自动清理工作进程正确执行栈深度检查（Heikki Linnakangas）
\n此前，由自动 ANALYZE 调用的函数中的无限递归可能导致工作进程崩溃。
修复日志收集器，使其在高负载下不丢失日志连贯性（Andrew Dunstan）
\n此前，如果收集器过于忙碌，可能无法重新组装大消息。
", "text": "修复日志收集器，使其在高负载下不丢失日志连贯性（Andrew Dunstan） 此前，如果收集器过于忙碌，可能无法重新组装大消息。", "title": "修复日志收集器，使其在高负载下不丢失日志连贯性", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "92a514017fd659be3e62a4e84ff9ac785df62dba2904561c23526e0231724645", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix logging collector to not lose log coherency under high load (Andrew Dunstan) The collector previously could fail to reassemble large messages if it got too busy.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/015", "db_id": "7bf5d3e7f3ea95a754f5c5a79f806a3b", "patch_ids": [], "statement_hash": "a8f1eaf60d9cbec4f01617787fed23b1a7342ea79b3c4a281c02d49023cafb0e", "relations": [{"rule": 2, "type": "equivalent", "target": "b153bdac2cdae4cf4c2db4419094a37c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a8f1eaf60d9cbec4f01617787fed23b1a7342ea79b3c4a281c02d49023cafb0e"}}], "version": "9.0.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "b153bdac2cdae4cf4c2db4419094a37c", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "修复日志收集器，使其在高负载下不丢失日志连贯性", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a8f1eaf60d9cbec4f01617787fed23b1a7342ea79b3c4a281c02d49023cafb0e"}, "url": "/docs/compare/?release=9.1.4#9.1.4-6bfe9c34cb456dbf", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-b91475414d755f42", "cves": [], "html": "修复日志收集器，确保它在收到 SIGHUP 后会重新开始文件轮转（Tom Lane）
", "text": "修复日志收集器，确保它在收到 SIGHUP 后会重新开始文件轮转（Tom Lane）", "title": "修复日志收集器，确保它在收到 SIGHUP 后会重新开始文件轮转", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "ab1071859ba97152c11f5b6a38b747a6de1aab06302f74487e414a0272650715", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix logging collector to ensure it will restart file rotation after receiving SIGHUP (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/016", "db_id": "848cae60cce40e40e5f5d0f271a779af", "patch_ids": [], "statement_hash": "6fac7f36ad3dde95d58b318c8f49bfa7bae648666592c387f0e27dca94ab7c6b", "relations": [{"rule": 2, "type": "equivalent", "target": "874b3ea93908f9ba5c8325180087db06", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fac7f36ad3dde95d58b318c8f49bfa7bae648666592c387f0e27dca94ab7c6b"}}], "version": "9.0.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "874b3ea93908f9ba5c8325180087db06", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "修复日志收集器，确保它在收到 SIGHUP 后会重新开始文件轮转", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fac7f36ad3dde95d58b318c8f49bfa7bae648666592c387f0e27dca94ab7c6b"}, "url": "/docs/compare/?release=9.1.4#9.1.4-b91475414d755f42", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-079134671ec2bd62", "cves": [], "html": "修复 GIN 索引的 WAL 重放逻辑，使其在索引随后被删除时不失败（Tom Lane）
", "text": "修复 GIN 索引的 WAL 重放逻辑，使其在索引随后被删除时不失败（Tom Lane）", "title": "修复 GIN 索引的 WAL 重放逻辑，使其在索引随后被删除时不失败", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "9c968194c67f0d8782fce65804003937935d85c5c96170c7279f172e067c889e", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix WAL replay logic for GIN indexes to not fail if the index was subsequently dropped (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/017", "db_id": "f31f64f9c579661cdacb2fbfa7f24af1", "patch_ids": [], "statement_hash": "3c20319e0fbcbc1ecbf8cc8cc2c9c0d70f21c12ade0d88c48cc5722447792d84", "relations": [{"rule": 2, "type": "equivalent", "target": "78130b6a8a0ac77de9d35f9a208a5366", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c20319e0fbcbc1ecbf8cc8cc2c9c0d70f21c12ade0d88c48cc5722447792d84"}}], "version": "9.0.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "78130b6a8a0ac77de9d35f9a208a5366", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "修复 GIN 索引的 WAL 重放逻辑，使其在索引随后被删除时不失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c20319e0fbcbc1ecbf8cc8cc2c9c0d70f21c12ade0d88c48cc5722447792d84"}, "url": "/docs/compare/?release=9.1.4#9.1.4-079134671ec2bd62", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-20ade416d0c79ad8", "cves": [], "html": "修复 PL/pgSQL 的 RETURN NEXT 命令中的内存泄漏（Joe Conway）
修复 PL/pgSQL 的 GET DIAGNOSTICS 命令在目标是函数第一个变量时的问题（Tom Lane）
修复 psql 扩展显示（\\x）模式中可能越过内存末尾的访问（Peter Eisentraut）
修复数据库包含大量对象时 pg_dump 的若干性能问题（Jeff Janes、Tom Lane）
\n如果数据库包含许多模式、许多对象处于依赖循环中、或有许多被拥有的序列，pg_dump 可能变得非常慢。
", "text": "修复数据库包含大量对象时 pg_dump 的若干性能问题（Jeff Janes、Tom Lane） 如果数据库包含许多模式、许多对象处于依赖循环中、或有许多被拥有的序列，pg_dump 可能变得非常慢。", "title": "修复数据库包含大量对象时 pg_dump 的若干性能问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "0b7b863e6ad07da1a0c1b29b0e6399b9cbafefcbfb400ad6e854033bf55f1521", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix several performance problems in pg_dump when the database contains many objects (Jeff Janes, Tom Lane) pg_dump could get very slow if the database contained many schemas, or if many objects are in dependency loops, or if there are many owned sequences.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/021", "db_id": "5b97b955dcbbdace43be1ac7e00eca55", "patch_ids": [], "statement_hash": "ba9de3cb96597ea955a9878da3161da87dfdaf13e916d135578cb969c0f0a402", "relations": [{"rule": 2, "type": "equivalent", "target": "e3be79fdcc3d8276f9c34911da1b31e1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba9de3cb96597ea955a9878da3161da87dfdaf13e916d135578cb969c0f0a402"}}], "version": "9.0.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "e3be79fdcc3d8276f9c34911da1b31e1", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "修复数据库包含大量对象时 pg_dump 的若干性能问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba9de3cb96597ea955a9878da3161da87dfdaf13e916d135578cb969c0f0a402"}, "url": "/docs/compare/?release=9.1.4#9.1.4-f207e94deeeb708f", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-891206aa6a7bb4b6", "cves": [], "html": "修复 pg_upgrade 处理存储在非默认表空间的数据库包含集簇默认表空间中的表的情况（Bruce Momjian）
", "text": "修复 pg_upgrade 处理存储在非默认表空间的数据库包含集簇默认表空间中的表的情况（Bruce Momjian）", "title": "修复 pg_upgrade 处理存储在非默认表空间的数据库包含集簇默认表空间中的表的情况", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "3a5130d2f40e09ab624cebd62dfdebfddab087f3853ddfbded5155986a620e56", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix pg_upgrade for the case that a database stored in a non-default tablespace contains a table in the cluster's default tablespace (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/022", "db_id": "01705f9cce568b7bae7577ad54fe41ee", "patch_ids": [], "statement_hash": "8aad3c1d6704206ddf8218a7c0e100bc2566e7363ba0fcc9658c1870879f552d", "relations": [{"rule": 2, "type": "equivalent", "target": "c7ed7794cd7dd70f465e312ef9cf1d26", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8aad3c1d6704206ddf8218a7c0e100bc2566e7363ba0fcc9658c1870879f552d"}}], "version": "9.0.8", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "c7ed7794cd7dd70f465e312ef9cf1d26", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "修复 pg_upgrade 处理存储在非默认表空间的数据库包含集簇默认表空间中的表的情况", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8aad3c1d6704206ddf8218a7c0e100bc2566e7363ba0fcc9658c1870879f552d"}, "url": "/docs/compare/?release=9.1.4#9.1.4-891206aa6a7bb4b6", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}, {"id": "9.0.8-f27d2854a7c714d2", "cves": [], "html": "在 ecpg 中，修复罕见的内存泄漏以及 sqlca_t 结构之后一个字节可能被覆写的问题（Peter Eisentraut）
修复 contrib/dblink 的 dblink_exec()，使其在出错时不泄漏临时数据库连接（Tom Lane）
修复 contrib/dblink，使其在错误消息中报告正确的连接名（Kyotaro Horiguchi）
修复 contrib/vacuumlo，使其在删除许多大对象时使用多个事务（Tim Lewis、Robert Haas、Tom Lane）
此变更避免了需要删除许多对象时超出 max_locks_per_transaction。该行为可以通过新的 -l（limit）选项调整。
把时区数据文件更新为 tzdata 版本 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands; also historical corrections for Canada。
", "text": "把时区数据文件更新为 tzdata 版本 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands; also historical corrections for Canada。", "title": "把时区数据文件更新为 tzdata 版本 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands; also historical corrections for Canada。", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.0.8/#id-1.11.6.20.5", "source_hash": "dc0176a41c662846b8edd357cf239310d2889274a66ba9ecc80334be96fa97b7", "section_path": ["变更"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands; also historical corrections for Canada.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.8/changes/027", "db_id": "545903ff595e4f4546424f7f487341da", "patch_ids": [], "statement_hash": "3f17c38061acf5621020544a0ed298975c38f8f64df80267f36868e3cdcb8114", "relations": [{"rule": 2, "type": "equivalent", "target": "0a49d71104e76727e9d5ecdcfc06035e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3f17c38061acf5621020544a0ed298975c38f8f64df80267f36868e3cdcb8114"}}], "version": "9.0.8", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "0a49d71104e76727e9d5ecdcfc06035e", "kind": "equivalent", "version": "9.1.4", "label": "9.1.4", "title": "把时区数据文件更新为 tzdata 版本 2012c for DST law changes in Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron, Morocco, Syria, and Tokelau Islands; also historical corrections for Canada。", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3f17c38061acf5621020544a0ed298975c38f8f64df80267f36868e3cdcb8114"}, "url": "/docs/compare/?release=9.1.4#9.1.4-7dd8898a26f7107e", "source_url": "/docs/release/9.1.4/#id-1.11.6.25.5"}]}]}], "stats": [{"key": "all", "label": "全部变更", "count": 27}, {"key": "feature", "label": "新功能", "count": 0}, {"key": "bugfix", "label": "BUG 修复", "count": 19}, {"key": "security", "label": "安全相关", "count": 2}, {"key": "performance", "label": "性能改进", "count": 0}, {"key": "compatibility", "label": "兼容性变化", "count": 0}, {"key": "improvement", "label": "其他改进", "count": 6}], "total": 27, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2012-2655", "url": "https://www.postgresql.org/support/security/CVE-2012-2655/", "fixed": {"8.3": "8.3.19", "8.4": "8.4.12", "9.0": "9.0.8", "9.1": "9.1.4"}, "score": null, "title": "忽略过程语言调用处理程序的 SECURITY DEFINER 和 SET 属性", "vector": "", "affected": {"8.3": "8.3", "8.4": "8.4", "9.0": "9.0", "9.1": "9.1"}, "component": "", "published": {}, "introduced": {}, "cvss_version": "", "description_en": "", "first_published": null, "fixed_version": "9.0.8"}, {"id": "CVE-2012-2143", "url": "https://www.postgresql.org/support/security/CVE-2012-2143/", "fixed": {"8.3": "8.3.19", "8.4": "8.4.12", "9.0": "9.0.8", "9.1": "9.1.4"}, "score": null, "title": "修复 contrib/pgcrypto 的 DES crypt() 函数中不正确的口令变换", "vector": "", "affected": {"8.3": "8.3", "8.4": "8.4", "9.0": "9.0", "9.1": "9.1"}, "component": "", "published": {}, "introduced": {}, "cvss_version": "", "description_en": "", "first_published": null, "fixed_version": "9.0.8"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 27, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}