su -
cd /usr/src
tar zxvf /path/vers/postgres- 8 .x.y.tar.gz

##

adduser postgres
chown postgres:postgres /usr/src/postgres- 8 .x.y/ -R
su - postgres
cd /usr/src/postgres- 8 .x.y
./configure
make
make check
logout
make install

## /usr/local/pgsql/ 

vi /etc/profile 

export LD_LIBRARY_PATH=/usr/local/pgsql/lib

export PATH=/usr/local/pgsql/bin:$PATH

chmod o+rx /usr/local/pgsql

mkdir /usr/local/pgsql/data
chown postgres:postgres /usr/local/pgsql/data

su postgres
initdb -D /usr/local/pgsql/data -A md5 -W

##set variable PGDATA in /home/postgres/.bash_profile

export PGDATA=/usr/local/pgsql/data


#/usr/src/PG/contrib/start-scripts/ Linux /etc/init.d/postgres

touch /var/log/pgsql
chown postgres:postgres /var/log/pgsql
chmod go-w /var/log/pgsql

#chkconfig add 
#/etc/init.d/postgres start

psql -U postgres template1
createlang plpgsql template1

CREATE DATABASE db TEMPLATE template0;
or
createdb -T template0 db (in shell mode)

CREATE USER toto [WITH PASSWORD 'password'];
CREATE DATABASE nomdb [OWNER utilisateurpropriétaire]
createdb  [-O prop] nomdb
GRANT ALL PRIVILEGES ON DATABASE nomdb TO nomutilisateur;
GRANT SELECT ON nomtable TO nomutilisateur;

CREATE TABLESPACE nomtbspace LOCATION 'path/vers/le/tablespace';
CREATE TABLE tb(int id) TABLESPACE nomtbspace;
SET default_tablespace = nomtbspace;

pg_hba.conf ; 
pg_ident.conf