User Tools

Site Tools


installing_postgresql

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
installing_postgresql [2007/05/21 10:47]
bott
— (current)
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'; 
installing_postgresql.1179758857.txt.gz · Last modified: 2022/02/10 13:33 (external edit)

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.