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
2 komentar:
Salam kenal gan, Sy newbie masalah postgresql.. saya punya masalah pada connection JDBC juga.. sy pake OS win7.. bisa minta pencerahannya gan.. kalo mo lihat kronologisnya please dateng ke http://primesevenine.wordpress.com/2011/04/06/error-jdbc-connection-di-os-win-7-tolong/
Thanks gan.. Tolong banget gan..
You actually make it appear really easy along with your presentation however I find this matter to be actually something that
I feel I might never understand. It kind of feels too complicated and very extensive for me.
I'm having a look ahead on your next post, I will try to get the dangle of it!
My website: Christian Louboutin Sale
Post a Comment