PostgreSQL 9.3 發布!
我們非常高興的宣布 PostgreSQL 9.3 正式版發布了，該版本包含可寫的外部數據封裝、數據頁 checksums、快速的故障轉移以及 streaming-only remastering 等等。
外部數據封裝可寫使得系統間支持雙路數據交換。今天非常復雜的 IT 環境涉及到多個數據庫和半結構化的數據源，而 PG 可幫你將它們集成在一起。該項目同時發布了 postgres_fdw ，這是一個高性能的支持讀寫的聯合驅動程序。
此外，該版本提升了可靠性和可用性，實現了快速的故障轉移；數據頁的 checksum。此外在復雜的復制環境中，可在故障發生時迅速轉移主數據節點。
在針對開發者方面改進包括：
- 額外的 JSON 構建和解析方法
- 自動可更新的視圖
- 并行 pg_dump 用于加速大數據庫的備份
- LATERAL JOINs </ul>
- Data Page Checksums: help administrators quickly detect failing disks and bad hardware that corrupts data
- Fast Failover: enables sub-second switchoffs from master to replica, supporting "carrier-grade" availability
- Streaming-Only Remastering: easier, faster reconfiguration of cascading replicas after failover </ul>
- Additional JSON constructor and extractor methods
- Automatically updatable VIEWs
- Parallel pg_dump to speed backups of large databases
- LATERAL JOINs </ul>
- Downloads
- Press Kit
- Release Notes
- What's New in 9.3 </ul> 來自：http://www.oschina.net/news/44036/postgresql-9-3-final
原文如下：
The PostgreSQL Global Development Group announces the release of PostgreSQL 9.3, the latest version of the world's leading open source relational database system. This release expands PostgreSQL's reliability, availability, and ability to integrate with other databases. Users are already finding that they can build applications using version 9.3 which would not have been possible before.
"PostgreSQL 9.3 provides features that as an app developer I can use immediately: better JSON functionality, regular expression indexing, and easily federating databases with the Postgres foreign data wrapper. I have no idea how I completed projects without 9.3," said Jonathan S. Katz, CTO of VenueBook.
Writable External Data
Version 9.3 makes PostgreSQL's Foreign Data Wrappers writable, enabling two-way data interchange between systems. Today's complex IT environments involve multiple databases and semi-structured data sources, and PostgreSQL helps you integrate them into a coherent stack. The project has also released postgres_fdw, a higher-performance, read/write PostgreSQL-to-PostgreSQL federation driver.
"Writable foreign data wrappers enable us to plug in and seamlessly test various backend alternatives, allowing us to address different needs quickly and prototype intelligently," explained Lee Holloway, Co-founder and Lead Engineer at CloudFlare. "It is exciting to conceive and toss up new data stores (including our in-house experimental ones written in Go) and then watch them read, write, and even transact each other."
Enhanced Reliability and Availability
"Postgres has been my favorite choice for its well known stability, robustness, strong coherency, safety, ACID, and SQL conformance," said Pascal Bouchareine, director of research and development at Gandi.net. "I'm especially excited to hear more about the fast failover coming in 9.3."
This new release includes features to further improve and extend PostgreSQL's well-known reliability and availability:
Developer-friendly Features
As with every annual release, PostgreSQL 9.3 includes many features to make working with PostgreSQL easier, more flexible and more fun for application developers, administrators and architects. These features include:
Further, PostgreSQL 9.3's User-Defined Background Workers allow developers to write task managers, request handlers, parallel processors, queuing tools and other helper applications to enable PostgreSQL as a workload coordinator. One example of this already released is Mongres, a background worker which accepts MongoDB queries, interprets them and passes them on to PostgreSQL.