Documentation Database Servers Beat

From FedoraProject

(Difference between revisions)
Jump to: navigation, search
(postgresql: adjust Postgres update notes)
m (Fixed some typos)
Line 5: Line 5:
 
{{admon/tip|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.}}
 
{{admon/tip|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 ===
  
 
MySQL has been updated to 5.1.x.  This represents a major version upgrade from Fedora 10's 5.0.x release series.
 
MySQL has been updated to 5.1.x.  This represents a major version upgrade from Fedora 10's 5.0.x release series.
Line 13: Line 13:
 
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 [https://bugzilla.redhat.com/show_bug.cgi?id=493160 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.)
 
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 [https://bugzilla.redhat.com/show_bug.cgi?id=493160 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 ===
+
=== PostgreSQL ===
  
 
Fedora 11 includes version 8.3.7 of  PostgreSQL.  This is the same version currently shipped in Fedora 10 and Fedora 9;
 
Fedora 11 includes version 8.3.7 of  PostgreSQL.  This is the same version currently shipped in Fedora 10 and Fedora 9;

Revision as of 13:49, 14 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].