r5423 - in trunk/BOOK: . introduction/welcome postlfs/config server/databases

randy at linuxfromscratch.org randy at linuxfromscratch.org
Wed Dec 14 04:29:08 PST 2005


Author: randy
Date: 2005-12-14 05:29:05 -0700 (Wed, 14 Dec 2005)
New Revision: 5423

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

Modified: trunk/BOOK/general.ent
===================================================================
--- trunk/BOOK/general.ent	2005-12-14 09:41:26 UTC (rev 5422)
+++ trunk/BOOK/general.ent	2005-12-14 12:29:05 UTC (rev 5423)
@@ -307,7 +307,7 @@
 <!-- End special note about Heimdal -->
 
 <!ENTITY mysql-version                "5.0.16">
-<!ENTITY postgresql-version           "8.0.3">
+<!ENTITY postgresql-version           "8.1.1">
 
 <!-- Chapter 24 -->
 <!-- dhcp (chapter 14) -->

Modified: trunk/BOOK/introduction/welcome/changelog.xml
===================================================================
--- trunk/BOOK/introduction/welcome/changelog.xml	2005-12-14 09:41:26 UTC (rev 5422)
+++ trunk/BOOK/introduction/welcome/changelog.xml	2005-12-14 12:29:05 UTC (rev 5423)
@@ -42,6 +42,15 @@
 -->
 
     <listitem>
+      <para>December 14th, 2005</para>
+      <itemizedlist>
+        <listitem>
+          <para>[randy] - Updated to PostgreSQL-8.1.1.</para>
+        </listitem>
+      </itemizedlist>
+    </listitem>
+
+    <listitem>
       <para>December 13th, 2005</para>
       <itemizedlist>
         <listitem>

Modified: trunk/BOOK/postlfs/config/users.xml
===================================================================
--- trunk/BOOK/postlfs/config/users.xml	2005-12-14 09:41:26 UTC (rev 5422)
+++ trunk/BOOK/postlfs/config/users.xml	2005-12-14 12:29:05 UTC (rev 5423)
@@ -81,7 +81,7 @@
         <row><entry>vmailman</entry><entry>35</entry><entry>35</entry></row>
         <row><entry>news    </entry><entry>36</entry><entry>36</entry></row>
         <row><entry>mysql   </entry><entry>40</entry><entry>40</entry></row>
-        <row><entry>postgres</entry><entry>41</entry><entry>  </entry></row>
+        <row><entry>postgres</entry><entry>41</entry><entry>41</entry></row>
         <row><entry>ftp     </entry><entry>45</entry><entry>45</entry></row>
         <row><entry>proftpd </entry><entry>46</entry><entry>46</entry></row>
         <row><entry>vsftpd  </entry><entry>47</entry><entry>47</entry></row>

Modified: trunk/BOOK/server/databases/postgresql.xml
===================================================================
--- trunk/BOOK/server/databases/postgresql.xml	2005-12-14 09:41:26 UTC (rev 5422)
+++ trunk/BOOK/server/databases/postgresql.xml	2005-12-14 12:29:05 UTC (rev 5423)
@@ -6,10 +6,10 @@
 
   <!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-md5sum        "c0914a133ce6c1e0f1d8b93982d6e881">
-  <!ENTITY postgresql-size          "11.0 MB">
-  <!ENTITY postgresql-buildsize     "139 MB (additional 110 MB to run the testsuite)">
-  <!ENTITY postgresql-time          "1.12 SBU">
+  <!ENTITY postgresql-md5sum        "d22d7bd1d5e5f9aa89d574ff66e2c8bb">
+  <!ENTITY postgresql-size          "11.5 MB">
+  <!ENTITY postgresql-buildsize     "153 MB (additional 100 MB to run the testsuite)">
+  <!ENTITY postgresql-time          "1.4 SBU">
 ]>
 
 <sect1 id="postgresql" xreflabel="PostgreSQL-&postgresql-version;">
@@ -59,15 +59,6 @@
       </listitem>
     </itemizedlist>
 
-<!--
-<sect3><title>Additional downloads</title>
-<itemizedlist spacing='compact'>
-<listitem><para>Required patch: <ulink
-url="&patch-root;/postgresql-&postgresql-version;-dsssl_fix-1.patch"/></para>
-</listitem></itemizedlist>
-</sect3>
- -->
-
     <bridgehead renderas="sect3">PostgreSQL Dependencies</bridgehead>
 
     <bridgehead renderas="sect4">Optional</bridgehead>
@@ -75,39 +66,25 @@
     <xref linkend="tcl"/>,
     <xref linkend="openssl"/>,
     <xref linkend="linux-pam"/>,
-    <xref linkend="sgml-dtd"/>,
-    <xref linkend="docbook-dsssl"/>,
-    <xref linkend="openjade"/>,
-    <xref linkend="perl-sgmlspm"/>,
     <ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink>,
     <xref linkend="mitkrb"/> or <xref linkend="heimdal"/>, and
-    <ulink url="http://rendezvous.sourceforge.net/">Rendezvous</ulink></para>
+    <ulink url="http://developer.apple.com/networking/bonjour/">Bonjour</ulink></para>
 
+    <bridgehead renderas="sect4">Optional (To Regenerate Documentation)</bridgehead>
+    <para role="optional"><xref linkend="sgml-dtd"/>,
+    <xref linkend="docbook-dsssl"/>,
+    <xref linkend="openjade"/>, and
+    <xref linkend="perl-sgmlspm"/></para>
+
   </sect2>
 
   <sect2 role="installation">
     <title>Installation of PostgreSQL</title>
 
-<!-- Disabling obsolete text
-
-    <para>In order for <command>configure</command> to properly discover
-    <application>Docbook SGML DTD</application>, you may need to remove
-    <application>OpenSP</application> catalog definitions from the system
-    SGML catalogs. Use the following command before building the package
-    to accomplish this:</para>
-
-<screen role="root"><userinput>sed -i.orig \
-    -e "/CATALOG \/etc\/sgml\/OpenSP-1.5.1.cat/d" \
-    /etc/sgml/catalog \
-    /etc/sgml/sgml-docbook.cat</userinput></screen>
-
--->
-
     <para>Install <application>PostgreSQL</application> with the
     following commands: </para>
 
-<screen><userinput>sed -i \
-    -e "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-&docbook-dsssl-version;|" \
+<screen><userinput>sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-&docbook-dsssl-version;|" \
     configure &&
 ./configure --prefix=/usr --enable-thread-safety &&
 make</userinput></screen>
@@ -117,22 +94,19 @@
     <para>Now, as the <systemitem class="username">root</systemitem> user:</para>
 
 <screen role="root"><userinput>make install &&
-chown -v root:root /usr/share/doc/postgresql/html</userinput></screen>
+chown -v root:root /usr/share/doc/postgresql/html/* &&
+install -v -m755 -d /usr/share/doc/postgresql/{FAQ/html,TODO.detail} &&
+install -v -m644 doc/TODO /usr/share/doc/postgresql &&
+install -v -m644 doc/FAQ* /usr/share/doc/postgresql/FAQ &&
+install -v -m644 doc/src/FAQ/* /usr/share/doc/postgresql/FAQ/html &&
+install -v -m644 doc/TODO.detail/* \
+    /usr/share/doc/postgresql/TODO.detail</userinput></screen>
 
-<!--
-<para>The standard installation provides only the header files needed
-for client application development. Server-side applications require
-the entire <application>PostgreSQL</application>
-include tree which can be installed using the following command:</para>
-
-<screen><userinput><command>make install-all-headers</command></userinput></screen>
- -->
-
     <note>
       <para>If you are upgrading an existing system and are going to install
       the new files over the old ones, then you should back up your data, shut
       down the old server and follow the instructions in <ulink
-      url="http://www.postgresql.org/docs/8.0/static/install-upgrading.html">the
+      url="http://www.postgresql.org/docs/8.1/static/install-upgrading.html">the
       official <application>PostgreSQL</application> documentation</ulink>.</para>
     </note>
 
@@ -140,7 +114,8 @@
     <systemitem class="username">root</systemitem> user:</para>
 
 <screen role="root"><userinput>install -v -m755 -d /srv/pgsql/data &&
-useradd -c "PostgreSQL Server" -g users -d /srv/pgsql/data \
+groupadd -g 41 postgres &&
+useradd -c "PostgreSQL Server" -g postgres -d /srv/pgsql/data \
         -u 41 postgres &&
 chown -v postgres /srv/pgsql/data &&
 su - postgres -c '/usr/bin/initdb -D /srv/pgsql/data'</userinput></screen>
@@ -170,21 +145,21 @@
   <sect2 role="commands">
     <title>Command Explanations</title>
 
-    <para><command>sed -i -e "s|dsssl-stylesheets|..."</command>: This command
+    <para><command>sed -i "s|dsssl-stylesheets|..."</command>: This command
     puts an extra line in the <command>configure</command> script so that the
-    BLFS installed version of the DSSSL stylesheets can be discovered.</para>
+    BLFS installed version of the DSSSL stylesheets are discovered.</para>
 
     <para><parameter>--enable-thread-safety</parameter>: This switch makes the
     client libraries thread-safe by allowing concurrent threads in
     <filename class='libraryfile'>libpq</filename> and ECPG programs to safely
     control their private connection handles.</para>
 
-    <para><command>chown -R root:root /usr/share/doc/postgresql/html</command>:
-    This command corrects the improper ownership of some documentation
-    files.</para>
+    <para><command>chown -R root:root /usr/share/doc/postgresql/html/*</command>:
+    This command corrects the improper ownership of documentation files.</para>
 
-    <para><command>useradd ...</command>: Add an unprivileged user to run the
-    database server.</para>
+    <para><command>groupadd ...</command>; <command>useradd ...</command>:
+    These commands add an unprivileged user and group to run the database
+    server.</para>
 
     <para><command>createdb test; create table t1; insert into t1 values...;
     select * from t1</command>: Create a database, add a table to it, insert




More information about the blfs-book mailing list