r6658 - in trunk/BOOK: . introduction/welcome server/databases

djensen at linuxfromscratch.org djensen at linuxfromscratch.org
Sat Mar 3 16:32:59 PST 2007


Author: djensen
Date: 2007-03-03 17:32:59 -0700 (Sat, 03 Mar 2007)
New Revision: 6658

Modified:
   trunk/BOOK/general.ent
   trunk/BOOK/introduction/welcome/changelog.xml
   trunk/BOOK/server/databases/postgresql.xml
Log:
Updated to PostgreSQL-8.2.3

Modified: trunk/BOOK/general.ent
===================================================================
--- trunk/BOOK/general.ent	2007-03-03 11:48:20 UTC (rev 6657)
+++ trunk/BOOK/general.ent	2007-03-04 00:32:59 UTC (rev 6658)
@@ -350,7 +350,7 @@
 <!-- End special note about Heimdal -->
 
 <!ENTITY mysql-version                "5.0.21">
-<!ENTITY postgresql-version           "8.1.3">
+<!ENTITY postgresql-version           "8.2.3">
 
 <!-- Chapter 24 -->
 <!-- dhcp (chapter 14) -->

Modified: trunk/BOOK/introduction/welcome/changelog.xml
===================================================================
--- trunk/BOOK/introduction/welcome/changelog.xml	2007-03-03 11:48:20 UTC (rev 6657)
+++ trunk/BOOK/introduction/welcome/changelog.xml	2007-03-04 00:32:59 UTC (rev 6658)
@@ -44,6 +44,9 @@
       <para>March 3rd, 2007</para>
       <itemizedlist>
         <listitem>
+          <para>[djensen] - Updated to PostgreSQL-8.2.3.</para>
+        </listitem>
+        <listitem>
           <para>[alexander] - Removed the link to the (dead) libstk
           site from Xine Libraries page.</para>
         </listitem>

Modified: trunk/BOOK/server/databases/postgresql.xml
===================================================================
--- trunk/BOOK/server/databases/postgresql.xml	2007-03-03 11:48:20 UTC (rev 6657)
+++ trunk/BOOK/server/databases/postgresql.xml	2007-03-04 00:32:59 UTC (rev 6658)
@@ -6,12 +6,12 @@
 
   <!-- <!ENTITY postgresql-download-http "http://gd.tuwien.ac.at/db/postgresql/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> -->
   <!-- <!ENTITY postgresql-download-ftp  "ftp://ftp.fr.postgresql.org/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> -->
-  <!ENTITY postgresql-download-http "&sources-anduin-http;/p/postgresql-&postgresql-version;.tar.bz2">
-  <!ENTITY postgresql-download-ftp  "ftp://ftp-archives.postgresql.org/pub/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
-  <!ENTITY postgresql-md5sum        "bb510edbb533962c0692e211b3bd8cfa">
-  <!ENTITY postgresql-size          "11.5 MB">
-  <!ENTITY postgresql-buildsize     "153 MB (additional 100 MB to run the testsuite)">
-  <!ENTITY postgresql-time          "1.7 SBU">
+  <!ENTITY postgresql-download-http " ">
+  <!ENTITY postgresql-download-ftp  "ftp://ftp5.us.postgresql.org/pub/PostgreSQL/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
+  <!ENTITY postgresql-md5sum        "cb47771004d53505200ffd00ac45bc32">
+  <!ENTITY postgresql-size          "12.2 MB">
+  <!ENTITY postgresql-buildsize     "129 MB (additional 119 MB to run the testsuite)">
+  <!ENTITY postgresql-time          "1.4 SBU">
 ]>
 
 <sect1 id="postgresql" xreflabel="PostgreSQL-&postgresql-version;">
@@ -114,7 +114,7 @@
     <para>Initialize a database cluster with the following commands issued by the
     <systemitem class="username">root</systemitem> user:</para>
 
-<screen role="root"><userinput>install -v -m755 -d /srv/pgsql/data &&
+<screen role="root"><userinput>install -v -m700 -d /srv/pgsql/data &&
 groupadd -g 41 postgres &&
 useradd -c "PostgreSQL Server" -g postgres -d /srv/pgsql/data \
         -u 41 postgres &&
@@ -231,8 +231,8 @@
         <seg>clusterdb, createdb, createlang, createuser, dropdb, droplang,
         dropuser, ecpg, initdb, ipcclean, pg_config, pg_controldata, pg_ctl,
         pg_dump, pg_dumpall, pg_resetxlog, pg_restore, pltcl_delmod,
-        pltcl_listmod, pltcl_loadmod, postgres, postmaster, psql, and
-        vacuumdb</seg>
+        pltcl_listmod, pltcl_loadmod, postgres, postmaster, psql,
+        reindexdb, and vacuumdb</seg>
         <seg>libecpg.{so,a}, libecpg_compat.{so,a}, libpgport.a, libpgtypes.{so,a},
         libpq.{so,a}, and various charset modules.</seg>
         <seg>/srv/pgsql, /usr/include/libpq, /usr/include/postgresql,
@@ -503,6 +503,16 @@
         </listitem>
       </varlistentry>
 
+       <varlistentry id="reindexdb">
+        <term><command>reindexdb</command></term>
+        <listitem>
+          <para>is a utility for rebuilding indexes in a database.</para>
+          <indexterm zone="postgresql psql">
+            <primary sortas="b-psql">psql</primary>
+          </indexterm>
+        </listitem>
+      </varlistentry>
+
       <varlistentry id="vacuumdb">
         <term><command>vacuumdb</command></term>
         <listitem>




More information about the blfs-book mailing list