This a problem ;

It's a solution...
1. [root@pwmpku /]# cd /home/postgres/Adempiere/postgresql/8.2.0/pgdata/
Edit this statement =
host all all {your subnet/netmask} in pg_hba.conf
[root@pwmpku pgdata]# nano pg_hba.conf
TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 192.168.0.0/24 trust
2. cd /home/postgres/Adempiere/postgresql/8.2.0
3. [root@pwmpku 8.2.0]# . ./PGSQL.env
4. [root@pwmpku 8.2.0]# cd bin/
5. [root@pwmpku bin]# ./pg_ctl restart
6. [root@pwmpku ~]# su - postgres
7. cd /home/postgres/Adempiere/postgresql/8.2.0/bin
8. [postgres@pwmpku bin]$ ./pg_ctl restart
waiting for server to shut down.... done
server stopped
server starting
[postgres@pwmpku bin]$ LOG: database system was shut down at 2011-01-18 11:59:00 WIT
LOG: checkpoint record is at 0/3E96498
LOG: redo record is at 0/3E96498; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/5552; next OID: 108939
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
[postgres@pwmpku bin]$
And then you can continue test process connection :

good luck ! :) Label: open source