Install PostgreSQL

Prev	Chapter 3. Complete Installation	Next

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.7.0 will run with PostgreSQL 7.3.2, 7.3.3, and 7.3.4 and 7.4.x. 7.4.7 is the recommended version of PostgreSQL.

Special notes for Mac OS X. If you are running Mac OS X prior to 10.3, you should be +

Skip this section if you will run only Oracle.

OpenACS 5.9.0 will run with PostgreSQL 7.3.2, 7.3.3, and 7.3.4 and 7.4.x. 7.4.7 is the recommended version of PostgreSQL.

Special notes for Mac OS X. If you are running Mac OS X prior to 10.3, you should be able to install and use PostGreSQL 7.3.x. Mac OS X 10.3 requires PostGreSQL 7.4.

Special Notes for Debian.

Debian stable user should install PostGreSQL from source as detailed below, or they should use the www.backports.org @@ -215,11 +215,11 @@ state. Red Hat and Debian and SuSE each work a little differently. If you haven't untarred the OpenACS tarball, you will need to do so now to access the postgresql.txt file.

Red Hat RPM:
The init script is already installed; just turn it on for the appropriate run levels.
```
[root root]# chkconfig --level 345 postgresql on
-[root root]# 
```

Red Hat from source:

[root src]# cp /var/tmp/openacs-5.7.0/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
+[root root]#

Red Hat from source:

[root src]# cp /var/tmp/openacs-5.9.0/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
 [root src]# chown root.root /etc/rc.d/init.d/postgresql
 [root src]# chmod 755 /etc/rc.d/init.d/postgresql
 [root src]# 
-cp /var/tmp/openacs-5.7.0/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
+cp /var/tmp/openacs-5.9.0/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 root]# service postgresql stop
 Stopping PostgreSQL: ok
@@ -242,7 +242,7 @@
 [root ~]# chown root.root /etc/init.d/postgresql
 [root ~]# chmod 755 /etc/init.d/postgresql
 [root ~]# 
-cp /var/tmp/openacs-5.7.0/packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql
+cp /var/tmp/openacs-5.9.0/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
@@ -260,11 +260,11 @@
    /etc/rc5.d/S20postgresql -> ../init.d/postgresql
 [root ~]# /etc/init.d/postgresql start
 Starting PostgreSQL: ok
-[root ~]#

FreeBSD:

[root ~]# cp /tmp/openacs-5.7.0/packages/acs-core-docs/www/files/postgresql.txt /usr/local/etc/rc.d/postgresql.sh
+[root ~]#

FreeBSD:

[root ~]# cp /tmp/openacs-5.9.0/packages/acs-core-docs/www/files/postgresql.txt /usr/local/etc/rc.d/postgresql.sh
 [root ~]# chown root:wheel /usr/local/etc/rc.d/postgresql.sh
 [root ~]# chmod 755 /usr/local/etc/rc.d/postgresql.sh
 [root ~]# 
-cp /tmp/openacs-5.7.0/packages/acs-core-docs/www/files/postgresql.txt /usr/local/etc/rc.d/postgresql.sh
+cp /tmp/openacs-5.9.0/packages/acs-core-docs/www/files/postgresql.txt /usr/local/etc/rc.d/postgresql.sh
 chown root:wheel /usr/local/etc/rc.d/postgresql.sh
 chmod 755 /usr/local/etc/rc.d/postgresql.sh

Test the script

[root ~]# /usr/local/etc/rc.d/postgresql.sh stop
 Stopping PostgreSQL: ok
@@ -282,7 +282,7 @@
             rc.d/ part in each of the
             following commands.
 
-

[root ~]# cp /var/tmp/openacs-5.7.0/packages/acs-core-docs/www/files/postgresql.txt /etc/rc.d/init.d/postgresql +

[root ~]# cp /var/tmp/openacs-5.9.0/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