Changeset 785d4d91


Ignore:
Timestamp:
02/08/2004 05:08:32 PM (18 years ago)
Author:
Igor Živković <igor@…>
Branches:
10.0, 10.1, 11.0, 6.0, 6.1, 6.2, 6.2.0, 6.2.0-rc1, 6.2.0-rc2, 6.3, 6.3-rc1, 6.3-rc2, 6.3-rc3, 7.10, 7.4, 7.5, 7.6, 7.6-blfs, 7.6-systemd, 7.7, 7.8, 7.9, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, gnome, kde5-13430, kde5-14269, kde5-14686, ken/refactor-virt, krejzi/svn, lazarus, nosym, perl-modules, qt5new, systemd-11177, systemd-13485, trunk, upgradedb, v5_1, v5_1-pre1, xry111/git-date, xry111/git-date-for-trunk, xry111/git-date-test
Children:
1f686d2
Parents:
3efe4ba
Message:

postgresql corrections

git-svn-id: svn://svn.linuxfromscratch.org/BLFS/trunk/BOOK@1784 af4574ff-66df-0310-9fd7-8a98e5e911e0

Location:
content/databases/postgresql
Files:
5 edited

Legend:

Unmodified
Added
Removed
  • content/databases/postgresql/postgresql-config.xml

    r3efe4ba r785d4d91  
    3030        start)
    3131                echo "Starting PostgreSQL daemon..."
    32                 su - postgres -c '/usr/bin/pg_ctl start -W -D /var/pgsql/data \
     32                su - postgres -c '/usr/bin/pg_ctl start -W -D /var/pgsql/data \
    3333                               -l /var/pgsql/data/logfile -o "-i" '
    3434                evaluate_retval
     
    3838                echo "Stopping PostgreSQL daemon..."
    3939                /usr/bin/pg_ctl stop -m smart -D /var/pgsql/data
    40                 evaluate_retval
     40                evaluate_retval
    4141                ;;
    4242
  • content/databases/postgresql/postgresql-desc.xml

    r3efe4ba r785d4d91  
    2323<command>pg_resetxlog</command>,
    2424<command>pg_restore</command>,
     25<command>pgtclsh</command>,
     26<command>pgtksh</command>,
     27<command>pltcl_delmod</command>,
     28<command>pltcl_listmod</command>,
     29<command>pltcl_loadmod</command>,
    2530<command>postgres</command>,
    2631<command>postmaster</command>,
     
    2833<command>vacuumdb</command>,
    2934<filename class="libraryfile">libecpg</filename>,
     35<filename class="libraryfile">libpgtcl</filename>,
     36<filename class="libraryfile">libpgtypes</filename>,
    3037<filename class="libraryfile">libpq</filename> and various charset
    3138modules.</para>
     
    111118<command>pg_dump</command>.</para></sect3>
    112119
     120<sect3><title>pgtclsh</title>
     121<para><command>pgtclsh</command> is a <application>Tcl</application>
     122shell interface extended with
     123<application>Postgre<acronym>SQL</acronym></application> database access
     124functions.</para></sect3>
     125
     126<sect3><title>pgtksh</title>
     127<para><command>pgtksh</command> is a
     128<application>Tcl</application>/<application>Tk</application> shell
     129interface extended with
     130<application>Postgre<acronym>SQL</acronym></application> database access
     131functions.</para></sect3>
     132
    113133<sect3><title>postgres</title>
    114134<para><command>postgres</command> is a single user database server, generally used for
  • content/databases/postgresql/postgresql-inst.xml

    r3efe4ba r785d4d91  
    77make &amp;&amp;
    88make install</command></userinput></screen>
     9
     10<note><para>If you are upgrading an existing system and are going to
     11install the new files over the old ones, then you should
     12back up your data, shut down the old server and follow the
     13instructions in <ulink
     14url="http://www.postgresql.org/docs/7.4/static/install-upgrading.html">the
     15official <application>Postgre<acronym>SQL</acronym></application>
     16documentation</ulink>.</para></note>
    917
    1018<para>Initialize a database cluster with the following commands:</para>
     
    1826
    1927<screen><userinput><command>su - postgres -c '/usr/bin/postmaster -D /var/pgsql/data > \
    20         /var/pgsql/data/logfile 2>&amp;1 &amp;'</command></userinput></screen>
     28    /var/pgsql/data/logfile 2&gt;&amp;1 &amp;'</command></userinput></screen>
    2129
    2230<para>Now we can create a database and verify the installation:</para>
    2331
    24 <screen><userinput><command>su - postgres -c '/usr/bin/createdb test'
     32<screen><userinput><command>su - postgres -c '/usr/bin/createdb test' &amp;&amp;
    2533echo "create table t1 ( name varchar(20), state_province varchar(20) );" \
    26                 | (su - postgres -c '/usr/bin/psql test ')
    27                
     34    | (su - postgres -c '/usr/bin/psql test ') &amp;&amp;
    2835echo "insert into t1 values ('Billy', 'NewYork');" \
    29                 | (su - postgres -c '/usr/bin/psql test ')
     36    | (su - postgres -c '/usr/bin/psql test ') &amp;&amp;
    3037echo "insert into t1 values ('Evanidus', 'Quebec');" \
    31                 | (su - postgres -c '/usr/bin/psql test ')
     38    | (su - postgres -c '/usr/bin/psql test ') &amp;&amp;
    3239echo "insert into t1 values ('Jesse', 'Ontario');" \
    33                 | (su - postgres -c '/usr/bin/psql test ')
    34                
     40    | (su - postgres -c '/usr/bin/psql test ') &amp;&amp;
    3541echo "select * from t1;" | (su - postgres -c '/usr/bin/psql test')</command></userinput></screen>
    3642
  • content/databases/postgresql/postgresql-intro.xml

    r3efe4ba r785d4d91  
    2424<sect3><title><application>Postgre<acronym>SQL</acronym></application> dependencies</title>
    2525<sect4><title>Optional</title>
    26 <para><xref linkend="readline"/>, <xref linkend="Python"/>, <xref
    27 linkend="openssl"/> and <xref linkend="Linux_PAM"/>
     26<para>
     27<xref linkend="readline"/>,
     28<xref linkend="Python"/>,
     29<xref linkend="tcl"/>,
     30<xref linkend="tk"/>,
     31<xref linkend="openssl"/>,
     32<xref linkend="Linux_PAM"/>,
     33<ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink> or
     34<ulink url="http://web.mit.edu/kerberos/www/">krb5</ulink>,
     35<ulink url="http://ant.apache.org/">Ant</ulink> and
     36<ulink url="http://rendezvous.sourceforge.net/">Rendezvous</ulink>
    2837</para></sect4>
    2938</sect3>
  • content/databases/postgresql/postgresql.ent

    r3efe4ba r785d4d91  
    66<!ENTITY postgresql-desc SYSTEM "postgresql-desc.xml">
    77<!ENTITY postgresql-version "7.4.1">
    8 <!ENTITY postgresql-download-http "">
    9 <!ENTITY postgresql-download-ftp "ftp://ftp.fr.postgresql.org/v&postgresql-version;/postgresql-&postgresql-version;.tar.gz">
    10 <!ENTITY postgresql-size "11 MB">
     8<!ENTITY postgresql-download-http "http://gd.tuwien.ac.at/db/postgresql/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
     9<!ENTITY postgresql-download-ftp "ftp://ftp.fr.postgresql.org/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2">
     10<!ENTITY postgresql-size "9.6 MB">
    1111<!ENTITY postgresql-buildsize "86 MB">
    1212<!ENTITY postgresql-time "1.74 SBU">
Note: See TracChangeset for help on using the changeset viewer.