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.
完整的列表和说明请看: Links: * Download * Release Notes |