PostgreSQL 开发组发布了一个关键的更新版本,涉及 PG 的所有版本分支,包括:9.3.2, 9.2.6, 9.1.11, 9.0.15, 和 8.4.19. 此次更新修复了三个严重的数据丢失问题,该问题影响复制和数据库维护,强烈要求用户立即升级。
复制问题影响了使用 PostgreSQL 二进制复制的用户,会导致 master 和 standby 节点间的传输数据丢失。但并非所有用户都受影响,目前很难确定该问题什么时候会出现。
此外还包含一些只影响到 PG 9.3 的问题:
Prevent "lock already held" error.
Resolve race conditions in timeout management, which could cause server lockup.
Fix minor bugs with HOT updates and the Visibility Map.
Prevent pg_multixact storage growth on standbys.
Fix bug in GIN indexes which caused transient query failures.
Remove issue which caused SP-GiST index creation to hang
Fix assorted bugs in Materialized Views.
Restore ability to use duplicate table aliases in complex queries.
Fix two bugs in subquery optimization.
Allow pg_receivexlog to resume streaming when more than 4GB of logs are generated.
Prevent planner crash on whole-row references.
Prevent premature deletion of temporary files.
Patch multiple minor memory leaks.
Suppress display of dropped columns for CHECK and NOT NULL constraint violations.
Allow default and named arguments for window functions.
Return a valid JSON value when converting an empty HStore string.
Fix GMT timezone offset.
Report out-of-disk-space error correctly during pg_upgrade.
Time zone updates for several time zones.
项目主页:http://www.postgresql.org/docs/current/static/release.html
下载地址:http://postgresql.org/download
来自:开源中国社区

