From Fedora Project Wiki

No edit summary
(23 intermediate revisions by 8 users not shown)
Line 1: Line 1:
{{header|docs}}
{{header|docs}}{{Docs_beat_open}}
{{Docs_beat_open}}
[[Category:Docs Project]]
 
[[Category:Draft documentation]]
=== systemd ===
[[Category:Documentation beats]]
MySQL and PostgreSQL have been updated to use native systemd unit files for startup, in place of the SysV-style init scripts.  This should eliminate various unfortunate problems that occurred in Fedora 15 due to systemd's rather poor handling of SysV scripts.  Also, handling of cases where the database server is slow to start up is significantly better than it ever was in the SysV scripts, since in systemd there is no reason not to wait until the server is really ready.
 
=== PostgreSQL ===
In the case of PostgreSQL, the "service postgresql initdb" and "service postgresql upgrade" actions that were supported by the SysV init script cannot be provided by the systemd unit file.  There is a new standalone script postgresql-setup that provides these functions.  For example, to initialize a new postgresql database, do something like


<code>
== PostgreSQL 9.4.1 ==
sudo postgresql-setup initdb
</code>


If you need to run more than one postgresql server on the same machine, you can duplicate and modify the <code>postgresql.service</code> file, as is customary with systemd services. Add the name of the new service file when you call postgresql-setup to have it extract the PGDATA setting from that service file instead of <code>postgresql.service</code>.
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.


[[Category:Docs Project]]
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.
[[Category:Draft documentation]]
[[Category:Documentation beats]]

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.