Install PostgreSQL

+Install PostgreSQL

Prev	Chapter�3.�Complete Installation	Next

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 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. PostgreSQL 7.4 has been verified.

Mac OS X.�If you are running Mac OS X prior to 10.3, you should be able to install and use PostGreSQL 7.2.x or 7.3.x. Mac OS X 10.3 requires PostGreSQL 7.4.
Debian.�
Debian users, especially Debian stable users, should install PostGreSQL from source as detailed below. Debian unstable users: the following process has been known to work:
```
apt-get install postgresql postgresql-dev postgresql-doc
+        
```

Skip this section if you will run only Oracle.

OpenACS 5.0.1 will run with PostgreSQL 7.3.2, 7.3.3, and 7.3.4. 7.3.4 is the recommended version of PostgreSQL. PostgreSQL 7.4 has been verified.

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.

Debian.�

Debian users, especially Debian stable users, should + install PostGreSQL from source as detailed below. Debian + unstable users: the following process has been known to work + (but you should double-check that the version of PostGreSQL is + 7.3 or above):

apt-get install postgresql postgresql-dev postgresql-doc
 ln -s /usr/include/postgresql/ /usr/include/pgsql
 ln -s /var/lib/postgres /usr/local/pgsql
 ln -s /usr/include/pgsql /usr/local/pgsql/include
@@ -42,6 +46,9 @@
 	  PostgreSQL. This is the account that PostgreSQL will run as
 	  since it will not run as root.  Since nobody will log in
 	  directly as that user, we'll leave the password blank.
+	
+	  Debian users should probably use adduser instead of
+	  useradd. Type man adduser
 	
[root src]# groupadd web
 [root src]# useradd -g web -d /usr/local/pgsql postgres
 [root src]# mkdir -p /usr/local/pgsql
@@ -69,11 +76,12 @@
 LD_LIBRARY_PATH=:/usr/local/pgsql/lib
 PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin:/usr/local/pgsql/bin:/usr/local/pgsql/bin
 [postgres pgsql]$ exit
-

Compile and install PostgreSQL.� + Don't continue unless you see correct output from + env | grep PATH

Compile and install PostgreSQL.� 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 src]# su - postgres [postgres pgsql]$ cd /usr/local/src/postgresql-7.3.4 [postgres postgresql-7.3.4]$ ./configure @@ -170,11 +178,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 root]# chkconfig --level 345 postgresql on -[root root]# Red Hat from source: [root src]# cp /tmp//packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql +[root root]# Red Hat from source: [root src]# cp /tmp/openacs-5.0.1/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 /tmp//packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql +cp /tmp/openacs-5.0.1/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 @@ -193,11 +201,11 @@ chkconfig --add postgresql chkconfig --level 345 postgresql on chkconfig --list postgresql -service postgresql start Debian: [root ~]# cp /tmp//packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql +service postgresql start Debian: [root ~]# cp /tmp/openacs-5.0.1/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//packages/acs-core-docs/www/files/postgresql.txt /etc/init.d/postgresql +cp /tmp/openacs-5.0.1/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 @@ -225,7 +233,7 @@ rc.d/ part in each of the following commands. - [root ~]# cp /tmp//packages/acs-core-docs/www/files/postgresql.txt /etc/rc.d/init.d/postgresql +

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

@@ -286,7 +294,10 @@ # Write-ahead log (WAL) # checkpoint_segments = 3 # in logfile segments (16MB each), min 1 -

Restart postgres (service postgresql restart) so that the changes take effect.

`more information about PostgreSQL`

+
Restart postgres (service postgresql + restart) or + (/etc/init.d/postgres + restart) so that the changes take effect.

`more information about PostgreSQL`

Official PostgreSQL Docs