From AdempiereWiki

Contents 1 Summary 2 Prepare the System 2.1 Import the PostgreSQL Yum Repo 2.2 Install PostgreSQL 2.3 Configure PostgreSQL 2.4 Start PostgreSQL 2.5 Prepare PostgreSQL

Summary

Please find instructions for a quick install guide of Adempiere 3.5.4 on Centos 5.4 / PostgreSQL 8.4.2. Please feel free to add or correct as necessary.

Prepare the System

Import the PostgreSQL Yum Repo

rpm -Uvh http://yum.pgsqlrpms.org/reporpms/8.4/pgdg-centos-8.4-1.noarch.rpm

Install PostgreSQL

yum install -y postgresql-server

Configure PostgreSQL

service postgresql initdb
cd /var/lib/pgsql/data

vi pg_hba.conf

Edit this file an add an entry for your local network

vi postgresql.conf

Add the line:

listen_addressses = '*'

This allows postgresql to listen on all addresses. Logins are restricted according to the pg_hba.conf edited above and also your iptables firewall rules.

Start PostgreSQL

service postgresql start

Prepare PostgreSQL

psql
create database adempiere;
create role adempiere;
create schema adempiere;
\q