Changeset 44e4099


Ignore:
Timestamp:
04/08/2005 07:48:16 PM (16 years ago)
Author:
Randy McMurchy <randy@…>
Branches:
10.0, 10.1, 11.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, krejzi/svn, nosym, perl-modules, qt5new, systemd-11177, systemd-13485, trunk, xry111/git-date, xry111/git-date-for-trunk, xry111/git-date-test
Children:
a65cdde7
Parents:
28da027b
Message:

Updated to PostgreSQL-8.0.1; updated Apache-ANT build entities

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

Files:
4 edited

Legend:

Unmodified
Added
Removed
  • content/databases/postgresql.xml

    r28da027b r44e4099  
    77  <!ENTITY postgresql-download-http "http://gd.tuwien.ac.at/db/postgresql/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
    88  <!ENTITY postgresql-download-ftp  "ftp://ftp.fr.postgresql.org/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
    9   <!ENTITY postgresql-md5sum        "f0ea2b372a7bdaf2613e92176ebf5e0f">
    10   <!ENTITY postgresql-size          "10.2 MB">
    11   <!ENTITY postgresql-buildsize     "236 MB">
    12   <!ENTITY postgresql-time          "1.21 SBU">
     9  <!ENTITY postgresql-md5sum        "075ac81c865b0af865459260bf1ca890">
     10  <!ENTITY postgresql-size          "11.0 MB">
     11  <!ENTITY postgresql-buildsize     "259 MB">
     12  <!ENTITY postgresql-time          "1.34 SBU">
    1313]>
    1414
     
    2020<?dbhtml filename="postgresql.html"?>
    2121<title>Postgre<acronym>SQL</acronym>-&postgresql-version;</title>
     22<indexterm zone="postgresql">
     23<primary sortas="a-PostgreSQL">PostgreSQL</primary></indexterm>
    2224
    2325<sect2>
    24 <title>Introduction to <application>Postgre<acronym>SQL</acronym></application>
    25 </title>
     26<title>Introduction to
     27<application>Postgre<acronym>SQL</acronym></application></title>
    2628
    2729<para><application>Postgre<acronym>SQL</acronym></application> is an advanced
     
    4345</sect3>
    4446
     47<!--
    4548<sect3><title>Additional downloads</title>
    4649<itemizedlist spacing='compact'>
     
    4952</listitem></itemizedlist>
    5053</sect3>
     54 -->
    5155
    5256<sect3><title><application>Postgre<acronym>SQL</acronym></application>
     
    5559<para><xref linkend="python"/>,
    5660<xref linkend="tcl"/>,
    57 <xref linkend="tk"/>,
    5861<xref linkend="openssl"/>,
    5962<xref linkend="Linux_PAM"/>,
    60 <xref linkend="sgml-dtd-3"/>,
     63<xref linkend="sgml-dtd"/>,
    6164<xref linkend="docbook-dsssl"/>,
    6265<xref linkend="openjade"/>,
    6366<xref linkend="perl-modules"/>: SGMLSpm-&SGMLSpm-version;,
    6467<ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink>,
    65 <xref linkend="mitkrb"/> or <xref linkend="heimdal"/>,
    66 <xref linkend="apache-ant"/> and
     68<xref linkend="mitkrb"/> or <xref linkend="heimdal"/>, and
    6769<ulink url="http://rendezvous.sourceforge.net/">Rendezvous</ulink></para>
    6870</sect4>
     
    7274
    7375<sect2>
    74 <title>Installation of <application>Postgre<acronym>SQL</acronym></application>
    75 </title>
     76<title>Installation of
     77<application>Postgre<acronym>SQL</acronym></application></title>
    7678
    7779<para>In order for <command>configure</command> to properly discover
    7880<application>Docbook <acronym>SGML</acronym>
    79 <acronym>DTD</acronym></application> (v3.1), you may need to remove
     81<acronym>DTD</acronym></application>, you may need to remove
    8082<application>OpenSP</application> catalog definitions from the system
    8183<acronym>SGML</acronym> catalogs. Use the following command before building
     
    9092following commands: </para>
    9193
    92 <screen><userinput><command>patch -Np1 -i ../postgresql-&postgresql-version;-dsssl_fix-1.patch &amp;&amp;
     94<screen><userinput><command>sed -i \
     95    -e "s|dsssl-stylesheets|&amp; \\\\\n        sgml/docbook/&amp;-&docbook-dsssl-version;|" \
     96    configure &amp;&amp;
    9397./configure --prefix=/usr --enable-thread-safety &amp;&amp;
    94 make &amp;&amp;
    95 make install &amp;&amp;
     98make</command></userinput></screen>
     99
     100<para>Now, as the root user:</para>
     101
     102<screen><userinput role='root'><command>make install &amp;&amp;
    96103chown -R root:root /usr/share/doc/postgresql/html</command></userinput></screen>
    97104
     105<!--
    98106<para>The standard installation provides only the header files needed
    99107for client application development. Server-side applications require
     
    102110
    103111<screen><userinput><command>make install-all-headers</command></userinput></screen>
     112 -->
    104113
    105114<note><para>If you are upgrading an existing system and are going to
     
    107116back up your data, shut down the old server and follow the
    108117instructions in <ulink
    109 url="http://www.postgresql.org/docs/7.4/static/install-upgrading.html">the
     118url="http://www.postgresql.org/docs/8.0/static/install-upgrading.html">the
    110119official <application>Postgre<acronym>SQL</acronym></application>
    111120documentation</ulink>.</para></note>
    112121
    113 <para>Initialize a database cluster with the following commands:</para>
    114 
    115 <screen><userinput><command>mkdir -p /srv/pgsql/data &amp;&amp;
    116 useradd -d /srv/pgsql/data postgres &amp;&amp;
    117 chown postgres /srv/pgsql/data &amp;&amp;
     122<para>Initialize a database cluster with the following commands issued by the
     123root user:</para>
     124
     125<screen><userinput role='root'><command>install -v -m755 -d /srv/pgsql/data &amp;&amp;
     126useradd -c "PostgreSQL Server" -g users -d /srv/pgsql/data postgres &amp;&amp;
     127chown -v postgres /srv/pgsql/data &amp;&amp;
    118128su - postgres -c '/usr/bin/initdb -D /srv/pgsql/data'</command></userinput></screen>
    119129
    120 <para>Start the database server with the following command:</para>
    121 
    122 <screen><userinput><command>su - postgres -c '/usr/bin/postmaster -D /srv/pgsql/data > \
     130<para>As the root user, start the database server with the following
     131command:</para>
     132
     133<screen><userinput role='root'><command>su - postgres -c '/usr/bin/postmaster -D /srv/pgsql/data > \
    123134    /srv/pgsql/data/logfile 2&gt;&amp;1 &amp;'</command></userinput></screen>
    124135
    125 <para>Create a database and verify the installation:</para>
    126 
    127 <screen><userinput><command>su - postgres -c '/usr/bin/createdb test' &amp;&amp;
     136<para>Still as user root, create a database and verify the
     137installation:</para>
     138
     139<screen><userinput role='root'><command>su - postgres -c '/usr/bin/createdb test' &amp;&amp;
    128140echo "create table t1 ( name varchar(20), state_province varchar(20) );" \
    129141    | (su - postgres -c '/usr/bin/psql test ') &amp;&amp;
     
    141153<title>Command explanations</title>
    142154
     155<para><command>sed -i -e "s|dsssl-stylesheets|..."</command>: This command
     156puts an extra line in the <command>configure</command> script so that the
     157<acronym>BLFS</acronym> installed version of the <acronym>DSSSL</acronym>
     158stylesheets can be discovered.</para>
     159
    143160<para><parameter>--enable-thread-safety</parameter>: This switch makes the
    144161client libraries thread-safe by allowing concurrent threads in
     
    150167files.</para>
    151168
    152 <para><command>useradd -d /srv/pgsql/data postgres</command>: Add an
    153 unprivileged user to run the database server.</para>
    154 
    155 <para><command>createdb test, create table t1 , insert into t1 values...,
     169<para><command>useradd ...</command>: Add an unprivileged user to run the
     170database server.</para>
     171
     172<para><command>createdb test; create table t1; insert into t1 values...;
    156173select * from t1</command>: Create a database, add a table to it, insert some
    157174rows into the table and select them to verify that the installation is working
     
    161178
    162179<sect2>
    163 <title>Configuring <application>Postgre<acronym>SQL</acronym></application>
    164 </title>
     180<title>Configuring
     181<application>Postgre<acronym>SQL</acronym></application></title>
    165182
    166183<sect3>
    167 <title>Config files</title>
     184<title id="postgresql-config">Config files</title>
    168185
    169186<para><filename>$PGDATA/pg_ident.con</filename>,
    170187<filename>$PGDATA/pg_hba.conf</filename> and
    171188<filename>$PGDATA/postgresql.conf</filename></para>
     189<indexterm zone="postgresql postgresql-config">
     190<primary sortas="e-A.PGDATA-pg_ident.con">$PGDATA/pg_indent.con</primary>
     191</indexterm>
     192<indexterm zone="postgresql postgresql-config">
     193<primary sortas="e-A.PGDATA-pg_hba.conf">$PGDATA/pg_hba_conf</primary>
     194</indexterm>
     195<indexterm zone="postgresql postgresql-config">
     196<primary sortas="e-A.PGDATA-postgresql.conf">$PGDATA/postgresql.conf</primary>
     197</indexterm>
    172198
    173199<para>The <envar>PGDATA</envar> environment variable is used to distinguish
     
    179205url="file:///usr/share/doc/postgresql/html/index.html"/>.</para>
    180206
    181 <para>Install the <filename>/etc/rc.d/init.d/postgresql</filename>
    182 init script included in the <xref linkend="intro-important-bootscripts"/>
    183 package.</para>
     207<para id="postgresql-init">Install the
     208<filename>/etc/rc.d/init.d/postgresql</filename> init script included in the
     209<xref linkend="intro-important-bootscripts"/> package.</para>
     210<indexterm zone="postgresql postgresql-init">
     211<primary sortas="f-postgresql">postgresql</primary></indexterm>
    184212
    185213<screen><userinput><command>make install-postgresql</command></userinput></screen>
    186 
    187214</sect3>
    188215
     
    192219<title>Contents</title>
    193220
    194 <para>The <application>Postgre<acronym>SQL</acronym></application> package
    195 contains <command>clusterdb</command>,
    196 <command>createdb</command>,
    197 <command>createlang</command>,
    198 <command>createuser</command>,
    199 <command>dropdb</command>,
    200 <command>droplang</command>,
    201 <command>dropuser</command>,
    202 <command>ecpg</command>,
    203 <command>initdb</command>,
    204 <command>initlocation</command>,
    205 <command>ipcclean</command>,
    206 <command>pg_config</command>,
    207 <command>pg_controldata</command>,
    208 <command>pg_ctl</command>,
    209 <command>pg_dump</command>,
    210 <command>pg_dumpall</command>,
    211 <command>pg_encoding</command>,
    212 <command>pg_id</command>,
    213 <command>pg_resetxlog</command>,
    214 <command>pg_restore</command>,
    215 <command>pgtclsh</command>,
    216 <command>pgtksh</command>,
    217 <command>pltcl_delmod</command>,
    218 <command>pltcl_listmod</command>,
    219 <command>pltcl_loadmod</command>,
    220 <command>postgres</command>,
    221 <command>postmaster</command>,
    222 <command>psql</command>,
    223 <command>vacuumdb</command>,
    224 <filename class="libraryfile">libecpg</filename>,
    225 <filename class="libraryfile">libpgtcl</filename>,
    226 <filename class="libraryfile">libpgtypes</filename>,
    227 <filename class="libraryfile">libpq</filename> and various charset
    228 modules.</para>
     221<segmentedlist>
     222<segtitle>Installed Programs</segtitle>
     223<segtitle>Installed Libraries</segtitle>
     224<segtitle>Installed Directories</segtitle>
     225
     226<seglistitem>
     227<seg>clusterdb, createdb, createlang, createuser, dropdb, droplang, dropuser,
     228ecpg, initdb, ipcclean, pg_config, pg_controldata, pg_ctl, pg_dump,
     229pg_dumpall, pg_resetxlog, pg_restore, pltcl_delmod, pltcl_listmod,
     230pltcl_loadmod, postgres, postmaster, psql, vacuumdb</seg>
     231<seg>libecpg.[so,a], libecpg_compat.[so,a], libpgport.a, libpgtypes.[so,a],
     232libpq.[so,a] and various charset modules.</seg>
     233<seg>/srv/pgsql, /usr/include/libpq, /usr/include/postgresql,
     234/usr/lib/postgresql, /usr/share/doc/postgresql and /usr/share/postgresql</seg>
     235</seglistitem>
     236</segmentedlist>
     237
     238<variablelist>
     239<bridgehead renderas="sect3">Short Descriptions</bridgehead>
     240<?dbfo list-presentation="list"?>
     241
     242<varlistentry id="clusterdb">
     243<term><command>clusterdb</command></term>
     244<listitem><para>is a utility for reclustering tables in a
     245<application>Postgre<acronym>SQL</acronym></application> database.</para>
     246<indexterm zone="postgresql clusterdb">
     247<primary sortas="b-clusterdb">clusterdb</primary>
     248</indexterm></listitem>
     249</varlistentry>
     250
     251<varlistentry id="createdb">
     252<term><command>createdb</command></term>
     253<listitem><para> creates a new
     254<application>Postgre<acronym>SQL</acronym></application> database.</para>
     255<indexterm zone="postgresql createdb">
     256<primary sortas="b-createdb">createdb</primary>
     257</indexterm></listitem>
     258</varlistentry>
     259
     260<varlistentry id="createlang">
     261<term><command>createlang</command></term>
     262<listitem><para>defines a new
     263<application>Postgre<acronym>SQL</acronym></application> procedural
     264language.</para>
     265<indexterm zone="postgresql createlang">
     266<primary sortas="b-createlang">createlang</primary>
     267</indexterm></listitem>
     268</varlistentry>
     269
     270<varlistentry id="createuser">
     271<term><command>createuser</command></term>
     272<listitem><para>defines a new
     273<application>Postgre<acronym>SQL</acronym></application> user account.</para>
     274<indexterm zone="postgresql createuser">
     275<primary sortas="b-createuser">createuser</primary>
     276</indexterm></listitem>
     277</varlistentry>
     278
     279<varlistentry id="dropdb">
     280<term><command>dropdb</command></term>
     281<listitem><para>removes a
     282<application>Postgre<acronym>SQL</acronym></application> database.</para>
     283<indexterm zone="postgresql dropdb">
     284<primary sortas="b-dropdb">dropdb</primary>
     285</indexterm></listitem>
     286</varlistentry>
     287
     288<varlistentry id="droplang">
     289<term><command>droplang</command></term>
     290<listitem><para>removes a
     291<application>Postgre<acronym>SQL</acronym></application> procedural
     292language.</para>
     293<indexterm zone="postgresql droplang">
     294<primary sortas="b-droplang">droplang</primary>
     295</indexterm></listitem>
     296</varlistentry>
     297
     298<varlistentry id="dropuser">
     299<term><command>dropuser</command></term>
     300<listitem><para>removes a
     301<application>Postgre<acronym>SQL</acronym></application> user account.</para>
     302<indexterm zone="postgresql dropuser">
     303<primary sortas="b-dropuser">dropuser</primary>
     304</indexterm></listitem>
     305</varlistentry>
     306
     307<varlistentry id="ecpg">
     308<term><command>ecpg</command></term>
     309<listitem><para>is the embedded <acronym>SQL</acronym> preprocessor.</para>
     310<indexterm zone="postgresql ecpg">
     311<primary sortas="b-ecpg">ecpg</primary>
     312</indexterm></listitem>
     313</varlistentry>
     314
     315<varlistentry id="initdb">
     316<term><command>initdb</command></term>
     317<listitem><para>creates a new database cluster.</para>
     318<indexterm zone="postgresql initdb">
     319<primary sortas="b-initdb">initdb</primary>
     320</indexterm></listitem>
     321</varlistentry>
     322
     323<varlistentry id="ipcclean">
     324<term><command>ipcclean</command></term>
     325<listitem><para>removes shared memory and semaphores left over by an aborted
     326database server.</para>
     327<indexterm zone="postgresql ipcclean">
     328<primary sortas="b-ipcclean">ipcclean</primary>
     329</indexterm></listitem>
     330</varlistentry>
     331
     332<varlistentry id="pg_config">
     333<term><command>pg_config</command></term>
     334<listitem><para>retrieves
     335<application>Postgre<acronym>SQL</acronym></application> version
     336information.</para>
     337<indexterm zone="postgresql pg_config">
     338<primary sortas="b-pg_config">pg_config</primary>
     339</indexterm></listitem>
     340</varlistentry>
     341
     342<varlistentry id="pg_controldata">
     343<term><command>pg_controldata</command></term>
     344<listitem><para>returns information initialized during
     345<command>initdb</command>, such as the catalog version and server
     346locale.</para>
     347<indexterm zone="postgresql pg_controldata">
     348<primary sortas="b-pg_controldata">pg_controldata</primary>
     349</indexterm></listitem>
     350</varlistentry>
     351
     352<varlistentry id="pg_ctl">
     353<term><command>pg_ctl</command></term>
     354<listitem><para>controls stopping and starting the database server.</para>
     355<indexterm zone="postgresql pg_ctl">
     356<primary sortas="b-pg_ctl">pg_ctl</primary>
     357</indexterm></listitem>
     358</varlistentry>
     359
     360<varlistentry id="pg_dump">
     361<term><command>pg_dump</command></term>
     362<listitem><para>dumps database data and metadata into scripts which are used
     363to recreate the database.</para>
     364<indexterm zone="postgresql pg_dump">
     365<primary sortas="b-pg_dump">pg_dump</primary>
     366</indexterm></listitem>
     367</varlistentry>
     368
     369<varlistentry id="pg_dumpall">
     370<term><command>pg_dumpall</command></term>
     371<listitem><para>recursively calls <command>pg_dump</command> for each
     372database in a cluster.</para>
     373<indexterm zone="postgresql pg_dumpall">
     374<primary sortas="b-pg_dumpall">pg_dumpall</primary>
     375</indexterm></listitem>
     376</varlistentry>
     377
     378<varlistentry id="pg_resetxlog">
     379<term><command>pg_resetxlog</command></term>
     380<listitem><para>clears the write-ahead log and optionally resets some
     381fields in the <filename>pg_control</filename> file.</para>
     382<indexterm zone="postgresql pg_resetxlog">
     383<primary sortas="b-pg_resetxlog">pg_resetxlog</primary>
     384</indexterm></listitem>
     385</varlistentry>
     386
     387<varlistentry id="pg_restore">
     388<term><command>pg_restore</command></term>
     389<listitem><para>creates databases from dump files created by
     390<command>pg_dump</command>.</para>
     391<indexterm zone="postgresql pg_restore">
     392<primary sortas="b-pg_restore">pg_restore</primary>
     393</indexterm></listitem>
     394</varlistentry>
     395
     396<varlistentry id="pltcl_delmod">
     397<term><command>pltcl_delmod</command></term>
     398<listitem><para>is a support script used to delete a module from a
     399<acronym>PL</acronym>/<application>Tcl</application> table. The command
     400requires the <application><ulink
     401url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink></application>
     402package to be installed also.</para>
     403<indexterm zone="postgresql pltcl_delmod">
     404<primary sortas="b-pltcl_delmod">pltcl_delmod</primary>
     405</indexterm></listitem>
     406</varlistentry>
     407
     408<varlistentry id="pltcl_listmod">
     409<term><command>pltcl_listmod</command></term>
     410<listitem><para>is a support script used to list the modules in a
     411<acronym>PL</acronym>/<application>Tcl</application> table. The command
     412requires the <application><ulink
     413url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink></application>
     414package to be installed also.</para>
     415<indexterm zone="postgresql pltcl_listmod">
     416<primary sortas="b-pltcl_listmod">pltcl_listmod</primary>
     417</indexterm></listitem>
     418</varlistentry>
     419
     420<varlistentry id="pltcl_loadmod">
     421<term><command>pltcl_loadmod</command></term>
     422<listitem><para>is a support script used to load a module into a
     423<acronym>PL</acronym>/<application>Tcl</application> table. The command
     424requires the <application><ulink
     425url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink></application>
     426package to be installed also.</para>
     427<indexterm zone="postgresql pltcl_loadmod">
     428<primary sortas="b-pltcl_loadmod">pltcl_loadmod</primary>
     429</indexterm></listitem>
     430</varlistentry>
     431
     432<varlistentry id="postgres">
     433<term><command>postgres</command></term>
     434<listitem><para>is a single user database server, generally used for
     435debugging.</para>
     436<indexterm zone="postgresql postgres">
     437<primary sortas="b-postgres">postgres</primary>
     438</indexterm></listitem>
     439</varlistentry>
     440
     441<varlistentry id="postmaster">
     442<term><command>postmaster</command></term>
     443<listitem><para>is a multi-user database daemon.</para>
     444<indexterm zone="postgresql postmaster">
     445<primary sortas="b-postmaster">postmaster</primary>
     446</indexterm></listitem>
     447</varlistentry>
     448
     449<varlistentry id="psql">
     450<term><command>psql</command></term>
     451<listitem><para>is a console based database shell.</para>
     452<indexterm zone="postgresql psql">
     453<primary sortas="b-psql">psql</primary>
     454</indexterm></listitem>
     455</varlistentry>
     456
     457<varlistentry id="vacuumdb">
     458<term><command>vacuumdb</command></term>
     459<listitem><para>compacts databases and generates statistics for the query
     460analyzer.</para>
     461<indexterm zone="postgresql vacuumdb">
     462<primary sortas="b-vacuumdb">vacuumdb</primary>
     463</indexterm></listitem>
     464</varlistentry>
     465</variablelist>
    229466
    230467</sect2>
    231468
    232 <sect2><title>Description</title>
    233 
    234 <sect3><title>clusterdb</title>
    235 <para><command>clusterdb</command> is a utility for reclustering tables
    236 in a <application>Postgre<acronym>SQL</acronym></application>
    237 database.</para></sect3>
    238 
    239 <sect3><title>createdb</title>
    240 <para><command>createdb</command> creates a new
    241 <application>Postgre<acronym>SQL</acronym></application> database.</para>
    242 </sect3>
    243 
    244 <sect3><title>createlang</title>
    245 <para><command>createlang</command> defines a new
    246 <application>Postgre<acronym>SQL</acronym></application> procedural
    247 language.</para></sect3>
    248 
    249 <sect3><title>createuser</title>
    250 <para><command>createuser</command> defines a new
    251 <application>Postgre<acronym>SQL</acronym></application> user account.</para>
    252 </sect3>
    253 
    254 <sect3><title>dropdb</title>
    255 <para><command>dropdb</command> removes a
    256 <application>Postgre<acronym>SQL</acronym></application> database.</para>
    257 </sect3>
    258 
    259 <sect3><title>droplang</title>
    260 <para><command>droplang</command> removes a
    261 <application>Postgre<acronym>SQL</acronym></application> procedural
    262 language.</para></sect3>
    263 
    264 <sect3><title>dropuser</title>
    265 <para><command>dropuser</command> removes a
    266 <application>Postgre<acronym>SQL</acronym></application> user account.</para>
    267 </sect3>
    268 
    269 <sect3><title>ecpg</title>
    270 <para><command>ecpg</command> is the embedded <acronym>SQL</acronym>
    271 preprocessor.</para></sect3>
    272 
    273 <sect3><title>initdb</title>
    274 <para><command>initdb</command> create a new database cluster.</para></sect3>
    275 
    276 <sect3><title>initlocation</title>
    277 <para><command>initlocation</command> creates a secondary database storage
    278 area.</para></sect3>
    279 
    280 <sect3><title>ipcclean</title>
    281 <para><command>ipcclean</command> removes shared memory and semaphores left
    282 over by an aborted database server.</para></sect3>
    283 
    284 <sect3><title>pg_config</title>
    285 <para><command>pg_config</command> retrieves
    286 <application>Postgre<acronym>SQL</acronym></application> version
    287 information.</para></sect3>
    288 
    289 <sect3><title>pg_controldata</title>
    290 <para><command>pg_controldata</command> returns information initialized during
    291 <command>initdb</command>, such as the catalog version and server
    292 locale.</para></sect3>
    293 
    294 <sect3><title>pg_ctl</title>
    295 <para><command>pg_ctl</command> controls stopping and starting the database
    296 server.</para></sect3>
    297 
    298 <sect3><title>pg_dump</title>
    299 <para><command>pg_dump</command> dumps database data and metadata into scripts
    300 which are used to recreate the database.</para></sect3>
    301 
    302 <sect3><title>pg_dumpall</title>
    303 <para><command>pg_dumpall</command> recursively calls
    304 <command>pg_dump</command> for each database in a
    305 cluster.</para></sect3>
    306 
    307 <sect3><title>pg_resetxlog</title>
    308 <para><command>pg_resetxlog</command> clears the write-ahead log and optionally
    309 resets some fields in the <filename>pg_control</filename> file.</para></sect3>
    310 
    311 <sect3><title>pg_restore</title>
    312 <para><command>pg_restore</command> creates databases from dump files created by
    313 <command>pg_dump</command>.</para></sect3>
    314 
    315 <sect3><title>pgtclsh</title>
    316 <para><command>pgtclsh</command> is a <application>Tcl</application>
    317 shell interface extended with
    318 <application>Postgre<acronym>SQL</acronym></application> database access
    319 functions.</para></sect3>
    320 
    321 <sect3><title>pgtksh</title>
    322 <para><command>pgtksh</command> is a
    323 <application>Tcl</application>/<application>Tk</application> shell
    324 interface extended with
    325 <application>Postgre<acronym>SQL</acronym></application> database access
    326 functions.</para></sect3>
    327 
    328 <sect3><title>postgres</title>
    329 <para><command>postgres</command> is a single user database server, generally
    330 used for debugging.</para></sect3>
    331 
    332 <sect3><title>postmaster</title>
    333 <para><command>postmaster</command> is the multi-user database daemon.</para>
    334 </sect3>
    335 
    336 <sect3><title>psql</title>
    337 <para><command>psql</command> is a console based database shell.</para></sect3>
    338 
    339 <sect3><title>vacuumdb</title>
    340 <para><command>vacuumdb</command> compacts databases and generates statistics
    341 for the query analyzer.</para></sect3>
    342 
    343 </sect2>
    344 
    345469</sect1>
  • general.ent

    r28da027b r44e4099  
    1 <!ENTITY day          "07">
     1<!ENTITY day          "08">
    22<!ENTITY month        "04">
    33<!ENTITY year         "2005">
     
    262262<!ENTITY db-version                   "4.3.27"> 
    263263<!ENTITY mysql-version                "4.1.10a">   
    264 <!ENTITY postgresql-version           "7.4.6">
     264<!ENTITY postgresql-version           "8.0.1">
    265265                                     
    266266<!-- Chapter 24 -->                 
  • general/sysutils/apache-ant.xml

    r28da027b r44e4099  
    99  <!ENTITY apache-ant-md5sum        "83c3adefdbf90bcbc4b804d4c55c0778">
    1010  <!ENTITY apache-ant-size          "6.2 MB">
    11   <!ENTITY apache-ant-buildsize     "90 MB">
     11  <!ENTITY apache-ant-buildsize     "92 MB">
    1212  <!ENTITY apache-ant-time          "0.47 SBU">
    1313]>
     
    247247</indexterm></listitem>
    248248</varlistentry>
    249 
    250249</variablelist>
    251250
  • introduction/welcome/changelog.xml

    r28da027b r44e4099  
    2222
    2323<itemizedlist>
     24
     25<listitem><para>April 8th, 2005 [randy]: Updated to
     26PostgreSQL-8.0.1.</para></listitem>
    2427
    2528<listitem><para>April 7th, 2005 [randy]: Updated the JadeTex instructions
Note: See TracChangeset for help on using the changeset viewer.