PostgreSQL 8.3.3 和8.2.9 发布

   PostgreSQL全球开发组发布了修补版本8.3.3 和 8.2.9。并提醒所有的用户及时更新。

   The PostgreSQL Global Development Group has released minor versions 8.3.3 and 8.2.9. All users should upgrade to receive the latest fixes.



   Updates for all maintained versions of PostgreSQL are available today: 8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. These releases fix more than two dozen minor issues reported and patched over the last few months. All PostgreSQL users should plan to update at their earliest convenience. Users of UTF-8 databases on Windows and people in affected time zones, in particular, should upgrade as soon as possible.

   The issues fixed include a crash caused by encoding mismatch on Windows, possible crash when decompressing corrupted data, non-optimization of some parameterized queries, new time zone updates, SIGTERM-caused memory corruption, runaway LWLocks with GIN indexes, and several more. Read the release notes to see if any of the issues affect you.

    As with other minor releases, users are not required to dump and reload their database in order to apply this update release; you may simply upgrade the PostgreSQL binaries. Users skipping more than one update may need to check the release notes for extra, post-update steps. As previously announced, only versions 8.2.9 and 8.3.3 of the Windows binaries are being released, as we no longer support 8.0 and 8.1 on Windows.


恭贺PostgreSQL 8.0发布


PostgreSQL 8.0 正式发布了rnrn欢迎到下面地址下载 rn;O=Arnrn============== =========rnrnrnWhat's New in 8.0rnWin32 Native ServerrnrnThis is the first PostgreSQL release to natively run on Microsoft Windows as a server. It can run as a Windows service. This release supports NT-based Windows releases like Win2000, XP, Win2003. Older releases like Windows 95, 98, and ME are not supported because these operating systems do not have the infrastructure to support PostgreSQL. A separate installer project has been created to ease installation on Windows: tested throughout our release cycle, the Windows port does not have the benefit of years of use in production environments that PostgreSQL has on Unix platforms and therefore should be treated with the same level of caution as you would a new product.rnrnPrevious releases required the Unix emulation toolkit Cygwin for Win32 server support. PostgreSQL has always supported clients on Win32.rnSavepointsrnrnSavepoints allow specific parts of a transaction to be aborted without affecting the remainder of the transaction. Prior releases had no such capability; there was no way to recover from a statement failure within a transaction except by aborting the whole transaction. This feature is valuable for application writers who require error recovery within a complex transaction.rnPoint-In-Time RecoveryrnrnThough PostgreSQL is very reliable, in previous releases there was no way to recover from disk drive failure except to restore from a previous backup or use a standby replication server. Point-in-time recovery allows continuous backup of the server. You can recover either to the point of failure or to some transaction in the past.rnTablespacesrnrnTablespaces allow administrators to select the file systems used for storage of tables, indexes, and entire databases. This improves performance and control over disk space usage. Prior releases used initlocation and manual symlink management for such tasks.rnImproved Buffer Management, CHECKPOINT, VACUUMrnrnThis release has a more intelligent buffer replacement strategy, which will make better use of available shared buffers and improve performance. The performance impact of vacuum and checkpoints is also lessened.rnChange Column TypesrnrnA column's data type can now be changed with ALTER TABLE.rnNew Perl Server-Side LanguagernrnA new version of the plperl server-side language now supports a persistent shared storage area, triggers, returning records and arrays of records, and SPI calls to access the database.rnComma-separated-value (CSV) support in COPYrnrnCOPY can now read and write comma-separated-value files. It has the flexibility to interpret non-standard quoting and separation characters too.rn