Changeset 4472e923 for server/databases


Ignore:
Timestamp:
03/07/2020 09:40:50 AM (4 years ago)
Author:
Pierre Labastie <pieere@…>
Branches:
10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, lazarus, lxqt, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
Children:
99c61a4
Parents:
21a08bf
Message:

Finish formatting the "server" chapter

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

Location:
server/databases
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • server/databases/lmdb.xml

    r21a08bf r4472e923  
    8282    <title>Installation of lmdb</title>
    8383
    84     <note><para>This package extracts to lmdb-LMDB_&lmdb-version;.</para></note>
     84    <note>
     85      <para>
     86        This package extracts to lmdb-LMDB_&lmdb-version;.
     87      </para>
     88    </note>
    8589
    8690    <para>
  • server/databases/mariadb.xml

    r21a08bf r4472e923  
    7373    </itemizedlist>
    7474
    75     <note><para>The installed size of MariaDB is 473 MB, but this can be
    76     reduced by about 200 MB, if desired, by removing the /usr/share/mysql/test
    77     directory after installation.</para></note>
     75    <note>
     76      <para>
     77        The installed size of MariaDB is 473 MB, but this can be
     78        reduced by about 200 MB, if desired, by removing the <filename
     79        class="directory">/usr/share/mysql/test</filename>
     80        directory after installation.
     81      </para>
     82    </note>
    7883
    7984    <bridgehead renderas="sect3">MariaDB Dependencies</bridgehead>
  • server/databases/postgresql.xml

    r21a08bf r4472e923  
    3131    <title>Introduction to PostgreSQL</title>
    3232
    33     <para><application>PostgreSQL</application> is an advanced
    34     object-relational database management system (ORDBMS), derived
    35     from the Berkeley Postgres database management system.</para>
     33    <para>
     34      <application>PostgreSQL</application> is an advanced
     35      object-relational database management system (ORDBMS), derived
     36      from the Berkeley Postgres database management system.
     37    </para>
    3638
    3739    &lfs91_checked;
     
    4042    <itemizedlist spacing="compact">
    4143      <listitem>
    42         <para>Download (HTTP): <ulink url="&postgresql-download-http;"/></para>
     44        <para>
     45          Download (HTTP): <ulink url="&postgresql-download-http;"/>
     46        </para>
    4347      </listitem>
    4448      <listitem>
    45         <para>Download (FTP): <ulink url="&postgresql-download-ftp;"/></para>
     49        <para>
     50          Download (FTP): <ulink url="&postgresql-download-ftp;"/>
     51        </para>
    4652      </listitem>
    4753      <listitem>
    48         <para>Download MD5 sum: &postgresql-md5sum;</para>
     54        <para>
     55          Download MD5 sum: &postgresql-md5sum;
     56        </para>
    4957      </listitem>
    5058      <listitem>
    51         <para>Download size: &postgresql-size;</para>
     59        <para>
     60          Download size: &postgresql-size;
     61        </para>
    5262      </listitem>
    5363      <listitem>
    54         <para>Estimated disk space required: &postgresql-buildsize;</para>
     64        <para>
     65          Estimated disk space required: &postgresql-buildsize;
     66        </para>
    5567      </listitem>
    5668      <listitem>
    57         <para>Estimated build time: &postgresql-time;</para>
     69        <para>
     70          Estimated build time: &postgresql-time;
     71        </para>
    5872      </listitem>
    5973    </itemizedlist>
     
    101115        -u 41 postgres</userinput></screen>
    102116
    103     <note><para>There are several configuration items that add additional
    104     functionality with optional packages to
    105     <application>PostgreSQL</application>.  Use <userinput>./configure
    106     --help</userinput> to see a list.</para></note>
    107 
    108     <para>Install <application>PostgreSQL</application> with the
    109     following commands: </para>
     117    <note>
     118      <para>
     119        There are several configuration items that add additional
     120        functionality with optional packages to
     121        <application>PostgreSQL</application>.  Use <command>./configure
     122        --help</command> to see a list.
     123      </para>
     124    </note>
     125
     126    <para>
     127      Install <application>PostgreSQL</application> with the
     128      following commands:
     129    </para>
    110130
    111131<screen><userinput>sed -i '/DEFAULT_PGSOCKET_DIR/s@/tmp@/run/postgresql@' src/include/pg_config_manual.h &amp;&amp;
     
    116136make</userinput></screen>
    117137
    118     <para>There are a number of programs in the
    119     <filename class="directory">contrib/</filename> directory. If you are going
    120     to run this installation as a server and wish to build some of them, enter
    121     <command>make -C contrib</command> or
    122     <command>make -C contrib/<replaceable>&lt;SUBDIR-NAME&gt;</replaceable></command> for each subdirectory.
    123     </para>
    124 
    125     <para>Tests must be run as an unprivileged user because they need to start a
    126     temporary server and this is prevented as the root user. For the same reason,
    127     you need to stop all PostgreSQL servers if any are running. If a previous
    128     version of PostgreSQL is installed, it may be necessary to use
    129     <command>--disable-rpath</command> with <command>configure</command> to
    130     avoid failures, but <emphasis>installing the binaries created using this
    131     switch is not recommended</emphasis>. To test the results, issue:
    132     <command>make check</command>.</para>
    133 
    134     <para>Now, as the <systemitem class="username">root</systemitem> user:</para>
     138    <para>
     139      There are a number of programs in the
     140      <filename class="directory">contrib/</filename> directory. If you are
     141      going to run this installation as a server and wish to build some of
     142      them, enter <command>make -C contrib</command> or <command>make -C
     143      contrib/<replaceable>&lt;SUBDIR-NAME&gt;</replaceable></command> for
     144      each subdirectory.
     145    </para>
     146
     147    <para>
     148      Tests must be run as an unprivileged user because they need to start a
     149      temporary server and this is prevented as the root user. For the same
     150      reason, you need to stop all PostgreSQL servers if any are running. If a
     151      previous version of PostgreSQL is installed, it may be necessary to use
     152      <command>--disable-rpath</command> with <command>configure</command> to
     153      avoid failures, but <emphasis>installing the binaries created using this
     154      switch is not recommended</emphasis>. To test the results, issue:
     155      <command>make check</command>.
     156    </para>
     157
     158    <para>
     159      Now, as the <systemitem class="username">root</systemitem> user:
     160    </para>
    135161
    136162<screen role="root"><userinput>make install      &amp;&amp;
    137163make install-docs</userinput></screen>
    138164
    139     <para>If you made any of the <filename class="directory">contrib/</filename>
    140     programs, as the <systemitem class="username">root</systemitem> user:</para>
     165    <para>
     166      If you made any of the <filename class="directory">contrib/</filename>
     167      programs, as the <systemitem class="username">root</systemitem> user:
     168    </para>
    141169
    142170<screen role="nodump"><userinput>make -C contrib/<replaceable>&lt;SUBDIR-NAME&gt;</replaceable> install</userinput></screen>
    143171
    144     <para><emphasis>If you only intend to use
    145     <application>PostgreSQL</application> as a client to connect to a server on
    146     another machine, your installation is complete and you should not run the
    147     remaining commands.</emphasis></para>
    148 
    149     <!-- 'Upgrading' seems to only ever exist in the docs for *previous* version -->
    150  <!-- Obsolete: only if upgrading for versions prior to 9   <note>
    151       <para>If you are upgrading an existing system and are going to install
    152       the new files over the old ones, then you should back up your data, shut
    153       down the old server and follow the instructions in <ulink
    154       url="http://www.postgresql.org/docs/9.0/static/install-upgrading.html">the
    155       official <application>PostgreSQL</application> documentation</ulink>.</para>
    156     </note>-->
    157 
    158     <para>Initialize a database cluster with the following commands issued by the
    159     <systemitem class="username">root</systemitem> user:</para>
     172    <tip>
     173      <para>
     174        If you only intend to use <application>PostgreSQL</application> as a
     175        client to connect to a server on another machine, your installation is
     176        complete and you should not run the remaining commands.
     177      </para>
     178    </tip>
     179
     180    <para>
     181      Initialize a database cluster with the following commands issued by the
     182      <systemitem class="username">root</systemitem> user:
     183    </para>
    160184
    161185<screen role="root"><userinput>install -v -dm700 /srv/pgsql/data &amp;&amp;
     
    163187chown -Rv postgres:postgres /srv/pgsql /run/postgresql</userinput></screen>
    164188
    165     <para>Now, initialize the database as the <systemitem
    166     class="username">root</systemitem> user:</para>
     189    <para>
     190      Now, initialize the database as the <systemitem
     191      class="username">root</systemitem> user:
     192    </para>
    167193
    168194<screen role="root"><userinput>su - postgres -c '/usr/bin/initdb -D /srv/pgsql/data'</userinput></screen>
     
    181207    </para>
    182208
    183     <para><parameter>--docdir=/usr/share/doc/postgresql-&postgresql-version;</parameter>:
    184     This switch puts the documentation in a versioned directory.</para>
    185 
    186     <para><parameter>--enable-thread-safety</parameter>: This switch makes the
    187     client libraries thread-safe by allowing concurrent threads in
    188     <filename class="libraryfile">libpq</filename> and ECPG programs to safely
    189     control their private connection handles.</para>
    190 
    191     <para><option>--with-openssl</option>: builds the package  with support for
    192     <application>OpenSSL</application> encrypted connections.</para>
    193 
    194     <para><option>--with-perl</option>: builds the PL/Perl server-side language.
    195     </para>
    196 
    197     <para><option>--with-python</option>: builds the PL/Python server-side
    198     language. Add PYTHON=/usr/bin/python2 for Python2 support, otherwise
    199     Python3 is used by default.</para>
    200 
    201     <para><option>--with-tcl</option>: builds the PL/Tcl server-side language.</para>
     209    <para>
     210      <parameter>--enable-thread-safety</parameter>: This switch makes the
     211      client libraries thread-safe by allowing concurrent threads in
     212      <filename class="libraryfile">libpq</filename> and ECPG programs to
     213      safely control their private connection handles.
     214    </para>
     215
     216    <para>
     217      <option>--with-openssl</option>: builds the package  with support for
     218      <application>OpenSSL</application> encrypted connections.
     219    </para>
     220
     221    <para>
     222      <option>--with-perl</option>: builds the PL/Perl server-side language.
     223    </para>
     224
     225    <para>
     226      <option>--with-python</option>: builds the PL/Python server-side
     227      language. Add PYTHON=/usr/bin/python2 for Python2 support, otherwise
     228      Python3 is used by default.
     229    </para>
     230
     231    <para>
     232      <option>--with-tcl</option>: builds the PL/Tcl server-side language.
     233    </para>
    202234
    203235  </sect2>
     
    209241      <title>Config Files</title>
    210242
    211       <para><filename>$PGDATA/pg_ident.con</filename>,
    212       <filename>$PGDATA/pg_hba.conf</filename> and
    213       <filename>$PGDATA/postgresql.conf</filename></para>
     243      <para>
     244        <filename>$PGDATA/pg_ident.con</filename>,
     245        <filename>$PGDATA/pg_hba.conf</filename>, and
     246        <filename>$PGDATA/postgresql.conf</filename>
     247      </para>
    214248
    215249      <indexterm zone="postgresql postgresql-config">
     
    225259      </indexterm>
    226260
    227       <para>The <envar>PGDATA</envar> environment variable is used to
    228       distinguish database clusters from one another by setting it to
    229       the value of the directory which contains the cluster desired.
    230       The three configuration files exist in every <filename
    231       class="directory">PGDATA/</filename> directory. Details on the
    232       format of the files and the options that can be set in each can
    233       be found in <ulink
    234       url="file:///usr/share/doc/postgresql-&postgresql-version;/html/index.html"/>.</para>
     261      <para>
     262        The <envar>PGDATA</envar> environment variable is used to
     263        distinguish database clusters from one another by setting it to
     264        the value of the directory which contains the cluster desired.
     265        The three configuration files exist in every <filename
     266        class="directory">PGDATA/</filename> directory. Details on the
     267        format of the files and the options that can be set in each can
     268        be found in <filename>
     269        /usr/share/doc/postgresql-&postgresql-version;/html/index.html</filename>.
     270      </para>
    235271
    236272    </sect3>
     
    240276             <phrase revision="systemd">Systemd Unit</phrase></title>
    241277
    242       <para>Install the
    243       <phrase revision="sysv"><filename>/etc/rc.d/init.d/postgresql</filename>
    244       init script</phrase>
    245       <phrase revision="systemd"><filename>postgresql.service</filename>
    246       unit</phrase> included in the
    247       <xref linkend="bootscripts" revision="sysv"/>
    248       <xref linkend="systemd-units" revision="systemd"/> package.</para>
     278      <para>
     279        Install the
     280        <phrase revision="sysv"><filename>/etc/rc.d/init.d/postgresql</filename>
     281        init script</phrase>
     282        <phrase revision="systemd"><filename>postgresql.service</filename>
     283        unit</phrase> included in the
     284        <xref linkend="bootscripts" revision="sysv"/>
     285        <xref linkend="systemd-units" revision="systemd"/> package:
     286      </para>
    249287
    250288      <indexterm zone="postgresql postgresql-init">
     
    293331
    294332      <para>
    295         When you are done with testing, you can shut down the server, by issuing
    296         as <systemitem class="username">root</systemitem>:
     333        When you are done with testing, you can shut down the server, by
     334        issuing as <systemitem class="username">root</systemitem>:
    297335      </para>
    298336
     
    346384        <term><command>clusterdb</command></term>
    347385        <listitem>
    348           <para>is a utility for reclustering tables in a
    349           <application>PostgreSQL</application> database.</para>
     386          <para>
     387            is a utility for reclustering tables in a
     388            <application>PostgreSQL</application> database.
     389          </para>
    350390          <indexterm zone="postgresql clusterdb">
    351391            <primary sortas="b-clusterdb">clusterdb</primary>
     
    357397        <term><command>createdb</command></term>
    358398        <listitem>
    359           <para> creates a new <application>PostgreSQL</application>
    360           database.</para>
     399          <para>
     400            creates a new <application>PostgreSQL</application>
     401            database.
     402          </para>
    361403          <indexterm zone="postgresql createdb">
    362404            <primary sortas="b-createdb">createdb</primary>
     
    365407      </varlistentry>
    366408 
    367 <!--  <varlistentry id="createlang">
    368         <term><command>createlang</command></term>
    369         <listitem>
    370           <para>defines a new <application>PostgreSQL</application> procedural
    371           language.</para>
    372           <indexterm zone="postgresql createlang">
    373             <primary sortas="b-createlang">createlang</primary>
    374           </indexterm>
    375         </listitem>
    376       </varlistentry>-->
    377 
    378409      <varlistentry id="createuser">
    379410        <term><command>createuser</command></term>
    380411        <listitem>
    381           <para>defines a new <application>PostgreSQL</application>
    382           user account.</para>
     412          <para>
     413            defines a new <application>PostgreSQL</application>
     414            user account.
     415          </para>
    383416          <indexterm zone="postgresql createuser">
    384417            <primary sortas="b-createuser">createuser</primary>
     
    390423        <term><command>dropdb</command></term>
    391424        <listitem>
    392           <para>removes a <application>PostgreSQL</application> database.</para>
     425          <para>
     426            removes a <application>PostgreSQL</application> database.
     427          </para>
    393428          <indexterm zone="postgresql dropdb">
    394429            <primary sortas="b-dropdb">dropdb</primary>
     
    397432      </varlistentry>
    398433
    399 <!--  <varlistentry id="droplang">
    400         <term><command>droplang</command></term>
    401         <listitem>
    402           <para>removes a <application>PostgreSQL</application> procedural
    403           language.</para>
    404           <indexterm zone="postgresql droplang">
    405             <primary sortas="b-droplang">droplang</primary>
    406           </indexterm>
    407         </listitem>
    408       </varlistentry> -->
    409 
    410434      <varlistentry id="dropuser">
    411435        <term><command>dropuser</command></term>
    412436        <listitem>
    413           <para>removes a <application>PostgreSQL</application>
    414           user account.</para>
     437          <para>
     438            removes a <application>PostgreSQL</application> user account.
     439          </para>
    415440          <indexterm zone="postgresql dropuser">
    416441            <primary sortas="b-dropuser">dropuser</primary>
     
    422447        <term><command>ecpg</command></term>
    423448        <listitem>
    424           <para>is the embedded SQL preprocessor.</para>
     449          <para>
     450            is the embedded SQL preprocessor.
     451          </para>
    425452          <indexterm zone="postgresql ecpg">
    426453            <primary sortas="b-ecpg">ecpg</primary>
     
    432459        <term><command>initdb</command></term>
    433460        <listitem>
    434           <para>creates a new database cluster.</para>
     461          <para>
     462            creates a new database cluster.
     463          </para>
    435464          <indexterm zone="postgresql initdb">
    436465            <primary sortas="b-initdb">initdb</primary>
     
    442471        <term><command>oid2name</command></term>
    443472        <listitem>
    444           <para>resolves OIDs (Object IDs) and file nodes in a PostgreSQL data
    445           directory.</para>
     473          <para>
     474            resolves OIDs (Object IDs) and file nodes in a PostgreSQL data
     475            directory.
     476          </para>
    446477          <indexterm zone="postgresql oid2name">
    447478            <primary sortas="b-oid2name">oid2name</primary>
     
    453484        <term><command>pg_archivecleanup</command></term>
    454485        <listitem>
    455           <para>cleans up PostgreSQL WAL (write-ahead log) archive files.</para>
     486          <para>
     487            cleans up PostgreSQL WAL (write-ahead log) archive files.
     488          </para>
    456489          <indexterm zone="postgresql pg_archivecleanup">
    457490            <primary sortas="b-pg_archivecleanup">pg_archivecleanup</primary>
     
    463496        <term><command>pg_basebackup</command></term>
    464497        <listitem>
    465           <para>takes base backups of a running
    466           <application>PostgreSQL</application> cluster.</para>
     498          <para>
     499            takes base backups of a running
     500            <application>PostgreSQL</application> cluster.
     501          </para>
    467502          <indexterm zone="postgresql pg_basebackup">
    468503            <primary sortas="b-pg_basebackup">pg_basebackup</primary>
     
    474509        <term><command>pg_config</command></term>
    475510        <listitem>
    476           <para>retrieves <application>PostgreSQL</application> version
    477           information.</para>
     511          <para>
     512            retrieves <application>PostgreSQL</application> version
     513            information.
     514          </para>
    478515          <indexterm zone="postgresql pg_config">
    479516            <primary sortas="b-pg_config">pg_config</primary>
     
    485522        <term><command>pg_controldata</command></term>
    486523        <listitem>
    487           <para>returns information initialized during
    488           <command>initdb</command>, such as the catalog version and server
    489           locale.</para>
     524          <para>
     525            returns information initialized during <command>initdb</command>,
     526            such as the catalog version and server locale.
     527          </para>
    490528          <indexterm zone="postgresql pg_controldata">
    491529            <primary sortas="b-pg_controldata">pg_controldata</primary>
     
    497535        <term><command>pg_ctl</command></term>
    498536        <listitem>
    499           <para>controls stopping and starting the database server.</para>
     537          <para>
     538            controls stopping and starting the database server.
     539          </para>
    500540          <indexterm zone="postgresql pg_ctl">
    501541            <primary sortas="b-pg_ctl">pg_ctl</primary>
     
    507547        <term><command>pg_dump</command></term>
    508548        <listitem>
    509           <para>dumps database data and metadata into scripts which are used
    510           to recreate the database.</para>
     549          <para>
     550            dumps database data and metadata into scripts which are used
     551            to recreate the database.
     552          </para>
    511553          <indexterm zone="postgresql pg_dump">
    512554            <primary sortas="b-pg_dump">pg_dump</primary>
     
    518560        <term><command>pg_dumpall</command></term>
    519561        <listitem>
    520           <para>recursively calls <command>pg_dump</command> for each
    521           database in a cluster.</para>
     562          <para>
     563            recursively calls <command>pg_dump</command> for each
     564            database in a cluster.
     565          </para>
    522566          <indexterm zone="postgresql pg_dumpall">
    523567            <primary sortas="b-pg_dumpall">pg_dumpall</primary>
     
    529573        <term><command>pg_isready</command></term>
    530574        <listitem>
    531           <para>check the connection status of a PostgreSQL server.</para>
     575          <para>
     576            checks the connection status of a PostgreSQL server.
     577          </para>
    532578          <indexterm zone="postgresql pg_isready">
    533579            <primary sortas="b-pg_isready">pg_isready</primary>
     
    551597        <term><command>pg_recvlogical</command></term>
    552598        <listitem>
    553           <para>controls PostgreSQL logical decoding streams.</para>
     599          <para>
     600            controls PostgreSQL logical decoding streams.
     601          </para>
    554602          <indexterm zone="postgresql pg_recvlogical">
    555603            <primary sortas="b-pg_recvlogical">pg_recvlogical</primary>
     
    561609        <term><command>pg_resetwal</command></term>
    562610        <listitem>
    563           <para>resets the write-ahead log and other control information
    564           of a PostgreSQL database cluseter.</para>
     611          <para>
     612            resets the write-ahead log and other control information
     613            of a PostgreSQL database cluster.
     614          </para>
    565615          <indexterm zone="postgresql pg_resetwal">
    566616            <primary sortas="b-pg_resetwal">pg_resetwal</primary>
     
    572622        <term><command>pg_restore</command></term>
    573623        <listitem>
    574           <para>creates databases from dump files created by
    575           <command>pg_dump</command>.</para>
     624          <para>
     625            creates databases from dump files created by
     626            <command>pg_dump</command>.
     627          </para>
    576628          <indexterm zone="postgresql pg_restore">
    577629            <primary sortas="b-pg_restore">pg_restore</primary>
     
    583635        <term><command>pg_rewind</command></term>
    584636        <listitem>
    585           <para>synchronizes a PostgreSQL data directory with another data
    586           directory that was forked from the first one.</para>
     637          <para>
     638            synchronizes a PostgreSQL data directory with another data
     639            directory that was forked from the first one.
     640          </para>
    587641          <indexterm zone="postgresql pg_rewind">
    588642            <primary sortas="b-pg_rewind">pg_rewind</primary>
     
    594648        <term><command>pg_standby</command></term>
    595649        <listitem>
    596           <para>supports the creation of a PostgreSQL warm standby
    597           server.</para>
     650          <para>
     651            supports the creation of a PostgreSQL warm standby server.
     652          </para>
    598653          <indexterm zone="postgresql pg_standby">
    599654            <primary sortas="b-pg_standby">pg_standby</primary>
     
    605660        <term><command>pg_test_fsync</command></term>
    606661        <listitem>
    607           <para>determine fastest wal_sync method for PostgreSQL.</para>
     662          <para>
     663            determines fastest wal_sync method for PostgreSQL.
     664          </para>
    608665          <indexterm zone="postgresql pg_test_fsync">
    609666            <primary sortas="b-pg_test_fsync">pg_test_fsync</primary>
     
    615672        <term><command>pg_test_timing</command></term>
    616673        <listitem>
    617           <para>measure timing overhead.</para>
     674          <para>
     675            measures timing overhead.
     676          </para>
    618677          <indexterm zone="postgresql pg_test_timing">
    619678            <primary sortas="b-pg_test_timing">pg_test_timing</primary>
     
    625684        <term><command>pg_upgrade</command></term>
    626685        <listitem>
    627           <para>upgrade a PostgreSQL server instance.</para>
     686          <para>
     687            upgrades a PostgreSQL server instance.
     688          </para>
    628689          <indexterm zone="postgresql pg_upgrade">
    629690            <primary sortas="b-pg_upgrade">pg_upgrade</primary>
     
    635696        <term><command>pg_waldump</command></term>
    636697        <listitem>
    637           <para>display a human-readable rendering of the write-ahead log of a
    638           PostgreSQL database cluster.</para>
     698          <para>
     699            displays a human-readable rendering of the write-ahead log of a
     700            PostgreSQL database cluster.
     701          </para>
    639702          <indexterm zone="postgresql pg_waldump">
    640703            <primary sortas="b-pg_waldump">pg_waldump</primary>
     
    646709        <term><command>pgbench</command></term>
    647710        <listitem>
    648           <para>run a benchmark test on PostgreSQL.</para>
     711          <para>
     712            runs a benchmark test on PostgreSQL.
     713          </para>
    649714          <indexterm zone="postgresql pgbench">
    650715            <primary sortas="b-pgbench">pgbench</primary>
     
    656721        <term><command>pltcl_delmod</command></term>
    657722        <listitem>
    658           <para>is a support script used to delete a module from a
    659           PL/<application>Tcl</application> table. The command
    660           requires the <ulink
    661           url="http://flightaware.github.io/Pgtcl/">Pgtcl</ulink>
    662           package to be installed also.</para>
     723          <para>
     724            is a support script used to delete a module from a
     725            PL/<application>Tcl</application> table. The command
     726            requires the <ulink
     727            url="http://flightaware.github.io/Pgtcl/">Pgtcl</ulink>
     728            package to be installed also.
     729          </para>
    663730          <indexterm zone="postgresql pltcl_delmod">
    664731            <primary sortas="b-pltcl_delmod">pltcl_delmod</primary>
     
    670737        <term><command>pltcl_listmod</command></term>
    671738        <listitem>
    672           <para>is a support script used to list the modules in a
    673           PL/<application>Tcl</application> table. The command
    674           requires the <ulink
    675           url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink>
    676           package to be installed also.</para>
     739          <para>
     740            is a support script used to list the modules in a
     741            PL/<application>Tcl</application> table. The command
     742            requires the <ulink
     743            url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink>
     744            package to be installed also.
     745          </para>
    677746          <indexterm zone="postgresql pltcl_listmod">
    678747            <primary sortas="b-pltcl_listmod">pltcl_listmod</primary>
     
    684753        <term><command>pltcl_loadmod</command></term>
    685754        <listitem>
    686           <para>is a support script used to load a module into a
    687           PL/<application>Tcl</application> table. The command
    688           requires the <ulink
    689           url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink>
    690           package to be installed also.</para>
     755          <para>
     756            is a support script used to load a module into a
     757            PL/<application>Tcl</application> table. The command
     758            requires the <ulink
     759            url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink>
     760            package to be installed also.
     761          </para>
    691762          <indexterm zone="postgresql pltcl_loadmod">
    692763            <primary sortas="b-pltcl_loadmod">pltcl_loadmod</primary>
     
    698769        <term><command>postgres</command></term>
    699770        <listitem>
    700           <para>is the PostgreSQL database server.</para>
     771          <para>
     772            is the PostgreSQL database server.
     773          </para>
    701774          <indexterm zone="postgresql postgres">
    702775            <primary sortas="b-postgres">postgres</primary>
     
    708781        <term><command>postmaster</command></term>
    709782        <listitem>
    710           <para>(deprecated, a symlink to <command>postgres</command>) is a
    711           multi-user database daemon.</para>
     783          <para>
     784            (deprecated, a symlink to <command>postgres</command>) is a
     785            multi-user database daemon.
     786          </para>
    712787          <indexterm zone="postgresql postmaster">
    713788            <primary sortas="b-postmaster">postmaster</primary>
     
    719794        <term><command>psql</command></term>
    720795        <listitem>
    721           <para>is a console based database shell.</para>
     796          <para>
     797            is a console based database shell.
     798          </para>
    722799          <indexterm zone="postgresql psql">
    723800            <primary sortas="b-psql">psql</primary>
     
    729806        <term><command>reindexdb</command></term>
    730807        <listitem>
    731           <para>is a utility for rebuilding indexes in a database.</para>
     808          <para>
     809            is a utility for rebuilding indexes in a database.
     810          </para>
    732811          <indexterm zone="postgresql reindexdb">
    733812            <primary sortas="b-reindexdb">reindexdb</primary>
     
    739818        <term><command>vacuumdb</command></term>
    740819        <listitem>
    741           <para>compacts databases and generates statistics for the query
    742           analyzer.</para>
     820          <para>
     821            compacts databases and generates statistics for the query analyzer.
     822          </para>
    743823          <indexterm zone="postgresql vacuumdb">
    744824            <primary sortas="b-vacuumdb">vacuumdb</primary>
     
    750830        <term><command>vacuumlo</command></term>
    751831        <listitem>
    752           <para>remove orphaned large objects from a PostgreSQL database.</para>
     832          <para>
     833            removes orphaned large objects from a PostgreSQL database.
     834          </para>
    753835          <indexterm zone="postgresql vacuumlo">
    754836            <primary sortas="b-vacuumlo">vacuumlo</primary>
     
    760842        <term><filename class='libraryfile'>libecpg.{so,a}</filename></term>
    761843        <listitem>
    762           <para>contains functions to support embedded SQL in C programs.</para>
     844          <para>
     845            contains functions to support embedded SQL in C programs.
     846          </para>
    763847          <indexterm zone="postgresql libecpg">
    764848            <primary sortas="c-libecpg">libecpg.{so,a}</primary>
     
    770854        <term><filename class='libraryfile'>libecpg_compat.{so,a}</filename></term>
    771855        <listitem>
    772           <para>is the ecpg compatibility library.</para>
     856          <para>
     857            is the ecpg compatibility library.
     858          </para>
    773859          <indexterm zone="postgresql libecpg_compat">
    774860            <primary sortas="c-libecpg_compat">libecpg_compat.{so,a}</primary>
     
    780866        <term><filename class='libraryfile'>libgport.a</filename></term>
    781867        <listitem>
    782           <para>is the port-specific subsystem of the Postgres backend.</para>
     868          <para>
     869            is the port-specific subsystem of the Postgres backend.
     870          </para>
    783871          <indexterm zone="postgresql libgport">
    784872            <primary sortas="c-libgport">libgport.a</primary>
     
    790878        <term><filename class='libraryfile'>libpgtypes.{so,a}</filename></term>
    791879        <listitem>
    792           <para>contains functions for dealing with Postgres data types.</para>
     880          <para>
     881            contains functions for dealing with Postgres data types.
     882          </para>
    793883          <indexterm zone="postgresql libpgtypes">
    794884            <primary sortas="c-libpgtypes">libpgtypes.{so,a}</primary>
     
    800890        <term><filename class='libraryfile'>libpq.{so,a}</filename></term>
    801891        <listitem>
    802           <para>is the C programmer's API to Postgres.</para>
     892          <para>
     893            is the C programmer's API to Postgres.
     894          </para>
    803895          <indexterm zone="postgresql libpq">
    804896            <primary sortas="c-libpq">libpq.{so,a}</primary>
Note: See TracChangeset for help on using the changeset viewer.