Forum OpenACS Q&A: oacs database

Collapse
Posted by Iuri Sampaio on
how do i see my database through an G.U.I. such as pgadmin3?

I have installed pgadmin3 and i'm trying the connection local and also via tunnel ssh but it didn't work out.

does anyone know how to that?

Collapse
2: Re: oacs database (response to 1)
Posted by Mohammad Al-Ghazali on
I've the same problem as that, I can't connect to my database using port:5432, is it the problem of the service? I'm trying to access the database within my server from remote, but I can't connect to it. Anyone can give any help on this. I've tried pgAdmin3 adn dbmanager,but both didn't work.
Collapse
3: Re: oacs database (response to 1)
Posted by Nick Carroll on
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
Thanks man,it works very well
Collapse
5: Re: Re: Re: oacs database (response to 4)
Posted by Aash SH on
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