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.
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 |