2013-10-10 14:18:50+08 发布 ... 翻译:doudou586

PostgreSQL全球开发组宣布对所有当前可支持的版本发布补丁修正版,包括9.3.1版、9.2.5版、 9.1.10版、 9.0.14版和8.4.18版。 这些新发布的版本修正了近六个月来很多通过社区汇报上来的小问题。所有用户可考虑在所用数据库进行正常周期性维护时进行升级。
    对最新发布的9.3版本的修正包括:
  • 更新 hstore 扩展模块,增加了JSON功能;
  • Prevent memory leak when creating range indexes
  • Fix libpq SSL deadlock bug
    In addition to the above, there are a few dozen minor bug fixes for older versions. These patches were already included in 9.3.0 when released. Among them are:
  • Guarantee transmission of all WAL files before replica failover
  • Prevent downcasing of non-ASCII identifiers
  • Fix several minor memory leaks
  • Correct overcommit behavior when using more than 24GB of work memory
  • Improve planner cost estimates for choosing generic plans
  • Fix estimates of NULL rows in boolean columns
  • Make UNION ALL and inheritance query plans recheck parameterized paths
  • Correct pg_dump bugs for foreign tables, views, and extensions
  • Prevent a parallel pg_restore failure on certain indexes
  • Make REINDEX revalidate constraints
  • Prevent two deadlock issues in SP-GIST and REINDEX CONCURRENTLY
  • Prevent GiST index lookup crash
  • Fix several regular expression failures
  • Allow ALTER DEFAULT PRIVILEGES to work on all schemas
  • Loosen restrictions on keywords
  • Allow various spellings of infinity
  • Expand ability to compare rows to records and arrays
  • Prevent psql client crash on bad PSQLRC file
  • Add spinlock support for ARM64
Note that users of the hstore extension on version 9.3 must take an additional, post upgrade step of running "ALTER EXTENSION hstore UPDATE" in each database after update.
As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional, post-update steps; see the Release Notes for details.
© 2010 PostgreSQL中文社区