Differences

This shows you the differences between two versions of the page.

--- installing_postgresql [2007/05/21 10:47] – bott
+++ installing_postgresql [2010/09/06 13:07] (current) – Delete obsolete page dbs
@@ Line 1: / Line 1: @@
-[[user-comments: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 evergreen
-   bash# PGUSER=postgres bin/createlang plperl -d evergreen
-   bash# PGUSER=postgres bin/createlang plperlu -d evergreen
-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';