Install PostgreSQL

Download PostgreSQL from : http://www.postgresql.org/download/

Install PostgreSQL http://www.postgresql.org/docs/8.0/interactive/installation.html

example:

./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data


To PostgreSQL works in network is necessary to run postmaster with parameter -i, remember to review client authentification (http://www.postgresql.org/docs/8.0/interactive/client-authentication.html)

My example file is /usr/local/pgsql/data/pg_hba.conf :
host all all 172.16.1.39 255.255.0.0 trust

Start Server:
pg_ctl start -D /usr/local/pgsql/data -l logfile -o "-i"

Install Procedure Languages:
createlang plpgsql template1

Note: This is necessary for a emulation because PLJava does not support mapping java type

Create User & Database for Compiere

Create User:
createuser compiere

Create Database:
createdb cmpcs -e unicode

• Install PL Java
• Subscription for Download          
• Support