(→mysql: mention soname bump for libmysqlclient) |
(→postgresql: Replace warning about needing dump/restore with info about how to avoid it) |
||
| Line 20: | Line 20: | ||
== postgresql == | == postgresql == | ||
{{package|postgresql}} has been updated from 8.4. | {{package|postgresql}} has been updated from 8.4.7 to 9.0.3. In addition to numerous security and other bugfixes, this release contains a number of new features: | ||
* Built-in replication based on log shipping | * Built-in replication, based on log shipping, supports multiple read-only slave servers | ||
* Easier database object permissions management | * Easier database object permissions management | ||
* Broadly enhanced stored procedure support | * Broadly enhanced stored procedure support | ||
| Line 32: | Line 32: | ||
* New high-performance implementation of the LISTEN/NOTIFY feature | * New high-performance implementation of the LISTEN/NOTIFY feature | ||
* New implementation of VACUUM FULL | * New implementation of VACUUM FULL | ||
* Multiple performance enhancements for specific types of queries, including elimination of unnecessary joins | * Multiple performance enhancements for specific types of queries, including elimination of unnecessary joins | ||
* EXPLAIN enhancements | * EXPLAIN enhancements | ||
* hstore improvements | * hstore improvements | ||
In addition, there is a new contrib module pg_upgrade to support in-place upgrades from 8.4 to 9.0. This means that you can upgrade from a Fedora 12 or later database without a database dump and restore. To do that, install the postgresql-upgrade package and run '''service postgresql upgrade''' as root. It's advisable to have a separate backup in case of trouble, but the actual database conversion requires only a few minutes with this approach. | |||
{{admon/warning|Incompatible Changes| | {{admon/warning|Incompatible Changes| | ||
Revision as of 15:58, 24 March 2011
riak
Riak, a scalable and reliable data store, is available in Fedora 15.
Riak is a Dynamo-inspired key/value store, written in Erlang, that scales predictably and easily. Riak also simplifies development by giving developers the ability to quickly prototype, test, and deploy their applications.
A truly fault-tolerant system, Riak has no single point of failure. No machines are special or central in Riak, so developers and operations professionals can decide exactly how fault-tolerant they want and need their applications to be.
mysql
mysql
This update includes increasing the shared library version number of libmysqlclient, so applications using that library will need to be recompiled.
postgresql
- Built-in replication, based on log shipping, supports multiple read-only slave servers
- Easier database object permissions management
- Broadly enhanced stored procedure support
- More advanced reporting queries
- New trigger features
- Deferrable unique constraints
- Mass updates to unique keys are now possible without trickery
- Exclusion constraints
- New and enhanced security features
- New high-performance implementation of the LISTEN/NOTIFY feature
- New implementation of VACUUM FULL
- Multiple performance enhancements for specific types of queries, including elimination of unnecessary joins
- EXPLAIN enhancements
- hstore improvements
In addition, there is a new contrib module pg_upgrade to support in-place upgrades from 8.4 to 9.0. This means that you can upgrade from a Fedora 12 or later database without a database dump and restore. To do that, install the postgresql-upgrade package and run service postgresql upgrade as root. It's advisable to have a separate backup in case of trouble, but the actual database conversion requires only a few minutes with this approach.
Version 9.0 contains a number of changes that selectively break backwards compatibility in order to support new features and code quality improvements. Refer to the release notes at http://www.postgresql.org/docs/current/static/release-9-0.html