cvs commit: BLFS/BOOK/content/databases/postgresql postgresql-config.xml postgresql-desc.xml postgresql-inst.xml postgresql-intro.xml postgresql.ent

igor at linuxfromscratch.org igor at linuxfromscratch.org
Sun Feb 8 09:08:32 PST 2004


igor        04/02/08 10:08:32

  Modified:    BOOK/content/databases/postgresql postgresql-config.xml
                        postgresql-desc.xml postgresql-inst.xml
                        postgresql-intro.xml postgresql.ent
  Log:
  postgresql corrections
  
  Revision  Changes    Path
  1.3       +2 -2      BLFS/BOOK/content/databases/postgresql/postgresql-config.xml
  
  Index: postgresql-config.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/content/databases/postgresql/postgresql-config.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- postgresql-config.xml	8 Feb 2004 00:50:22 -0000	1.2
  +++ postgresql-config.xml	8 Feb 2004 17:08:32 -0000	1.3
  @@ -29,7 +29,7 @@
   case "$1" in
           start)
                   echo "Starting PostgreSQL daemon..."
  -		su - postgres -c '/usr/bin/pg_ctl start -W -D /var/pgsql/data \
  +                su - postgres -c '/usr/bin/pg_ctl start -W -D /var/pgsql/data \
                                  -l /var/pgsql/data/logfile -o "-i" '
                   evaluate_retval
                   ;;
  @@ -37,7 +37,7 @@
           stop)
                   echo "Stopping PostgreSQL daemon..."
                   /usr/bin/pg_ctl stop -m smart -D /var/pgsql/data
  -		evaluate_retval
  +                evaluate_retval
                   ;;
   
           restart)
  
  
  
  1.2       +20 -0     BLFS/BOOK/content/databases/postgresql/postgresql-desc.xml
  
  Index: postgresql-desc.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/content/databases/postgresql/postgresql-desc.xml,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- postgresql-desc.xml	6 Oct 2003 09:07:10 -0000	1.1
  +++ postgresql-desc.xml	8 Feb 2004 17:08:32 -0000	1.2
  @@ -22,11 +22,18 @@
   <command>pg_id</command>,
   <command>pg_resetxlog</command>,
   <command>pg_restore</command>,
  +<command>pgtclsh</command>,
  +<command>pgtksh</command>,
  +<command>pltcl_delmod</command>,
  +<command>pltcl_listmod</command>,
  +<command>pltcl_loadmod</command>,
   <command>postgres</command>,
   <command>postmaster</command>,
   <command>psql</command>,
   <command>vacuumdb</command>,
   <filename class="libraryfile">libecpg</filename>,
  +<filename class="libraryfile">libpgtcl</filename>,
  +<filename class="libraryfile">libpgtypes</filename>,
   <filename class="libraryfile">libpq</filename> and various charset
   modules.</para>
   
  @@ -109,6 +116,19 @@
   <sect3><title>pg_restore</title>
   <para><command>pg_restore</command> creates databases from dump files created by
   <command>pg_dump</command>.</para></sect3>
  +
  +<sect3><title>pgtclsh</title>
  +<para><command>pgtclsh</command> is a <application>Tcl</application>
  +shell interface extended with
  +<application>Postgre<acronym>SQL</acronym></application> database access
  +functions.</para></sect3>
  +
  +<sect3><title>pgtksh</title>
  +<para><command>pgtksh</command> is a
  +<application>Tcl</application>/<application>Tk</application> shell
  +interface extended with
  +<application>Postgre<acronym>SQL</acronym></application> database access
  +functions.</para></sect3>
   
   <sect3><title>postgres</title>
   <para><command>postgres</command> is a single user database server, generally used for
  
  
  
  1.2       +14 -8     BLFS/BOOK/content/databases/postgresql/postgresql-inst.xml
  
  Index: postgresql-inst.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/content/databases/postgresql/postgresql-inst.xml,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- postgresql-inst.xml	6 Oct 2003 09:07:10 -0000	1.1
  +++ postgresql-inst.xml	8 Feb 2004 17:08:32 -0000	1.2
  @@ -7,6 +7,14 @@
   make &&
   make install</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/7.4/static/install-upgrading.html">the
  +official <application>Postgre<acronym>SQL</acronym></application>
  +documentation</ulink>.</para></note>
  +
   <para>Initialize a database cluster with the following commands:</para>
   
   <screen><userinput><command>mkdir -p /var/pgsql/data &&
  @@ -17,21 +25,19 @@
   <para>Start the database server with the following command:</para>
   
   <screen><userinput><command>su - postgres -c '/usr/bin/postmaster -D /var/pgsql/data > \
  -        /var/pgsql/data/logfile 2>&1 &'</command></userinput></screen>
  +    /var/pgsql/data/logfile 2>&1 &'</command></userinput></screen>
   
   <para>Now we can create a database and verify the installation:</para>
   
  -<screen><userinput><command>su - postgres -c '/usr/bin/createdb test'
  +<screen><userinput><command>su - postgres -c '/usr/bin/createdb test' &&
   echo "create table t1 ( name varchar(20), state_province varchar(20) );" \
  -                | (su - postgres -c '/usr/bin/psql test ')
  -		
  +    | (su - postgres -c '/usr/bin/psql test ') &&
   echo "insert into t1 values ('Billy', 'NewYork');" \
  -                | (su - postgres -c '/usr/bin/psql test ')
  +    | (su - postgres -c '/usr/bin/psql test ') &&
   echo "insert into t1 values ('Evanidus', 'Quebec');" \
  -	        | (su - postgres -c '/usr/bin/psql test ')
  +    | (su - postgres -c '/usr/bin/psql test ') &&
   echo "insert into t1 values ('Jesse', 'Ontario');" \
  -                | (su - postgres -c '/usr/bin/psql test ')
  -		
  +    | (su - postgres -c '/usr/bin/psql test ') &&
   echo "select * from t1;" | (su - postgres -c '/usr/bin/psql test')</command></userinput></screen>
   
   </sect2>
  
  
  
  1.2       +11 -2     BLFS/BOOK/content/databases/postgresql/postgresql-intro.xml
  
  Index: postgresql-intro.xml
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/content/databases/postgresql/postgresql-intro.xml,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- postgresql-intro.xml	6 Oct 2003 09:07:10 -0000	1.1
  +++ postgresql-intro.xml	8 Feb 2004 17:08:32 -0000	1.2
  @@ -23,8 +23,17 @@
   
   <sect3><title><application>Postgre<acronym>SQL</acronym></application> dependencies</title>
   <sect4><title>Optional</title>
  -<para><xref linkend="readline"/>, <xref linkend="Python"/>, <xref
  -linkend="openssl"/> and <xref linkend="Linux_PAM"/>
  +<para>
  +<xref linkend="readline"/>,
  +<xref linkend="Python"/>,
  +<xref linkend="tcl"/>,
  +<xref linkend="tk"/>,
  +<xref linkend="openssl"/>,
  +<xref linkend="Linux_PAM"/>,
  +<ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink> or
  +<ulink url="http://web.mit.edu/kerberos/www/">krb5</ulink>,
  +<ulink url="http://ant.apache.org/">Ant</ulink> and
  +<ulink url="http://rendezvous.sourceforge.net/">Rendezvous</ulink>
   </para></sect4>
   </sect3>
   
  
  
  
  1.4       +3 -3      BLFS/BOOK/content/databases/postgresql/postgresql.ent
  
  Index: postgresql.ent
  ===================================================================
  RCS file: /home/cvsroot/BLFS/BOOK/content/databases/postgresql/postgresql.ent,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- postgresql.ent	25 Jan 2004 07:03:54 -0000	1.3
  +++ postgresql.ent	8 Feb 2004 17:08:32 -0000	1.4
  @@ -5,8 +5,8 @@
   <!ENTITY postgresql-config SYSTEM "postgresql-config.xml">
   <!ENTITY postgresql-desc SYSTEM "postgresql-desc.xml">
   <!ENTITY postgresql-version "7.4.1">
  -<!ENTITY postgresql-download-http "">
  -<!ENTITY postgresql-download-ftp "ftp://ftp.fr.postgresql.org/v&postgresql-version;/postgresql-&postgresql-version;.tar.gz">
  -<!ENTITY postgresql-size "11 MB">
  +<!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.6 MB">
   <!ENTITY postgresql-buildsize "86 MB">
   <!ENTITY postgresql-time "1.74 SBU">
  
  
  



More information about the blfs-book mailing list