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

Поиск
Список
Период
Сортировка
От Piero Campa
Тема Re: Access remote DB (outside local network) via PgAdmin
Дата
Msg-id 28933763.post@talk.nabble.com
обсуждение исходный текст
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Teodor Macicas
Дата:
Сообщение: Inserting additional data into pg_statistics
Следующее
От: Piero Campa
Дата:
Сообщение: Access remote DB (outside local network) via PgAdmin