Forum OpenACS Q&A: Re: oacs database

Collapse
3: Re: oacs database (response to 1)
Posted by Nick Carroll on 04/11/06 03:03 PM
Make sure that postgresql has been configured to accept TCP/IP connections in postgresql.conf. Postgresql 7.4 should have this set by default.

Also you might want to change access privileges to your database server by configuring the pg_hba.conf file.

Collapse
4: Re: Re: oacs database (response to 3)
Posted by Mohammad Al-Ghazali on 04/13/06 08:43 PM
Thanks man,it works very well
Collapse
5: Re: Re: Re: oacs database (response to 4)
Posted by Aash SH on 04/13/06 09:18 PM
edit your postgresql.conf, makesure tcpip_socket=true and port = 5432

and pg_hba.conf, please put the ip address of the terminal that you want to connect to the server together with subnet mask.

local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all xxx.xxx.xxx.xxx 255.255.255.255 trust

xxx.xxx.xxx.xxx is your ip address