On 20/9/2006 16:55, "Lukasz" <fatmouse@xxxxxxxxx> wrote: > > Shane Ambler napisal(a): >> On 19/9/2006 22:41, "Lukasz" <fatmouse@xxxxxxxxx> wrote: >> >>> Hello, >>> >>> I would like to install a PostgreSQL. I know how to manage the database >>> itself, creae databases, user, groups and so on. But I don't know how >>> to allow other users, who are outside LAN to connect to database >>> through Internet. >>> >>> For example, my external IP is xxx.xxx.xxx.xxx, and my IP in the local >>> network is yyy.yyy.yyy.yyy. I want to install PostgreSQL on the >>> computer with yyy.yyy... What and where I need to configure to have >>> access to my database from Internet? >> >> >> I will assume that you want to allow normal psql client access and not >> through a web server. >> >> There is two places you will need to configure. >> >> One is your router - you will need to setup port forwarding . The default >> port for connecting to the PostgreSQL server is 5432 so the router will need >> to forward any incoming requests on tcp port 5432 to tcp port 5432 at >> server address yyy.yyy.yyy.yyy (your PostgreSQL server address) >> If you have configured a different port then adjust accordingly. >> This is a common configuration option and shouldn't be hard to find. >> > I will connect to my PostgreSQL by an Java applet, as also, from time > to time, by PGAdmin. > They will both connect the same as psql - through port 5432. If you wanted them to connect to a web server in your network to access the db then you would use port 80. -- Shane Ambler Postgres@xxxxxxxxxxxxxxxx Get Sheeky @ http://Sheeky.Biz
