howto-prepare-for-installation-postgresql-Ubuntu-10-04-64bit

Ubuntu 10.04-LTS 64Bit Server / Postgresql

Howto prepare Ubuntu 10.04-LTS 64Bit Server for installation of ADempiere with postgresql.

In this example the following values are assumed. Please change them according to your needs:

• Hostname: demo.example.com
• IP: 10.10.10.1/24

After the basic operatingsystem installation:

# apt-get install python-software-properties
# add-apt-repository "deb http://archive.canonical.com/ lucid partner"
# apt-get install sun-java6-jdk
# echo "export JAVA_HOME=/usr/lib/jvm/java-6-sun" >> /root/.bashrc
# apt-get install postgresql mailutils

---

Prepare Postgresql:

# su - postgres
postgres@demo:~$ createuser -P adempiere
Geben Sie das Passwort der neuen Rolle ein:
Geben Sie es noch einmal ein:
Soll die neue Rolle ein Superuser sein? (j/n) n
Soll die neue Rolle Datenbanken erzeugen dürfen? (j/n) n
Soll die neue Rolle weitere neue Rollen erzeugen dürfen? (j/n) n 
postgres@demo:~$ createdb adempiere -O adempiere 
postgres@demo:~$ psql

---

postgres=# ALTER USER postgres WITH PASSWORD 'postgres';

---

Edit: /etc/postgresql/8.4/main/postgresql.conf

# ...
listen_addresses = '*'
# ...

---

Edit: /etc/postgresql/8.4/main/pg_hba.conf

comment out the following lines:

#local   all         postgres                          ident
#local   all         all                               ident

add the following lines at the end:

local   all         postgres                         md5
local   all         adempiere                        md5
host    all         postgres    10.10.10.1/24        md5
host    all         adempiere   10.10.10.1/24        md5

restart postgreqsql:

# /etc/init.d/postgresql-8.4 restart

---

Now you are ready to install ADempiere:

• [howto-build-adempiere-from-source]
• [howto-install-adempiere]