Installing PostgreSQL (PostgresPlus 8.4SS) On Centos For Adempiere
Langkah-langkah :1. Tempatkan software postgres di /opt
2. chmod +x nama file
3. ./ nama file
4. Perintah :
- Database Server = Y5. /opt/postgres/8.0/bin
- Slony = N
- PGJDBC = Y
- Postgis = N
- PsqLODBC = N
- PgBouncer = Y
- PgMemcache = Y
- Pa Agent = Y
- Is The Selection = Y
- Database Instalation Tuning = Y
- Update Notification Service = N
- User Account = Y
- Email [] = insert email
- Password = insert password Email
- Choose an Option = 3
- OLTP system choose an Option = 1
- Password Postgres = insert password
- Continue = Y
- Lounch Stack Builder = N
- su postgres-./psql
- ./createuser -P adempiere
-./createdb adempiere -O adempiere
-\l (untuk menampilkan database)
-\q (untuk keluar dari postgres)
6. edit pg_hba.conf (vi /opt/postgres/8.4ss/data/pg_hba.conf) → isikan IP yg akan akses database
TYPE DATABASE USER CIDR-ADDRESS METHOD
"local" is for Unix domain socket connections only
local all all md5
IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 172.16.0.0/16 md5
host adempiere adempiere 172.16.0.0/16 md5
host adempiere postgres 172.16.0.0/16 md5
IPv6 local connections:
host all all ::1/128 md5
7. edit pg_hba.conf (vi /opt/postgres/8.4ss/data/postgresql.conf)
- listen_addresses = '*'
- password_encryption = on (optinal)
- Membuka Firewall
Membuka firewall port sudo iptables -A INPUT -p tcp --dport 5432 -j ACCEPT
- Membackup Database
./pg_restore -P 5432 -d adempiere -U adempiere /home/ademdb/DbAdempiere.backupCreate New Database di pgadmin
./pg_dump -d adempiere -U adempiere /home/ademdb/DbAdempiere.backup
name : adempiere
owner : adempiere
collation : UTF-8
Caracter : UTF-8
Privilages : Centang All
SQL : ketik script "drop language phgsql" tekan F5
-Pilih DB adempiere
-Centang No Owner
Note : jika pada saat kita drop database tidak bisa, putuskan terlebih dahulu koneksi dari adempiere ke database.
