Documentation Database Servers Beat

From FedoraProject

(Difference between revisions)
Jump to: navigation, search
(mysql: add some cautions about upgrading to mysql 5.1)
(postgresql: adjust Postgres update notes)
Line 15: Line 15:
 
=== postgresql ===
 
=== postgresql ===
  
Fedora 11 includes version 8.3.6 of  postgreSQL.
+
Fedora 11 includes version 8.3.7 of  PostgreSQL. This is the same version currently shipped in Fedora 10 and Fedora 9;
 
+
you should not notice any significant difference if you are upgrading from an up-to-date F-10 or F-9 installation.
A dump/restore is not required for those running 8.3.X. However, it is recommended to REINDEX all GiST indexes after the upgrade.
+
Otherwise, please see upstream's release notes at [http://www.postgresql.org/docs/8.3/static/release.html].
 
+
 
+
  
 
  <noinclude>
 
  <noinclude>

Revision as of 02:58, 6 April 2009

Database Servers

Fedora includes both the MySQL and PostgreSQL database servers.

Idea.png
Maybe you know what should be on this page?
The Fedora release notes are a collective effort of dozens of people. You can contribute by editing the wiki page that corresponds to this part of the release notes.

mysql

MySQL has been updated to 5.1.x. This represents a major version upgrade from Fedora 10's 5.0.x release series. You should test database-using applications for possible incompatibilities. Upstream's release notes can be found at [1].

If you are upgrading a Fedora 10 installation that includes a live 5.0.x MySQL database, don't forget to run mysql_upgrade after completing the software upgrade. There is a report that this may fail altogether if the 5.0.x database had been updated from an even older installation without running mysql_upgrade at the time. If you think this might be the case for your database, it is prudent to run mysql_upgrade on the Fedora 10 installation before upgrading. (And, of course, you should have backups if the database content is at all critical.)

postgresql

Fedora 11 includes version 8.3.7 of PostgreSQL. This is the same version currently shipped in Fedora 10 and Fedora 9; you should not notice any significant difference if you are upgrading from an up-to-date F-10 or F-9 installation. Otherwise, please see upstream's release notes at [2].