PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16 和 9.0.20 发布

PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16 和 9.0.20 发布，这些版本现已提供下载。此版本修复了 PostgreSQL 9.3 和 9.4 版本中的数据崩溃问题，强烈建议用户尽快升级到最新版本！

安全修复

• CVE-2015-3165 Double "free" after authentication timeout.

• CVE-2015-3166 Unanticipated errors from the standard library.

• CVE-2015-3167 pgcrypto has multiple error messages for decryption with an incorrect key.

此外，我们建议所有用户使用 Kerberos、 GSSAPI 或 SSPI 身份验证设置 pg_hba.conf 中的 include_realm 为 1，未来版本中都将默认这个设置。

新版本中相比老版本中有个不同的返回类型，所以在升级之前 CIText 用户需要先运行"ALTER EXTENSION citext UPDATE"功能测试应用程序。

其他修复和改进

除了以上的改进，还包括超过 50 个 bug 修复：

• Render infinite dates and timestamps as infinity when converting to json

• Fix json/jsonb's populate_record() and to_record()

• Fix incorrect checking of deferred exclusion constraints

• Improve planning of star-schema-style queries

• Fix three issues with planning joins

• Ensure correct locking with security barrier views

• Fix deadlock at startup when max_prepared_transactions is too small

• Recursively fsync() the data directory after a crash

• Fix autovacuum launcher's possible failure to shut down

• Cope with unexpected signals in LockBufferForCleanup()

• Fix crash when doing COPY IN to a table with check constraints

• Avoid waiting for synchronous replication of read-only transactions

• Fix two issues with hash indexes

• Prevent memory leaks in GIN index vacuum

• Fix two issues with background workers

• Several fixes to Logical Decoding replication

• Fix several minor issues with pg_dump and pg_upgrade

此版本还包括将 tzdata 升级至 2015d，同时还更新了 Egypt、Mongolia 和 Palestine，更多改进内容请看更新日志。