r2858 - in trunk: BOOK BOOK/content/databases BOOK/introduction/welcome bootscripts bootscripts/blfs/init.d patches

randy at linuxfromscratch.org randy at linuxfromscratch.org
Fri Oct 22 22:51:07 PDT 2004


Author: randy
Date: 2004-10-22 23:51:06 -0600 (Fri, 22 Oct 2004)
New Revision: 2858

Added:
   trunk/patches/postgresql-7.4.5-dsssl_fix-1.patch
Modified:
   trunk/BOOK/content/databases/postgresql.xml
   trunk/BOOK/general.ent
   trunk/BOOK/introduction/welcome/changelog.xml
   trunk/bootscripts/ChangeLog
   trunk/bootscripts/blfs/init.d/postgresql
Log:
Updated to PostgreSQL-7.4.6

Modified: trunk/BOOK/content/databases/postgresql.xml
===================================================================
--- trunk/BOOK/content/databases/postgresql.xml	2004-10-21 05:52:33 UTC (rev 2857)
+++ trunk/BOOK/content/databases/postgresql.xml	2004-10-23 05:51:06 UTC (rev 2858)
@@ -6,8 +6,9 @@
 
   <!ENTITY postgresql-download-http "http://gd.tuwien.ac.at/db/postgresql/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
   <!ENTITY postgresql-download-ftp  "ftp://ftp.fr.postgresql.org/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
-  <!ENTITY postgresql-size          "9.7 MB">
-  <!ENTITY postgresql-buildsize     "197 MB">
+  <!ENTITY postgresql-md5sum        "f0ea2b372a7bdaf2613e92176ebf5e0f">
+  <!ENTITY postgresql-size          "10.2 MB">
+  <!ENTITY postgresql-buildsize     "236 MB">
   <!ENTITY postgresql-time          "1.21 SBU">
 ]>
 
@@ -31,11 +32,19 @@
 <itemizedlist spacing='compact'>
 <listitem><para>Download (HTTP): <ulink url="&postgresql-download-http;"/></para></listitem>
 <listitem><para>Download (FTP): <ulink url="&postgresql-download-ftp;"/></para></listitem>
+<listitem><para>MD5 sum: &postgresql-md5sum;</para></listitem>
 <listitem><para>Download size: &postgresql-size;</para></listitem>
-<listitem><para>Estimated Disk space required: &postgresql-buildsize;</para></listitem>
+<listitem><para>Estimated disk space required: &postgresql-buildsize;</para></listitem>
 <listitem><para>Estimated build time: &postgresql-time;</para></listitem></itemizedlist>
 </sect3>
 
+<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>
+
 <sect3><title><application>Postgre<acronym>SQL</acronym></application> 
 dependencies</title>
 <sect4><title>Optional</title>
@@ -45,7 +54,8 @@
 <xref linkend="tk"/>,
 <xref linkend="openssl"/>,
 <xref linkend="Linux_PAM"/>,
-<xref linkend="opensp"/>,
+<xref linkend="sgml-dtd-3"/>, 
+<xref linkend="docbook-dsssl"/>,
 <xref linkend="openjade"/>,
 <xref linkend="perl-modules"/>: SGMLSpm-&SGMLSpm-version;, 
 <ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink>,
@@ -61,10 +71,23 @@
 <title>Installation of <application>Postgre<acronym>SQL</acronym></application>
 </title>
 
+<para>In order for <command>configure</command> to properly discover 
+<application>Docbook <acronym>SGML</acronym> 
+<acronym>DTD</acronym></application> (v3.1), you may need to remove 
+<application>OpenSP</application> catalog definitions from the system 
+<acronym>SGML</acronym> catalogs. Use the following command before building 
+the package to accomplish this:</para>
+
+<screen><userinput><command>sed -i.orig \
+    -e "/CATALOG \/etc\/sgml\/OpenSP-1.5.1.cat/d" \
+    /etc/sgml/catalog \
+    /etc/sgml/sgml-docbook.cat</command></userinput></screen>
+
 <para>Install <application>Postgre<acronym>SQL</acronym></application> with the 
 following commands: </para>
 
-<screen><userinput><command>./configure --prefix=/usr &&
+<screen><userinput><command>patch -Np1 -i ../postgresql-&postgresql-version;-dsssl_fix-1.patch &&
+./configure --prefix=/usr --enable-thread-safety &&
 make &&
 make install &&
 chown -R root:root /usr/share/doc/postgresql/html</command></userinput></screen>
@@ -114,11 +137,17 @@
 <sect2>
 <title>Command explanations</title>
 
+<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 <acronym>ECPG</acronym> 
+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>useradd -d /srv/pgsql/data postgres</command>: Add an unprivileged user to run the database server.</para>
+<para><command>useradd -d /srv/pgsql/data postgres</command>: Add an 
+unprivileged user 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 some 

Modified: trunk/BOOK/general.ent
===================================================================
--- trunk/BOOK/general.ent	2004-10-21 05:52:33 UTC (rev 2857)
+++ trunk/BOOK/general.ent	2004-10-23 05:51:06 UTC (rev 2858)
@@ -1,8 +1,8 @@
-<!ENTITY day          "21">
+<!ENTITY day          "23">
 <!ENTITY month        "10">
 <!ENTITY year         "2004">
 <!ENTITY version      "svn-&year;&month;&day;">
-<!ENTITY releasedate  "October &day;st, &year;">
+<!ENTITY releasedate  "October &day;rd, &year;">
 <!ENTITY pubdate      "&year;-&month;-&day;"> <!-- metadata req. by TLDP -->
 <!ENTITY blfs-version "cvs">                  <!-- cvs|[release #] -->
 <!ENTITY lfs-version  "testing">              <!-- stable|testing|unstable] -->
@@ -219,7 +219,7 @@
 <!ENTITY db-version                   "4.2.52.2">  
 <!ENTITY db-3.3-version               "3.3.11">  
 <!ENTITY mysql-version                "4.0.21">   
-<!ENTITY postgresql-version           "7.4.3"> 
+<!ENTITY postgresql-version           "7.4.6"> 
                                      
 <!-- Chapter 24 -->                  
 <!ENTITY apache-version               "2.0.52">  

Modified: trunk/BOOK/introduction/welcome/changelog.xml
===================================================================
--- trunk/BOOK/introduction/welcome/changelog.xml	2004-10-21 05:52:33 UTC (rev 2857)
+++ trunk/BOOK/introduction/welcome/changelog.xml	2004-10-23 05:51:06 UTC (rev 2858)
@@ -22,6 +22,9 @@
 
 <itemizedlist>
 
+<listitem><para>October 23rd, 2004 [randy]: Updated to
+PostgreSQL-7.4.6.</para></listitem>
+
 <listitem><para>October 21st, 2004 [randy]: Updated to
 cURL-7.12.2.</para></listitem>
 

Modified: trunk/bootscripts/ChangeLog
===================================================================
--- trunk/bootscripts/ChangeLog	2004-10-21 05:52:33 UTC (rev 2857)
+++ trunk/bootscripts/ChangeLog	2004-10-23 05:51:06 UTC (rev 2858)
@@ -1,3 +1,7 @@
+2004-10-23 Randy McMurchy <randy at linuxfromscratch.org>
+	* Modified PostgreSQL script because the pg_ctl script
+	  is no longer able to run as user root.
+
 2004-10-20 DJ Lucas <dj at linuxfromscratch.org>
 	* Added ability to print assigned addresses when using
 	  dhcpcd service script.

Modified: trunk/bootscripts/blfs/init.d/postgresql
===================================================================
--- trunk/bootscripts/blfs/init.d/postgresql	2004-10-21 05:52:33 UTC (rev 2857)
+++ trunk/bootscripts/blfs/init.d/postgresql	2004-10-23 05:51:06 UTC (rev 2858)
@@ -20,7 +20,7 @@
 
 	stop)
 		echo "Stopping PostgreSQL daemon..."
-		/usr/bin/pg_ctl stop -m smart -D /srv/pgsql/data
+		su - postgres -c "/usr/bin/pg_ctl stop -m smart -D /srv/pgsql/data"
 		evaluate_retval
 		;;
 
@@ -31,7 +31,7 @@
 		;;
 
 	status)
-		/usr/bin/pg_ctl status -D /srv/pgsql/data
+		su - postgres -c "/usr/bin/pg_ctl status -D /srv/pgsql/data"
 		;;
 
 	*)

Added: trunk/patches/postgresql-7.4.5-dsssl_fix-1.patch
===================================================================
--- trunk/patches/postgresql-7.4.5-dsssl_fix-1.patch	2004-10-21 05:52:33 UTC (rev 2857)
+++ trunk/patches/postgresql-7.4.5-dsssl_fix-1.patch	2004-10-23 05:51:06 UTC (rev 2858)
@@ -0,0 +1,26 @@
+Submitted By: Nico R. <n-roeser at gmx.net>
+Date: 2004-10-15
+Initial Package Version: 7.4.5
+Upstream Status: Not submitted - LFS Specific
+Origin: Nico R.
+Description: Allows the PostgreSQL configure script to find the DocBook DSSSL
+             Stylesheets-1.78 at the location where the BLFS book installs them.
+             This patch is marked as "LFS Specific" at the moment, because some
+             discussion is needed about the correct way to handle this problem.
+
+$LastChangedBy$
+$Date$
+
+diff -Naur postgresql-7.4.5.orig/configure postgresql-7.4.5/configure
+--- postgresql-7.4.5.orig/configure	2004-08-18 03:11:24.000000000 +0000
++++ postgresql-7.4.5/configure	2004-10-15 08:33:08.000000000 +0000
+@@ -17537,7 +17537,8 @@
+         sgml/stylesheets/docbook \
+         sgml/docbook/dsssl/modular \
+         sgml/docbook/stylesheet/dsssl/modular \
+-        sgml/docbook/dsssl-stylesheets
++        sgml/docbook/dsssl-stylesheets \
++        sgml/docbook/dsssl-stylesheets-1.78
+       do
+         pgac_candidate=$pgac_prefix/$pgac_infix/$pgac_postfix
+         if test -r "$pgac_candidate/html/docbook.dsl" \


Property changes on: trunk/patches/postgresql-7.4.5-dsssl_fix-1.patch
___________________________________________________________________
Name: svn:keywords
   + LastChangedBy Date




More information about the blfs-book mailing list