Re: Access to databas from the Internet

Shane Ambler napisal(a):
> On 20/9/2006 16:55, "Lukasz" <fatmouse(at)poczta(dot)fm> wrote:
>
> >
> > Shane Ambler napisal(a):
> >> On 19/9/2006 22:41, "Lukasz" <fatmouse(at)poczta(dot)fm> 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(at)007Marketing(dot)com
>
> 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.