Skip site navigation (1) Skip section navigation (2)

Re: Access to PostgreSQL database from external world

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: pgsql-novice(at)postgresql(dot)org
Cc: "Lukasz" <fatmouse(at)poczta(dot)fm>
Subject: Re: Access to PostgreSQL database from external world
Date: 2006-09-26 10:38:30
Message-ID: 200609260638.30537.sdavis2@mail.nih.gov (view raw or flat)
Thread:
Lists: pgsql-novice
On Tuesday 19 September 2006 09:05, Lukasz 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?

From a security point of view, this may not be the best idea.  It is probably 
a better idea to set up some kind of proxy between the internet and your 
database, but we don't know what your use case is.  

Sean

In response to

pgsql-novice by date

Next:From: Oliver FrommeDate: 2006-09-26 13:15:27
Subject: Re: Multiple UNIX-domain sockets?
Previous:From: Sean DavisDate: 2006-09-26 10:36:39
Subject: Re: Group By problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group