PostgreSQL is een open source relational database management system dat op diverse besturingssystemen kan worden gedraaid. De ontwikkelaars hebben enkele dagen geleden de eerste release candidate van PostgreSQL 9.0 uitgebracht en enkele dagen later ook de eerste alphaversie van PostgreSQL 9.1. De 9.0 tak is voorzien van 64bit-ondersteuning voor het Windows-platform, Python 3-support in PL/Python en conditional per-column triggers. De bijbehorende aankondigingen zien er als volgt uit:
PostgreSQL 9.0 Release Candidate 1
The first release candidate for PostgreSQL 9.0 is now available. Please download and test immediately so that we can move rapidly towards final release. All known bugs should be fixed, so users should promptly report any bugs which they find.
Note that, due to a system catalog change, an initdb and database reload will be required for upgrading from 9.0 beta versions. We encourage users to use this opportunity to test pg_upgrade. Please report your results.
If you are able to help with testing, please see the testing page: http://wiki.postgresql.org/wiki/HowToBetaTest
No changes in commands, interfaces or APIs are expected between this release candidate and the final version. Applications which will deploy on 9.0 can and should test against 9.0rc1. Depending on bug reports, there may or may not be more release candidates before the final release.
Source code, as well as binary installers for many platforms, is available from the PostgreSQL Web Site:
- One-Click Installer, including Win64 binaries
- Binaries for other platforms
- Release Notes
- Participating in Testing
PostgreSQL 9.1alpha1 Now Available
The first alpha release for PostgreSQL version 9.1, 9.1alpha1, is now available. This alpha release contains several new major features added since the 9.0 branch. Please download, install, and test it to give us early feedback on the features being developed for the future versions of PostgreSQL.
Note that the final release of PostgreSQL 9.1 is not to be expected before mid-2011. Please also direct your attention to the imminent release of PostgreSQL 9.0, which is currently in the release candidate stage.
Features added in 9.1alpha1 include:
More detail is available in the release notes.
- Recognize functional dependency on primary keys, to allow omitting non-primary key columns from the GROUP BY clause in certain situations.
- Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions.
- Change the default value of standard_conforming_strings to on. This is a significant incompatibility with previous releases, because it may break unwary applications in security-critical ways.
- Add vacuum and analyze counters to pg_stat_*_tables views.
- Several new XML-related functions: xmlexists, xpath_exists, xml_is_well_formed
- More compact representation of the numeric type.
- Extend psql's \e and \ef commands so that a line number can be specified, and the editor's cursor will be initially placed on that line.
These new features mean that we need you to participate in testing them. If you are able to help with organized alpha testing, please see the Alpha/Beta testing page.
Alpha releases are not stable and should never be used in production; they are for testing new features only. There is no guarantee that any features or APIs present in the alphas will be present, or the same, in the final release.
Alpha release information page. Download the alpha release here.
Alpha releases are primarily made in source code form only. Binary packages for some operating systems will be prepared in the coming days. PostgreSQL Early Experience One-Click Installers are available here.