Documentation Database Servers Beat

From FedoraProject

(Difference between revisions)
Jump to: navigation, search
(PostgreSQL: expand on usage of custom service files)
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
{{header|docs}}
 
{{header|docs}}
{{Docs_beat_open}}
+
{{Docs_beat_closed}}
 
+
=== systemd ===
+
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 ===
+
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>
+
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.  (Remember that custom service files should go into <code>/etc/systemd/system/</code> not <code>/lib/systemd/system/</code>.)  Notice that PGDATA and PGPORT settings for alternate servers must now be specified in the custom service files; there is no longer any use of files in <code>/etc/sysconfig/pgsql/</code>.
+
 
+
You can use postgresql-setup for an alternate server by adding the name of the new service file to the command, for instance
+
 
+
<code>
+
sudo postgresql-setup initdb myservice
+
</code>
+
 
+
postgresql-setup will then extract the PGDATA setting from that service file instead of <code>postgresql.service</code>.
+
  
 
[[Category:Docs Project]]
 
[[Category:Docs Project]]
 
[[Category:Draft documentation]]
 
[[Category:Draft documentation]]
 
[[Category:Documentation beats]]
 
[[Category:Documentation beats]]

Revision as of 04:56, 8 May 2013

DocsProject Header docTeam1.png
Warning (medium size).png
Beat Closed on Wiki
Work on beats has now moved to git. If you have changes or additions, please contact the docs team via #fedora-docs, docs@lists.fp.o, or with the fedora-release-notes BZ component.