Changeset 65df9fca for content/databases
- Timestamp:
- 06/03/2004 02:41:04 AM (20 years ago)
- Branches:
- 10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, 6.0, 6.1, 6.2, 6.2.0, 6.2.0-rc1, 6.2.0-rc2, 6.3, 6.3-rc1, 6.3-rc2, 6.3-rc3, 7.10, 7.4, 7.5, 7.6, 7.6-blfs, 7.6-systemd, 7.7, 7.8, 7.9, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, gnome, kde5-13430, kde5-14269, kde5-14686, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, krejzi/svn, lazarus, lxqt, nosym, perl-modules, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, systemd-11177, systemd-13485, trunk, upgradedb, v5_1, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
- Children:
- 2cbfd78a
- Parents:
- 23d784b
- Location:
- content/databases
- Files:
-
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
content/databases/db-3.3/db-3.3-intro.xml
r23d784b r65df9fca 18 18 </sect3> 19 19 20 <sect3><title>Additional downloads</title> 21 <itemizedlist spacing='compact'> 22 <listitem><para>Recommended Patch: <ulink 23 url="http://www.sleepycat.com/webforms/patchdl.php?src=patch.3.3.11.1"/></para></listitem> 24 <listitem><para>Required Patch: <ulink 25 url="http://www.sleepycat.com/webforms/patchdl.php?src=patach.3.3.11.2"/></para></listitem> 26 </itemizedlist></sect3> 27 20 28 21 29 </sect2> -
content/databases/db/db-exp.xml
r23d784b r65df9fca 4 4 <para><command>cd build_unix && ../dist/configure --prefix=/usr 5 5 --enable-compat185</command>: 6 This replaces the normal <command>./configure</command> command as7 <application>Berkeley DB</application> comes with thevarious6 This replaces the normal <command>./configure</command> command, as 7 <application>Berkeley DB</application> comes with various 8 8 build directories for different platforms.</para> 9 9 -
content/databases/mysql/mysql-config.xml
r23d784b r65df9fca 12 12 <title>Configuration Information</title> 13 13 14 <para>There are several default configurations file available in 15 <filename class="directory">/usr/share/mysql</filename> which you can use.</para> 14 <para>There are several default configuration files available in 15 <filename class="directory">/usr/share/mysql</filename> which you can 16 use. Create <filename>/etc/my.cnf</filename> using the following 17 command:</para> 16 18 17 19 <screen><userinput><command>cp /usr/share/mysql/my-medium.cnf /etc/my.cnf</command></userinput></screen> 18 20 19 <para> Wecan now install a database and change the ownership to the21 <para>You can now install a database and change the ownership to the 20 22 unprivileged user and group.</para> 21 23 … … 27 29 <screen><userinput><command>mysqld_safe --user=mysql 2>&1 >/dev/null &</command></userinput></screen> 28 30 29 <para>A default installation does not setup a password for the administrator30 so here we willset one. Replace <replaceable>[new-password]</replaceable>31 <para>A default installation does not setup a password for the 32 administrator, so use the following command to set one. Replace <replaceable>[new-password]</replaceable> 31 33 with your own.</para> 32 34 … … 52 54 <screen><userinput><command>mysqladmin -u root password <replaceable>[new-password]</replaceable></command></userinput></screen> 53 55 54 <para> Now that we are done with the configuration of the server, we can55 shut it down.</para>56 <para>Configuration of the server is now finished. Shut the server down 57 using the following command:</para> 56 58 57 59 <screen><userinput><command>mysqladmin -p shutdown</command></userinput></screen> 58 60 59 <para>Install <filename>/etc/rc.d/init.d/mysql</filename>61 <para>Install the <filename>/etc/rc.d/init.d/mysql</filename> 60 62 init script included in the <xref linkend="intro-important-bootscripts"/> package.</para> 61 63 -
content/databases/postgresql/postgresql-config.xml
r23d784b r65df9fca 15 15 url="file:///usr/share/doc/postgresql/html/index.html"/>.</para> 16 16 17 <para>Install <filename>/etc/rc.d/init.d/postgresql</filename>17 <para>Install the <filename>/etc/rc.d/init.d/postgresql</filename> 18 18 init script included in the <xref linkend="intro-important-bootscripts"/> package.</para> 19 19 -
content/databases/postgresql/postgresql-desc.xml
r23d784b r65df9fca 84 84 85 85 <sect3><title>ipcclean</title> 86 <para><command>ipcclean</command> removes share memory and semaphores left over by an86 <para><command>ipcclean</command> removes shared memory and semaphores left over by an 87 87 aborted database server.</para></sect3> 88 88 -
content/databases/postgresql/postgresql-exp.xml
r23d784b r65df9fca 2 2 <title>Command explanations</title> 3 3 4 <para><command>useradd -d /var/pgsql/data postgres</command>: Add an unprivileged user to run the database server. Running the 5 server as root is dangerous, and moreover simply will not work.</para> 6 7 <para><command>su - postgres -c '/usr/bin/initdb -D /var/pgsql/data'</command>: Initialize the database tablespace. This command may not be executed 8 by root.</para> 9 10 <para><command>su - postgres -c '/usr/bin/postmaster -D /var/pgsql/data > 11 /var/pgsql/data/logfile 2>&1 &'</command>: Start the database server. User postgres must execute this command as well.</para> 4 <para><command>useradd -d /var/pgsql/data postgres</command>: Add an unprivileged user to run the database server.</para> 12 5 13 6 <para><command>createdb test, create table t1 , insert into t1 values..., select * -
content/databases/postgresql/postgresql-inst.xml
r23d784b r65df9fca 28 28 /var/pgsql/data/logfile 2>&1 &'</command></userinput></screen> 29 29 30 <para> Now we can create a database and verify the installation:</para>30 <para>Create a database and verify the installation:</para> 31 31 32 32 <screen><userinput><command>su - postgres -c '/usr/bin/createdb test' && -
content/databases/postgresql/postgresql-intro.xml
r23d784b r65df9fca 32 32 <xref linkend="Linux_PAM"/>, 33 33 <ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink> or 34 < ulink url="http://web.mit.edu/kerberos/www/">MIT Kerberos</ulink>,34 <xref linkend="mitkrb"/> or <xref linkend="heimdal"/>, 35 35 <ulink url="http://ant.apache.org/">Ant</ulink> and 36 36 <ulink url="http://rendezvous.sourceforge.net/">Rendezvous</ulink>
Note:
See TracChangeset
for help on using the changeset viewer.