Index: openacs-4/packages/acs-core-docs/www/postgres.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/postgres.html,v diff -u -r1.21.2.1 -r1.21.2.2 --- openacs-4/packages/acs-core-docs/www/postgres.html 14 Nov 2003 09:43:46 -0000 1.21.2.1 +++ openacs-4/packages/acs-core-docs/www/postgres.html 21 Nov 2003 11:14:09 -0000 1.21.2.2 @@ -1,8 +1,7 @@ -Install PostGreSQL

Install PostGreSQL

- by Vinod Kurup
+Install PostGreSQL

Install PostGreSQL

by Vinod Kurup

OpenACS docs are written by the named authors, and may be edited by OpenACS documentation staff. -

Skip this section if you will run only Oracle.

OpenACS 5.0.0b1 will run with PostGreSQL 7.2.x, 7.3.2, +

Skip this section if you will run only Oracle.

OpenACS 5.0.0b2 will run with PostGreSQL 7.2.x, 7.3.2, 7.3.3, and 7.3.4. 7.3.4 is the recommended version of PostgreSQL.

  • Debian.�

    Debian users can install the package and add some backwards-compatibility links:

    apt-get install postgresql postgresql-dev postgresql-doc
     ln -s /usr/include/postgresql/ /usr/include/pgsql
     ln -s /var/lib/postgres /usr/local/pgsql
    @@ -68,7 +67,7 @@
     	  Change to the postgres user and run ./configure to set the compilation options automatically. This is the point at which you can
     	  configure PostgreSQL in various ways. For example, if you want to
     	  enable
    -	  Unicode support, add the flags --enable-locale and --enable-multibyte. If you want to see what the other possibilities are, run ./configure --help.
    +	  Unicode support, add the flags --enable-locale and --enable-multibyte. If you want to see what the other possibilities are, run ./configure --help.
     	

    [root@yourserver src]# su - postgres
     [postgres@yourserver pgsql]$ cd /usr/local/src/postgresql-7.3.4
     [postgres@yourserver postgresql-7.3.4]$ ./configure
    @@ -165,11 +164,11 @@
             state. Red Hat and Debian and SuSE each work a little
             differently.
     	

    • Red Hat RPM:

      The init script is already installed; just turn it on for the appropriate run levels.

      [root@yourserver root]# chkconfig --level 345 postgresql on
      -[root@yourserver root]# 
    • Red Hat from source:

      [root@yourserver src]# cp /tmp/openacs-5.0.0b1/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
      +[root@yourserver root]# 
    • Red Hat from source:

      [root@yourserver src]# cp /tmp/openacs-5.0.0b2/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
       [root@yourserver src]# chown root.root /etc/rc.d/init.d/postgresql
       [root@yourserver src]# chmod 755 /etc/rc.d/init.d/postgresql
       [root@yourserver src]# 
      -
      cp /tmp/openacs-5.0.0b1/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
      +
      cp /tmp/openacs-5.0.0b2/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
       chown root.root /etc/rc.d/init.d/postgresql
       chmod 755 /etc/rc.d/init.d/postgresql

      Test the script.

      [root@yourserver root]# service postgresql stop
       Stopping PostgreSQL: ok
      @@ -188,11 +187,11 @@
       
      chkconfig --add postgresql
       chkconfig --level 345 postgresql on
       chkconfig --list postgresql
      -service postgresql start
    • Debian:

      root:~# cp /tmp/openacs-5.0.0b1/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
      +service postgresql start
  • Debian:

    root:~# cp /tmp/openacs-5.0.0b2/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
     root:~# chown root.root /etc/init.d/postgresql
     root:~# chmod 755 /etc/init.d/postgresql
     root:~# 
    
    -cp /tmp/openacs-5.0.0b1/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
    +cp /tmp/openacs-5.0.0b2/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
     chown root.root /etc/init.d/postgresql
     chmod 755 /etc/init.d/postgresql

    Test the script

    root:~# /etc/init.d/postgresql stop
     Stopping PostgreSQL: ok
    @@ -220,7 +219,7 @@
                 rc.d/ part in each of the
                 following commands.
     
    -          

root:~# cp /tmp/openacs-5.0.0b1/packages/acs-core-docs/www/files/postgresql.txt /etc/rc.d/init.d/postgresql
+          

root:~# cp /tmp/openacs-5.0.0b2/packages/acs-core-docs/www/files/postgresql.txt /etc/rc.d/init.d/postgresql
 root:~# chown root.root /etc/rc.d/init.d/postgresql
 root:~# chmod 755 /etc/rc.d/init.d/postgresql

@@ -299,4 +298,4 @@ PostgreSQL Performance Tuning -

($Id$)
View comments on this page at openacs.org
+

($Id$)
View comments on this page at openacs.org