Changeset 78d0e3c for content


Ignore:
Timestamp:
08/04/2004 05:51:45 AM (20 years ago)
Author:
Randy McMurchy <randy@…>
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, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
Children:
6da4d5a6
Parents:
95c3dc2
Message:

Added optional dependencies to PostgreSQL and Qt; added additional configuration information to Qt

git-svn-id: svn://svn.linuxfromscratch.org/BLFS/trunk/BOOK@2558 af4574ff-66df-0310-9fd7-8a98e5e911e0

File:
1 edited

Legend:

Unmodified
Added
Removed
  • content/databases/postgresql.xml

    r95c3dc2 r78d0e3c  
    88  <!ENTITY postgresql-download-ftp  "ftp://ftp.fr.postgresql.org/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
    99  <!ENTITY postgresql-size          "9.7 MB">
    10   <!ENTITY postgresql-buildsize     "80 MB">
     10  <!ENTITY postgresql-buildsize     "197 MB">
    1111  <!ENTITY postgresql-time          "1.21 SBU">
    1212]>
     
    1717
    1818<sect2>
    19 <title>Introduction to <application>Postgre<acronym>SQL</acronym></application></title>
    20 
    21 <para><application>Postgre<acronym>SQL</acronym></application> is an advanced object-relational
    22 database management system (<acronym>ORDBMS</acronym>), derived from the
    23 Berkeley Postgres database management system.</para>
     19<title>Introduction to <application>Postgre<acronym>SQL</acronym></application>
     20</title>
     21
     22<para><application>Postgre<acronym>SQL</acronym></application> is an advanced
     23object-relational database management system (<acronym>ORDBMS</acronym>),
     24derived from the Berkeley Postgres database management system.</para>
    2425
    2526<sect3><title>Package information</title>
     
    3233</sect3>
    3334
    34 <sect3><title><application>Postgre<acronym>SQL</acronym></application> dependencies</title>
     35<sect3><title><application>Postgre<acronym>SQL</acronym></application>
     36dependencies</title>
    3537<sect4><title>Optional</title>
    3638<para>
     
    4042<xref linkend="openssl"/>,
    4143<xref linkend="Linux_PAM"/>,
     44<xref linkend="opensp"/>,
     45<xref linkend="openjade"/>,
     46<xref linkend="perl-modules"/>: SGMLSpm-&SGMLSpm-version;,
    4247<ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink>,
    4348<xref linkend="mitkrb"/> or <xref linkend="heimdal"/>,
     
    5055
    5156<sect2>
    52 <title>Installation of <application>Postgre<acronym>SQL</acronym></application></title>
    53 
    54 <para>Install <application>Postgre<acronym>SQL</acronym></application> with the following commands: </para>
     57<title>Installation of <application>Postgre<acronym>SQL</acronym></application>
     58</title>
     59
     60<para>Install <application>Postgre<acronym>SQL</acronym></application> with the
     61following commands: </para>
    5562
    5663<screen><userinput><command>./configure --prefix=/usr &amp;&amp;
     
    105112<para><command>useradd -d /srv/pgsql/data postgres</command>: Add an unprivileged user to run the database server.</para>
    106113
    107 <para><command>createdb test, create table t1 , insert into t1 values..., select *
    108 from t1</command>: Create a database, add a table to it, insert some rows into the table
    109 and select them to verify that the installation is working
     114<para><command>createdb test, create table t1 , insert into t1 values...,
     115select * from t1</command>: Create a database, add a table to it, insert some
     116rows into the table and select them to verify that the installation is working
    110117properly.</para>
    111118
     
    113120
    114121<sect2>
    115 <title>Configuring <application>Postgre<acronym>SQL</acronym></application></title>
     122<title>Configuring <application>Postgre<acronym>SQL</acronym></application>
     123</title>
    116124
    117125<sect3>
    118126<title>Config files</title>
    119127
    120 <para><filename>$PGDATA/pg_ident.con</filename>, <filename>$PGDATA/pg_hba.conf</filename>, <filename>$PGDATA/postgresql.conf</filename></para>
    121 
    122 <para>The <envar>PGDATA</envar> environment variable is used to distinguish database
    123 clusters from one another by setting it to the value of the directory
     128<para><filename>$PGDATA/pg_ident.con</filename>,
     129<filename>$PGDATA/pg_hba.conf</filename> and
     130<filename>$PGDATA/postgresql.conf</filename></para>
     131
     132<para>The <envar>PGDATA</envar> environment variable is used to distinguish
     133database clusters from one another by setting it to the value of the directory
    124134which contains the cluster desired. The three configuration files
    125135exist in every <filename class="directory">PGDATA/</filename> directory.
     
    129139
    130140<para>Install the <filename>/etc/rc.d/init.d/postgresql</filename>
    131 init script included in the <xref linkend="intro-important-bootscripts"/> package.</para>
    132                                                                                                                
     141init script included in the <xref linkend="intro-important-bootscripts"/>
     142package.</para>
     143
    133144<screen><userinput><command>make install-postgresql</command></userinput></screen>
    134145
     
    140151<title>Contents</title>
    141152
    142 <para>The <application>Postgre<acronym>SQL</acronym></application> package contains
    143 <command>clusterdb</command>,
     153<para>The <application>Postgre<acronym>SQL</acronym></application> package
     154contains <command>clusterdb</command>,
    144155<command>createdb</command>,
    145156<command>createlang</command>,
     
    187198<sect3><title>createdb</title>
    188199<para><command>createdb</command> creates a new
    189 <application>Postgre<acronym>SQL</acronym></application> database.</para></sect3>
     200<application>Postgre<acronym>SQL</acronym></application> database.</para>
     201</sect3>
    190202
    191203<sect3><title>createlang</title>
     
    196208<sect3><title>createuser</title>
    197209<para><command>createuser</command> defines a new
    198 <application>Postgre<acronym>SQL</acronym></application> user account.</para></sect3>
     210<application>Postgre<acronym>SQL</acronym></application> user account.</para>
     211</sect3>
    199212
    200213<sect3><title>dropdb</title>
    201214<para><command>dropdb</command> removes a
    202 <application>Postgre<acronym>SQL</acronym></application> database.</para></sect3>
     215<application>Postgre<acronym>SQL</acronym></application> database.</para>
     216</sect3>
    203217
    204218<sect3><title>droplang</title>
     
    209223<sect3><title>dropuser</title>
    210224<para><command>dropuser</command> removes a
    211 <application>Postgre<acronym>SQL</acronym></application> user account.</para></sect3>
     225<application>Postgre<acronym>SQL</acronym></application> user account.</para>
     226</sect3>
    212227
    213228<sect3><title>ecpg</title>
    214 <para><command>ecpg</command> is the embedded <acronym>SQL</acronym> preprocessor.</para></sect3>
     229<para><command>ecpg</command> is the embedded <acronym>SQL</acronym>
     230preprocessor.</para></sect3>
    215231
    216232<sect3><title>initdb</title>
     
    222238
    223239<sect3><title>ipcclean</title>
    224 <para><command>ipcclean</command> removes shared memory and semaphores left over by an
    225 aborted database server.</para></sect3>
     240<para><command>ipcclean</command> removes shared memory and semaphores left
     241over by an aborted database server.</para></sect3>
    226242
    227243<sect3><title>pg_config</title>
     
    240256
    241257<sect3><title>pg_dump</title>
    242 <para><command>pg_dump</command> dumps database data and metadata into scripts which are
    243 used to recreate the database.</para></sect3>
     258<para><command>pg_dump</command> dumps database data and metadata into scripts
     259which are used to recreate the database.</para></sect3>
    244260
    245261<sect3><title>pg_dumpall</title>
     
    249265
    250266<sect3><title>pg_resetxlog</title>
    251 <para><command>pg_resetxlog</command> clears the write-ahead log and optionally resets some
    252 fields in the <filename>pg_control</filename> file.</para></sect3>
     267<para><command>pg_resetxlog</command> clears the write-ahead log and optionally
     268resets some fields in the <filename>pg_control</filename> file.</para></sect3>
    253269
    254270<sect3><title>pg_restore</title>
     
    270286
    271287<sect3><title>postgres</title>
    272 <para><command>postgres</command> is a single user database server, generally used for
    273 debugging.</para></sect3>
     288<para><command>postgres</command> is a single user database server, generally
     289used for debugging.</para></sect3>
    274290
    275291<sect3><title>postmaster</title>
    276 <para><command>postmaster</command> is the multi-user database daemon.</para></sect3>
     292<para><command>postmaster</command> is the multi-user database daemon.</para>
     293</sect3>
    277294
    278295<sect3><title>psql</title>
     
    280297
    281298<sect3><title>vacuumdb</title>
    282 <para><command>vacuumdb</command> compacts databases and generates statistics for the
    283 query analyzer.</para></sect3>
     299<para><command>vacuumdb</command> compacts databases and generates statistics
     300for the query analyzer.</para></sect3>
    284301
    285302</sect2>
Note: See TracChangeset for help on using the changeset viewer.