对于运行 9.1.X 的用户，不需要进行转储/恢复。
\n不过，本版本纠正了 GiST 索引管理中的若干错误。安装此更新后，建议对满足下述一个或多个条件的 GiST 索引执行 REINDEX。
不过，如果你是从早于 9.1.6 的版本升级，请参见第 E.19 节。
", "compatibility_count": 0, "label": "9.1.9", "status_label": "历史版本", "eol": "2016-10-27", "age_days": 4927, "support_days": -3625}, "groups": [{"date": "2013-04-04", "build": "9.1.9", "major": "9.1", "minor": 9, "manual": "9.1", "status": "stable", "doc_git": "", "version": "9.1.9", "eol_date": "2016-10-27", "date_text": "2013-04-04", "supported": false, "manual_url": "/docs/9.1/release-9-1-9.html", "source_url": "/docs/release/9.1.9/", "entry_count": 25, "placeholder": false, "content_hash": "2376eee701b9d5794a6c92eb40f2358380f20024b70aa74addca0e73ccec7b0b", "manual_build": "9.1.24", "source_as_of": "", "changes_count": 25, "doc_loaded_at": "2026-09-26T02:56:47.783417", "migration_html": "对于运行 9.1.X 的用户，不需要进行转储/恢复。
\n不过，本版本纠正了 GiST 索引管理中的若干错误。安装此更新后，建议对满足下述一个或多个条件的 GiST 索引执行 REINDEX。
不过，如果你是从早于 9.1.6 的版本升级，请参见第 E.19 节。
", "compatibility_count": 0, "label": "9.1.9", "status_label": "历史版本", "eol": "2016-10-27", "age_days": 4927, "support_days": -3625, "entries": [{"id": "9.1.9-5a0bba298aca3ca2", "cves": ["CVE-2013-1899"], "html": "修复服务器命令行开关解析不安全的问题（Mitsumasa Kondo、Kyotaro Horiguchi）
\n包含以 “-” 开头的数据库名的连接请求可能被精心构造，用于破坏或摧毁服务器数据目录中的文件，即使该请求最终被拒绝也是如此。（CVE-2013-1899）
在每个 postmaster 子进程中重置 OpenSSL 随机状态（Marko Kreen）
\n这避免了另一种情况：另一数据库用户可能相对容易地猜出 contrib/pgcrypto 函数生成的随机数。只有当 postmaster 配置了 ssl = on 而大多数连接并不使用 SSL 加密时，这一风险才比较显著。（CVE-2013-1900）
让 REPLICATION 权限检查测试当前用户而不是已认证用户（Noah Misch）
\n无特权数据库用户可能利用这一失误调用 pg_start_backup() 或 pg_stop_backup()，从而可能干扰例程备份的创建。（CVE-2013-1901）
修复 GiST 索引在不合适的情况下使用“模糊”几何比较的问题（Alexander Korotkov）
\n核心几何类型使用“模糊”相等进行比较，但 gist_box_same 必须做精确比较，否则使用它的 GiST 索引可能变得不一致。安装此更新后，用户应对 box、polygon、circle 或 point 列上的所有 GiST 索引执行 REINDEX，因为它们都使用 gist_box_same。
修复对可变宽度数据类型（即 text、bytea、bit 和 numeric 列）使用 contrib/btree_gist 的 GiST 索引中错误的范围并集和惩罚逻辑（Tom Lane）
这些错误可能导致不一致的索引：某些存在的键搜索不到，还会造成无用的索引膨胀。建议用户在安装此更新后对这类索引执行 REINDEX。
修复多列索引的 GiST 页面分裂代码中的缺陷（Tom Lane）
\n这些错误可能导致不一致的索引：某些存在的键搜索不到，还会使索引的搜索效率不必要地低下。建议用户在安装此更新后对多列 GiST 索引执行 REINDEX。
修复 gist_point_consistent，使其一致地处理模糊性（Alexander Korotkov）
point 列上 GiST 索引的索引扫描有时会得出与顺序扫描不同的结果，因为 gist_point_consistent 与底层操作符代码在是做精确比较还是模糊比较上不一致。
修复 WAL 重放中的缓冲区泄漏（Heikki Linnakangas）
\n这一缺陷可能导致重放期间出现 “incorrect local pin count” 错误，使恢复无法进行。
", "text": "修复 WAL 重放中的缓冲区泄漏（Heikki Linnakangas） 这一缺陷可能导致重放期间出现 “incorrect local pin count” 错误，使恢复无法进行。", "title": "修复 WAL 重放中的缓冲区泄漏", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "e9cf1f275165981fc99f5759a7c21cf3e945c18f0b10d1daef8b899d60974ac2", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix buffer leak in WAL replay (Heikki Linnakangas) This bug could result in incorrect local pin count errors during replay, making recovery impossible.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/008", "db_id": "4a92e9c821d28fd580c0c3b2bca1e74b", "patch_ids": [], "statement_hash": "513b0f6e1d7fbeb86839fce09010947a3ec33fda45f439d5fbc55dd329e23b26", "relations": [{"rule": 2, "type": "equivalent", "target": "772b9f670ad68798e92625552b47d5d1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "513b0f6e1d7fbeb86839fce09010947a3ec33fda45f439d5fbc55dd329e23b26"}}, {"rule": 2, "type": "equivalent", "target": "984b9e3e14545478e5b8dd020ea41923", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "513b0f6e1d7fbeb86839fce09010947a3ec33fda45f439d5fbc55dd329e23b26"}}], "version": "9.1.9", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "984b9e3e14545478e5b8dd020ea41923", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "修复 WAL 重放中的缓冲区泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "513b0f6e1d7fbeb86839fce09010947a3ec33fda45f439d5fbc55dd329e23b26"}, "url": "/docs/compare/?release=9.2.4#9.2.4-a2fd0526e4e1b17d", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}, {"db_id": "772b9f670ad68798e92625552b47d5d1", "kind": "equivalent", "version": "9.0.13", "label": "9.0.13", "title": "修复 WAL 重放中的缓冲区泄漏", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "513b0f6e1d7fbeb86839fce09010947a3ec33fda45f439d5fbc55dd329e23b26"}, "url": "/docs/compare/?release=9.0.13#9.0.13-a2fd0526e4e1b17d", "source_url": "/docs/release/9.0.13/#id-1.11.6.15.5"}]}, {"id": "9.1.9-624a98bb358c7569", "cves": [], "html": "修复 DELETE RETURNING 中的竞态条件（Tom Lane）
在合适的条件下，DELETE RETURNING 可能尝试从当前进程已不再持有任何 pin 的共享缓冲区中取数据。如果其他进程在此期间更改了该缓冲区，就会导致垃圾 RETURNING 输出，甚至崩溃。
修复正则表达式编译中的无限循环风险（Tom Lane、Don Porter）
", "text": "修复正则表达式编译中的无限循环风险（Tom Lane、Don Porter）", "title": "修复正则表达式编译中的无限循环风险", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "439434de4756929b6e5cf870ade0776539010ff138be17e0f14488f9eeb90d2b", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix infinite-loop risk in regular expression compilation (Tom Lane, Don Porter)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/010", "db_id": "90d04eafccdc3668e6d069ef90fb12dd", "patch_ids": [], "statement_hash": "4be6de31c0bcc9706971cddf9efb918370eb37d85b12bcbe8174feefa66f9664", "relations": [{"rule": 2, "type": "equivalent", "target": "9db4eb57afe1339f0a35af1f8da525fa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4be6de31c0bcc9706971cddf9efb918370eb37d85b12bcbe8174feefa66f9664"}}, {"rule": 2, "type": "equivalent", "target": "b199508b0ee07ea039949561e0f28c13", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4be6de31c0bcc9706971cddf9efb918370eb37d85b12bcbe8174feefa66f9664"}}], "version": "9.1.9", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "9db4eb57afe1339f0a35af1f8da525fa", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "修复正则表达式编译中的无限循环风险", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4be6de31c0bcc9706971cddf9efb918370eb37d85b12bcbe8174feefa66f9664"}, "url": "/docs/compare/?release=9.2.4#9.2.4-b8874aaf1786a740", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}, {"db_id": "b199508b0ee07ea039949561e0f28c13", "kind": "equivalent", "version": "9.0.13", "label": "9.0.13", "title": "修复正则表达式编译中的无限循环风险", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4be6de31c0bcc9706971cddf9efb918370eb37d85b12bcbe8174feefa66f9664"}, "url": "/docs/compare/?release=9.0.13#9.0.13-b8874aaf1786a740", "source_url": "/docs/release/9.0.13/#id-1.11.6.15.5"}]}, {"id": "9.1.9-d03ee7ccbc475a05", "cves": [], "html": "修复正则表达式编译中潜在的空指针解引用（Tom Lane）
", "text": "修复正则表达式编译中潜在的空指针解引用（Tom Lane）", "title": "修复正则表达式编译中潜在的空指针解引用", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "6b5d52f09000674943c6e7941ad58fa9d420f58307565107c8779d92f3eec6cb", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix potential null-pointer dereference in regular expression compilation (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/011", "db_id": "fb2e348bda5d3c970f113af362052d91", "patch_ids": [], "statement_hash": "c24026abf2ef39936ba9d585ae874ebe85536f0a4a46dd302f46b22a9a03df26", "relations": [{"rule": 2, "type": "equivalent", "target": "ba07565dec3c0925b0714b1b1cd75af3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c24026abf2ef39936ba9d585ae874ebe85536f0a4a46dd302f46b22a9a03df26"}}, {"rule": 2, "type": "equivalent", "target": "ba33e4273c0c82d2141afb2b63c70c26", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c24026abf2ef39936ba9d585ae874ebe85536f0a4a46dd302f46b22a9a03df26"}}], "version": "9.1.9", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ba33e4273c0c82d2141afb2b63c70c26", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "修复正则表达式编译中潜在的空指针解引用", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c24026abf2ef39936ba9d585ae874ebe85536f0a4a46dd302f46b22a9a03df26"}, "url": "/docs/compare/?release=9.2.4#9.2.4-d03ee7ccbc475a05", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}, {"db_id": "ba07565dec3c0925b0714b1b1cd75af3", "kind": "equivalent", "version": "9.0.13", "label": "9.0.13", "title": "修复正则表达式编译中潜在的空指针解引用", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c24026abf2ef39936ba9d585ae874ebe85536f0a4a46dd302f46b22a9a03df26"}, "url": "/docs/compare/?release=9.0.13#9.0.13-d03ee7ccbc475a05", "source_url": "/docs/release/9.0.13/#id-1.11.6.15.5"}]}, {"id": "9.1.9-1fdbe907c6fdf857", "cves": [], "html": "修复 to_char()，在适当的地方只使用 ASCII 大小写折叠规则（Tom Lane）
这修复了一些本应与区域设置无关的模板模式在土耳其区域下错误处理 “I” 和 “i” 的问题。
修复时间戳 1999-12-31 24:00:00 被不当拒绝的问题（Tom Lane）
修复单个事务先执行 UNLISTEN 再执行 LISTEN 时的逻辑错误（Tom Lane）
会话最终完全没有监听通知事件，尽管在这种情况下它显然应该监听。
", "text": "修复单个事务先执行 UNLISTEN 再执行 LISTEN 时的逻辑错误（Tom Lane） 会话最终完全没有监听通知事件，尽管在这种情况下它显然应该监听。", "title": "修复单个事务先执行 UNLISTEN 再执行 LISTEN 时的逻辑错误", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "eabd079b7555b17b534443384cc96ee600cf23ad71a210340909d89be6e716c1", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix logic error when a single transaction does UNLISTEN then LISTEN (Tom Lane) The session wound up not listening for notify events at all, though it surely should listen in this case.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/014", "db_id": "0acbaed2a468c3ce91f60474eece62b4", "patch_ids": [], "statement_hash": "7ef6fd3274e8055e4b624946fb91919e86ceb28fba79cc25518e2b4f655517ae", "relations": [{"rule": 2, "type": "equivalent", "target": "aca3f14134bf0a5829e82b94f6335c61", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7ef6fd3274e8055e4b624946fb91919e86ceb28fba79cc25518e2b4f655517ae"}}, {"rule": 2, "type": "equivalent", "target": "ed45b04c652eeea0ef90d8ef233f9839", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7ef6fd3274e8055e4b624946fb91919e86ceb28fba79cc25518e2b4f655517ae"}}], "version": "9.1.9", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed45b04c652eeea0ef90d8ef233f9839", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "修复单个事务先执行 UNLISTEN 再执行 LISTEN 时的逻辑错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7ef6fd3274e8055e4b624946fb91919e86ceb28fba79cc25518e2b4f655517ae"}, "url": "/docs/compare/?release=9.2.4#9.2.4-2abe4d8d2ab5dc97", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}, {"db_id": "aca3f14134bf0a5829e82b94f6335c61", "kind": "equivalent", "version": "9.0.13", "label": "9.0.13", "title": "修复单个事务先执行 UNLISTEN 再执行 LISTEN 时的逻辑错误", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7ef6fd3274e8055e4b624946fb91919e86ceb28fba79cc25518e2b4f655517ae"}, "url": "/docs/compare/?release=9.0.13#9.0.13-2abe4d8d2ab5dc97", "source_url": "/docs/release/9.0.13/#id-1.11.6.15.5"}]}, {"id": "9.1.9-ac3fc8e5063baa52", "cves": [], "html": "修复在向被另一视图依赖的视图添加列之后规划器可能崩溃的问题（Tom Lane）
", "text": "修复在向被另一视图依赖的视图添加列之后规划器可能崩溃的问题（Tom Lane）", "title": "修复在向被另一视图依赖的视图添加列之后规划器可能崩溃的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "78307f4650fed9573c2626940255f4dc64294bf77d7dacf3a828658f54075ab0", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible planner crash after columns have been added to a view that's depended on by another view (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/015", "db_id": "277272c41683652951fcd45d446a76c2", "patch_ids": [], "statement_hash": "c2387af31d2680aaea2a2ef863334650e0c3d99b73db981663e05c5469a1cbf8", "relations": [{"rule": 2, "type": "equivalent", "target": "5dc9828ccf0ec0c8abd069b04f4bfb6f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2387af31d2680aaea2a2ef863334650e0c3d99b73db981663e05c5469a1cbf8"}}], "version": "9.1.9", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "5dc9828ccf0ec0c8abd069b04f4bfb6f", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "修复在向被另一视图依赖的视图添加列之后规划器可能崩溃的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c2387af31d2680aaea2a2ef863334650e0c3d99b73db981663e05c5469a1cbf8"}, "url": "/docs/compare/?release=9.2.4#9.2.4-ac3fc8e5063baa52", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}]}, {"id": "9.1.9-d6b20c9d4752de07", "cves": [], "html": "移除无用的 “picksplit doesn't support secondary split” 日志消息（Josh Hansen、Tom Lane）
\n这条消息似乎是为预期中从未编写、而且可能永远不会编写的代码而添加的，因为 GiST 对二次分裂的默认处理其实相当好。所以不再为此打扰最终用户。
", "text": "移除无用的 “picksplit doesn't support secondary split” 日志消息（Josh Hansen、Tom Lane） 这条消息似乎是为预期中从未编写、而且可能永远不会编写的代码而添加的，因为 GiST 对二次分裂的默认处理其实相当好。所以不再为此打扰最终用户。", "title": "移除无用的 “picksplit doesn't support secondary split” 日志消息", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "64ee4fdc1555fd0ea147f20c82acf232019b70d999fb780b298fd877008a8152", "section_path": ["变更"], "commit_groups": [], "identity_text": "Remove useless picksplit doesn't support secondary split log messages (Josh Hansen, Tom Lane) This message seems to have been added in expectation of code that was never written, and probably never will be, since GiST's default handling of secondary splits is actually pretty good. So stop nagging end users about it.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/016", "db_id": "04854fc85e9014eec29f52a99eea3b53", "patch_ids": [], "statement_hash": "3d912528da31b4b5d83bb4836af827a3a7bf4cf9f73ce3a21dd5205c886a026b", "relations": [{"rule": 2, "type": "equivalent", "target": "65785290f1b6598886fc884e85e3258c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3d912528da31b4b5d83bb4836af827a3a7bf4cf9f73ce3a21dd5205c886a026b"}}, {"rule": 2, "type": "equivalent", "target": "7e20d1f3cfea4eb5c871291f3b0781f6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3d912528da31b4b5d83bb4836af827a3a7bf4cf9f73ce3a21dd5205c886a026b"}}], "version": "9.1.9", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "65785290f1b6598886fc884e85e3258c", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "移除无用的“picksplit doesn't support secondary split”日志消息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3d912528da31b4b5d83bb4836af827a3a7bf4cf9f73ce3a21dd5205c886a026b"}, "url": "/docs/compare/?release=9.2.4#9.2.4-5af5cc0630d14f74", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}, {"db_id": "7e20d1f3cfea4eb5c871291f3b0781f6", "kind": "equivalent", "version": "9.0.13", "label": "9.0.13", "title": "移除无用的 “picksplit doesn't support secondary split” 日志消息", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3d912528da31b4b5d83bb4836af827a3a7bf4cf9f73ce3a21dd5205c886a026b"}, "url": "/docs/compare/?release=9.0.13#9.0.13-d6b20c9d4752de07", "source_url": "/docs/release/9.0.13/#id-1.11.6.15.5"}]}, {"id": "9.1.9-8597398f5c7b9db5", "cves": [], "html": "修复会话最后几个事务的提交/中止计数可能未能发送到统计收集器的问题（Tom Lane）
", "text": "修复会话最后几个事务的提交/中止计数可能未能发送到统计收集器的问题（Tom Lane）", "title": "修复会话最后几个事务的提交/中止计数可能未能发送到统计收集器的问题", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "c82e6ffbdb4928b6a218db5bde653a372e0fb8e444a290b481f2a9f8a6194642", "section_path": ["变更"], "commit_groups": [], "identity_text": "Fix possible failure to send a session's last few transaction commit/abort counts to the statistics collector (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/017", "db_id": "20ba8f7c69d6c291cb8c53720c0fe13b", "patch_ids": [], "statement_hash": "563ace102a0a74b879485b3d93c6603a21c8c5cf8ac1565943464b333e70360f", "relations": [{"rule": 2, "type": "equivalent", "target": "4a24fbdaa92d465461f278f75a99514a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "563ace102a0a74b879485b3d93c6603a21c8c5cf8ac1565943464b333e70360f"}}, {"rule": 2, "type": "equivalent", "target": "5f6402440b99ca8a530c3f0662a136c0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "563ace102a0a74b879485b3d93c6603a21c8c5cf8ac1565943464b333e70360f"}}], "version": "9.1.9", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "5f6402440b99ca8a530c3f0662a136c0", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "修复会话最后几个事务的提交/中止计数可能未能发送到统计收集器的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "563ace102a0a74b879485b3d93c6603a21c8c5cf8ac1565943464b333e70360f"}, "url": "/docs/compare/?release=9.2.4#9.2.4-8597398f5c7b9db5", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}, {"db_id": "4a24fbdaa92d465461f278f75a99514a", "kind": "equivalent", "version": "9.0.13", "label": "9.0.13", "title": "修复会话最后几个事务的提交/中止计数可能未能发送到统计收集器的问题", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "563ace102a0a74b879485b3d93c6603a21c8c5cf8ac1565943464b333e70360f"}, "url": "/docs/compare/?release=9.0.13#9.0.13-8597398f5c7b9db5", "source_url": "/docs/release/9.0.13/#id-1.11.6.15.5"}]}, {"id": "9.1.9-bfdcb6cf8e3140be", "cves": [], "html": "消除 PL/Perl 的 spi_prepare() 函数中的内存泄漏（Alex Hunsaker、Tom Lane）
修复 pg_dumpall 对包含 “=” 的数据库名的处理（Heikki Linnakangas）
避免在给定不正确的连接串时 pg_dump 崩溃（Heikki Linnakangas）
", "text": "避免在给定不正确的连接串时 pg_dump 崩溃（Heikki Linnakangas）", "title": "避免在给定不正确的连接串时 pg_dump 崩溃", "commits": [], "section": "变更", "category": "bugfix", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "7f4ca81cf99349fd0671a71e4c7ee158a46d384fbb0fe5c763ca36d149a2ccac", "section_path": ["变更"], "commit_groups": [], "identity_text": "Avoid crash in pg_dump when an incorrect connection string is given (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/020", "db_id": "f081d09601c4ddfccf66677c89031a8c", "patch_ids": [], "statement_hash": "ba2ef975e7b9875d84b2ba2df02f27878f9e3698e86118aaca58d58afb409f65", "relations": [{"rule": 2, "type": "equivalent", "target": "92e45160130d4df03ce6c86124a63c23", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba2ef975e7b9875d84b2ba2df02f27878f9e3698e86118aaca58d58afb409f65"}}, {"rule": 2, "type": "equivalent", "target": "c56eaa560e3a0822fa13d2d8c9110156", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba2ef975e7b9875d84b2ba2df02f27878f9e3698e86118aaca58d58afb409f65"}}], "version": "9.1.9", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": [{"db_id": "92e45160130d4df03ce6c86124a63c23", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "避免在给定不正确的连接串时 pg_dump 崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba2ef975e7b9875d84b2ba2df02f27878f9e3698e86118aaca58d58afb409f65"}, "url": "/docs/compare/?release=9.2.4#9.2.4-79f8f21d55e15f9d", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}, {"db_id": "c56eaa560e3a0822fa13d2d8c9110156", "kind": "equivalent", "version": "9.0.13", "label": "9.0.13", "title": "避免在给定不正确的连接串时 pg_dump 崩溃", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ba2ef975e7b9875d84b2ba2df02f27878f9e3698e86118aaca58d58afb409f65"}, "url": "/docs/compare/?release=9.0.13#9.0.13-79f8f21d55e15f9d", "source_url": "/docs/release/9.0.13/#id-1.11.6.15.5"}]}, {"id": "9.1.9-1dc9b9a2540c1f6b", "cves": [], "html": "让 pg_dump 和 pg_upgrade 忽略无效索引（Michael Paquier、Bruce Momjian）
\n转储无效索引可能在恢复时造成问题，例如当索引创建失败的原因是它试图强制执行表数据不满足的唯一性条件时。此外，如果索引创建实际上仍在进行中，把它视为未提交的 DDL 变更似乎是合理的，pg_dump 本来也不应转储它。pg_upgrade 现在也跳过无效索引而不是失败。
", "text": "让 pg_dump 和 pg_upgrade 忽略无效索引（Michael Paquier、Bruce Momjian） 转储无效索引可能在恢复时造成问题，例如当索引创建失败的原因是它试图强制执行表数据不满足的唯一性条件时。此外，如果索引创建实际上仍在进行中，把它视为未提交的 DDL 变更似乎是合理的，pg_dump 本来也不应转储它。pg_upgrade 现在也跳过无效索引而不是失败。", "title": "让 pg_dump 和 pg_upgrade 忽略无效索引", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "29594f57ce848c20f7e8e4098d770aeaf2bcaa8d5ead9347ce3be8409c6f1fa9", "section_path": ["变更"], "commit_groups": [], "identity_text": "Ignore invalid indexes in pg_dump and pg_upgrade (Michael Paquier, Bruce Momjian) Dumping invalid indexes can cause problems at restore time, for example if the reason the index creation failed was because it tried to enforce a uniqueness condition not satisfied by the table's data. Also, if the index creation is in fact still in progress, it seems reasonable to consider it to be an uncommitted DDL change, which pg_dump wouldn't be expected to dump anyway. pg_upgrade now also skips invalid indexes rather than failing.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/021", "db_id": "7ddb477eeb86351ac7b353b58dd09ac8", "patch_ids": [], "statement_hash": "01a158cfc3e6c0f8bf857b14f498fc9174a5495611eccc74d31530547dc6322a", "relations": [{"rule": 2, "type": "equivalent", "target": "06b4e4c8173effe51d1574d157a3e779", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "01a158cfc3e6c0f8bf857b14f498fc9174a5495611eccc74d31530547dc6322a"}}, {"rule": 2, "type": "equivalent", "target": "2e6d29400a9d10c40a59d76a217ac60b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "01a158cfc3e6c0f8bf857b14f498fc9174a5495611eccc74d31530547dc6322a"}}], "version": "9.1.9", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "2e6d29400a9d10c40a59d76a217ac60b", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "让 pg_dump 和 pg_upgrade 忽略无效索引", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "01a158cfc3e6c0f8bf857b14f498fc9174a5495611eccc74d31530547dc6322a"}, "url": "/docs/compare/?release=9.2.4#9.2.4-1dc9b9a2540c1f6b", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}, {"db_id": "06b4e4c8173effe51d1574d157a3e779", "kind": "equivalent", "version": "9.0.13", "label": "9.0.13", "title": "让 pg_dump 和 pg_upgrade 忽略无效索引", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "01a158cfc3e6c0f8bf857b14f498fc9174a5495611eccc74d31530547dc6322a"}, "url": "/docs/compare/?release=9.0.13#9.0.13-1dc9b9a2540c1f6b", "source_url": "/docs/release/9.0.13/#id-1.11.6.15.5"}]}, {"id": "9.1.9-18de6203df9f8304", "cves": [], "html": "在 pg_basebackup 中，备份表空间时只包含当前服务器版本的子目录（Heikki Linnakangas）
", "text": "在 pg_basebackup 中，备份表空间时只包含当前服务器版本的子目录（Heikki Linnakangas）", "title": "在 pg_basebackup 中，备份表空间时只包含当前服务器版本的子目录", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "00f9fb8e2c8dc7644414f5525be4ad5904fb55b535b7d030b01ba75259380fa3", "section_path": ["变更"], "commit_groups": [], "identity_text": "In pg_basebackup, include only the current server version's subdirectory when backing up a tablespace (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/022", "db_id": "d171a7f40b5c76b41bd3d599fb9865aa", "patch_ids": [], "statement_hash": "a20fb7a41e6fccb91f94d08d0e8ac956dce879bf631383871eca8c9a9e2c4372", "relations": [{"rule": 2, "type": "equivalent", "target": "c796e943bdbcc1224a288aebc4027084", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a20fb7a41e6fccb91f94d08d0e8ac956dce879bf631383871eca8c9a9e2c4372"}}], "version": "9.1.9", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "c796e943bdbcc1224a288aebc4027084", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "在 pg_basebackup 中，备份表空间时只包含当前服务器版本的子目录", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a20fb7a41e6fccb91f94d08d0e8ac956dce879bf631383871eca8c9a9e2c4372"}, "url": "/docs/compare/?release=9.2.4#9.2.4-18de6203df9f8304", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}]}, {"id": "9.1.9-870e35ab374bebd8", "cves": [], "html": "在 pg_basebackup 和 pg_receivexlog 中加入服务器版本检查，使其在版本组合无法工作时干净地失败（Heikki Linnakangas）
", "text": "在 pg_basebackup 和 pg_receivexlog 中加入服务器版本检查，使其在版本组合无法工作时干净地失败（Heikki Linnakangas）", "title": "在 pg_basebackup 和 pg_receivexlog 中加入服务器版本检查，使其在版本组合无法工作时干净地失败", "commits": [], "section": "变更", "category": "improvement", "source_url": "/docs/release/9.1.9/#id-1.11.6.20.5", "source_hash": "027a6af1c8f2a4f58ffc31e0a384cf3f1dfd7a6b30759eb22a6e9644f853ec0c", "section_path": ["变更"], "commit_groups": [], "identity_text": "Add a server version check in pg_basebackup and pg_receivexlog, so they fail cleanly with version combinations that won't work (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.9/changes/023", "db_id": "fe96303f03f98581111e085c0f5d4112", "patch_ids": [], "statement_hash": "d28a3c9bb593a8c49d4bc6c441284b9681b89660a49348400ee54e93a855ac02", "relations": [{"rule": 2, "type": "equivalent", "target": "35359d317530506a343b3e207d01313e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d28a3c9bb593a8c49d4bc6c441284b9681b89660a49348400ee54e93a855ac02"}}], "version": "9.1.9", "category_label": "其他改进", "also_in": [], "variants": [], "related_changes": [{"db_id": "35359d317530506a343b3e207d01313e", "kind": "equivalent", "version": "9.2.4", "label": "9.2.4", "title": "在 pg_basebackup 和 pg_receivexlog 中加入服务器版本检查，使其在版本组合无法工作时干净地失败", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d28a3c9bb593a8c49d4bc6c441284b9681b89660a49348400ee54e93a855ac02"}, "url": "/docs/compare/?release=9.2.4#9.2.4-870e35ab374bebd8", "source_url": "/docs/release/9.2.4/#id-1.11.6.25.5"}]}, {"id": "9.1.9-552a19bba85395ff", "cves": [], "html": "修复 contrib/pg_trgm 的 similarity() 函数，使其对无三元组的字符串返回零（Tom Lane）
此前它由于内部除以零而返回 NaN。
把时区数据文件更新为 tzdata 版本 2013b for DST law changes in Chile, Haiti, Morocco, Paraguay, and some Russian areas。Also, historical zone data corrections for numerous places.
\n此外，更新时区缩写文件以反映俄罗斯和其他地方的近期变更：CHOT、GET、IRKT、KGT、KRAT、MAGT、MAWT、MSK、NOVT、OMST、TKT、VLAT、WST、YAKT、YEKT 现在遵循其当前含义，同时把 VOLT（Europe/Volgograd）和 MIST（Antarctica/Macquarie）加入默认缩写列表。