Evergreen DokuWiki

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';