From Fedora Project Wiki

(→‎mysql: add some cautions about upgrading to mysql 5.1)
(48 intermediate revisions by 12 users not shown)
Line 1: Line 1:
== Database Servers ==
{{header|docs}}{{Docs_beat_open}}
[[Category:Docs Project]]
[[Category:Draft documentation]]
[[Category:Documentation beats]]


Fedora includes both the MySQL and PostgreSQL database servers.
== PostgreSQL 9.4.1 ==


{{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.}}
In Fedora 22, the '''postgresql''' packages have been updated to the upstream version 9.4.1, which provides various bug fixes and enhancements described on upstream [http://www.postgresql.org/docs/9.4/static/release-9-4.html 9.4.0 release notes] and [http://www.postgresql.org/docs/9.4/static/release-9-4-1.html 9.4.1 release notes] pages.


=== mysql ===
Migration to new PostgreSQL version may be done by running of the post-upgrade script <code>postgresql-setup</code> (meaning that you may firstly update your Fedora installation from version 21 to 22 and then perform database stack update).  Users are encouraged to do full database dump (for backup purposes) before Fedora upgrade to 22.  For more info about migration look into the <code>README.rpm-dist</code> file distributed in <code>postgresql</code> package.
 
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
[http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html].
 
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 ===
 
Fedora 11 includes version 8.3.6 of postgreSQL.
 
A dump/restore is not required for those running 8.3.X. However, it is recommended to REINDEX all GiST indexes after the upgrade.
 
 
 
<noinclude>
[[Category:Docs_Project]]
[[Category:Documentation_Beats]]
[[Category:Release Notes]]
<noinclude>

Revision as of 12:04, 17 February 2015

DocsProject Header docTeam1.png
Note.png
Beat is open
This beat is now ready to have Fedora 25 content added by the beat writer

PostgreSQL 9.4.1

In Fedora 22, the postgresql packages have been updated to the upstream version 9.4.1, which provides various bug fixes and enhancements described on upstream 9.4.0 release notes and 9.4.1 release notes pages.

Migration to new PostgreSQL version may be done by running of the post-upgrade script postgresql-setup (meaning that you may firstly update your Fedora installation from version 21 to 22 and then perform database stack update). Users are encouraged to do full database dump (for backup purposes) before Fedora upgrade to 22. For more info about migration look into the README.rpm-dist file distributed in postgresql package.

Retrieved from "https://fedoraproject.org/w/index.php?title=Documentation_Database_Servers_Beat&oldid=404135"