Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux