Connecting Tech Pros Worldwide Help | Site Map

How to connect to a remote postgresql via http

Newbie
 
Join Date: Sep 2008
Posts: 2
#1: Sep 2 '08
Hi,
I have just installed a postgresql server on a windows server. Now, I want to connect to it from a winodws desktop through http (intranet).

What URL will I have to use to connect to the remote db server?

Many thanks in advance..

regards,

Mike
Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 292
#2: Sep 2 '08

re: How to connect to a remote postgresql via http


I guess you need phppgadmin, or similar apps, postgres is not a http server. What do you want to do with postgres via http?
Newbie
 
Join Date: Sep 2008
Posts: 2
#3: Sep 3 '08

re: How to connect to a remote postgresql via http


I want the postgresql database to be accesible to our developers through the web (intranet, in particular) so that they can develop applications based on postgresql.

An application system based on postgresql db has just been turned over to us. But unfortunately, we have no previous knowledge of postgresql. It is upon receiving this application that we have become aware of postgresql.

I want our developers to be able to access the database I have just installed through our lan via http.
Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 292
#4: Sep 3 '08

re: How to connect to a remote postgresql via http


Quote:

Originally Posted by irhernan

I want the postgresql database to be accesible to our developers through the web (intranet, in particular) so that they can develop applications based on postgresql.

An application system based on postgresql db has just been turned over to us. But unfortunately, we have no previous knowledge of postgresql. It is upon receiving this application that we have become aware of postgresql.

I want our developers to be able to access the database I have just installed through our lan via http.

So you only need to configure postgres to listen for network connection
(in file postgresql.org change listen_addresses to '*' or server IP), and you must configure access rules in pg_hba.conf.
Reply