PostgreSQL Install Note

install PostgreSQL:
configure --with-python
gmake
gmake check
gmake install
gmake -C src/interfaces/python install
gmake install-all-headers

only client:
gmake -C src/bin install
gmake -C src/include install
gmake -C src/interfaces install
gmake -C doc install

unistall:
gmake uninstall
gmake clean
gmake distclean

setenv LD_LIBRARY_PATH /usr/local/pgsql/lib

set path = (/usr/local/pgsql/bin $path)

root# adduser postgres	
root# mkdir /usr/local/pgsql/data
root# chown postgres /usr/local/pgsql/data
root# su postgres
postgres$ initdb -D /usr/local/pgsql/data
postgres$ postmater -D /usr/local/pgsql/data
postgres$ createdb test
postgres$ psql test

install Apache:
configure --enable-so --enable-mods-shared=most
install Php:
configure --with-apxs2=/usr/local/apache2/bin/apxs 
--with-pgsql=/usr/local/pgsql
cp php.ini-dist /usr/local/lib/php.ini
vi php.ini:
add "/usr/local/lib/php" to include_path
vi http.conf:
add line:
LoadModule php5_module        modules/libphp5.so
AddType Application/x-httpd-php .php

原文转自：http://www.ltesting.net