| Prev | Chapter�3.�Complete Installation | Next |
|---|
by Vinod Kurup
+Skip this section if you will run only Oracle.
See Table�2.2, “Version Compatibility Matrix” for version compatibility.
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.
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.1.0d1 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.
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.
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 @@ -54,6 +58,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 @@ -88,11 +95,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.
On debian woody (stable, 3.0), do ./configure --without-readline --without-zlib.
[root src]# su - postgres [postgres pgsql]$ cd /usr/local/src/postgresql-7.3.4 [postgres postgresql-7.3.4]$ ./configure --with-includes=/sw/include/ --with-libraries=/sw/lib --enable-locale --enable-multibyte \ @@ -306,7 +314,10 @@ # Write-ahead log (WAL) # checkpoint_segments = 3 # in logfile segments (16MB each), min 1 -
Restart postgres (Redhat: service postgresql restart. Many other systems: /etc/init.d/postgresql restart) so that the changes take effect.
Official PostgreSQL Docs @@ -327,4 +338,4 @@ Performance Tuning