Shane Ambler napisal(a): > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq PostgreSQL finally installed, runs on Windows based server, everything works great. I tried to give local and remote access to MS Access database, but there was no good solution for me. I converted the database to pgslq and now I'm a happy PostgreSQL user :) Thank You guys for help.
