Re: Access remote DB (outside local network) via PgAdmin

From: Piero Campa <piero(dot)campa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Access remote DB (outside local network) via PgAdmin
Date: 2010-06-19 10:13:47
Message-ID: 28933763.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Here [->
http://old.nabble.com/-GENERAL--Access-to-databas-from-the-Internet-td6388294.html#a6388294
http://old.nabble.com/-GENERAL--Access-to-databas-from-the-Internet-td6388294.html#a6388294
] there is a very similar thread, I feel sorry for the redundancy.

Anyway I would ask to you some more thing about this topic: I've been
reading here [
http://library.linode.com/databases/postgresql/pgadmin-windows
http://library.linode.com/databases/postgresql/pgadmin-windows ] that you
can access remotely creating a VPN channel.

What are the real advantages of creating a VPN, if you have already set your
server like this for example:
host all all zzz.zzz.zzz.zzz/32 md5
I mean, don't you already have an md5 encrypted channel between the server
and zzz.zzz.zzz.zzz ?

Thank you for reading.
Piero

Piero Campa wrote:
>
> Hi to everyone,
> well until now I could easiily access a remote hosted database in my local
> network via PgAdmin: just set the IP and port and login info and I was
> done.
>
> But whether I want to access that database from outside my network, even
> without encrypted tunnels by now, what do I have to do?
>
> In my thoughts I should configure my router in order to bind for example
> <Server_IP (192.168.0.2)>:5432 <--> <Router_External_IP>:<some_port>. So
> when I add a server in PgAdmin and I'm outside the network I set
> <Router_External_IP> as IP and <some_port> as listening port.
>
> Is it possible?
> Or, maube better, which is the correct way of working like this?
>
> Thank you in advance.
> Piero
>

--
View this message in context: http://old.nabble.com/Access-remote-DB-%28outside-local-network%29-via-PgAdmin-tp28933725p28933763.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2010-06-19 11:28:21 Re: Tracking SQLs that update data
Previous Message Piero Campa 2010-06-19 10:03:45 Access remote DB (outside local network) via PgAdmin