Log message:
This release fixes a significant page ordering issue with Hot Standby which \
could cause index corruption on the standby under some circumstances. In \
addition, this update patches timing issues with checkpoint and transaction ID \
wraparound which could cause data corruption in some cases. Today's update also \
fixes multiple issues with CREATE INDEX CONCURRENTLY and DROP INDEX \
CONCURRENTLY, which can cause those commands to fail or produce corrupt indexes. \
Users who use this feature may want to REINDEX or recreate affected indexes (see \
below).
This update release also contains fixes for many minor issues discovered and \
patched by the PostgreSQL community in the last month, including several fixes \
which are specific to version 9.2. These include:
* Prevent psql crash due to incorrectly encoded input data
* Fix pg_regress gmake build issues
* Make sure correct directory is created for extensions
* Fix some issues with buffer locks and VACUUM
* Multiple fixes and improvements for pg_upgrade
* Fix bugs with end-of-recovery when failing over to a standby
* Avoid bogus "out-of-sequence timeline ID" errors in standby-mode
* Don't launch new child processes during shutdown
* Improve the ability of JOINs to use partial indexes
* Fix assorted integer overflow errors
* Eliminate memory leaks in record_out() and record_send()
* Skip searching for subtransaction logs at COMMIT
* Fix WaitLatch() timing issues
* Fix handling of inherited check constraints in ALTER COLUMN TYPE
* Make ALTER EXTENSION SET SCHEMA behave as documented
* Have SEQUENCE SET statements in the "data" section of sectional dumps
* Prevent parser from believing that VIEWs have system columns
* Fix --clean mode for pg_dump
* Prevent hash table corruption on out-of-memory
* Various query planner and executor fixes and improvements
* Multiple documentation updates
* DST updates for seven timezones
|
Log message:
The PostgreSQL Global Development Group announces PostgreSQL 9.2, the latest \
release of the leader in open source databases. Since the beta release was \
announced in May, developers and vendors have praised it as a leap forward in \
performance, scalability and flexibility. Users are expected to switch to this \
version in record numbers.
PostgreSQL 9.2 will ship with native JSON support, covering indexes, replication \
and performance improvements, and many more features. We are eagerly awaiting \
this release and will make it available in Early Access as soon as itâs \
released by the PostgreSQL community," said Ines Sombra, Lead Data \
Engineer, Engine Yard.
|