Re: Access to databas from the Internet

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