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，更多改進內容請看更新日志。