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>
--
http://linuxfromscratch.org/mailman/listinfo/blfs-book
FAQ: http://www.linuxfromscratch.org/blfs/faq.html
Unsubscribe: See the above information page