[[user-comments:open-ils:evergreenv1:server_installation:installing_postgresql|User Comments]]

PostgreSQL can be downloaded from http://www.postgresql.org/download/

Latest tests were performed with postgresql-8.0.3.  Below are the install steps we followed.  Naturally replace /opt with the directory you wish to install postgres into.

   user$ su
   bash# ./configure --prefix=/opt --with-perl --with-openssl && make && make install
   bash# cd /opt/
   bash# mkdir data
   bash# chown postgres:postgres /opt/data
   bash# su postgres
   postgres$ bin/initdb -D data -E UNICODE --locale=C 
   postgres$ nano -w data/postgresql.conf
       - set listen_address ='localhost'
   postgres$ bin/pg_ctl -D data -l /my/logs/postgres.log start
   postgres$ exit
   bash# cd /path/to/postgres_src/contrib && make && make install
   bash# cd /opt && PGUSER=postgres PGDATABASE=template1 bin/psql
   pg# \i /opt/share/postgresql/contrib/tsearch2.sql  	
   pg# \i /opt/share/postgresql/contrib/tablefunc.sql
   pg# \q
   bash# PGUSER=postgres bin/createlang plpgsql -d template1
   bash# PGUSER=postgres bin/createdb demo-dev
   bash# PGUSER=postgres bin/createlang plperl -d demo-dev
   bash# PGUSER=postgres bin/createlang plperlu -d demo-dev

At some point, you'll also want to change your postgres password (postgres user, not system user). Make sure to save it since you'll need it later in the install. 
   bash# su postgres
   bash# bin/psql
   bash# alter user postgres password 'my password';