| From: | Victor Hugo <vh(dot)clemente(at)gmail(dot)com> |
|---|---|
| To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Cannot establish a remote connection |
| Date: | 2014-02-25 17:56:32 |
| Message-ID: | CALMSkPXZZEXEOfQKJG6Q28PasX+43=46DE0pN4JCqHczHFBjuQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
What is the IP of the database server?
Have router between the database server and pgAdmin III ??? Is on the same
subnet ?
The firewall ports are enabled?
Tk´s ;-)
2014-02-25 14:20 GMT-03:00 JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>:
> I need to connect to a remote PostgreSQL 9.3 database with pgAdmin III
> within our private network, so I did the following:
>
> * Open postgresql.conf file and verify that listen_addresses = '*'
> * Open pg_hba.conf and add the following line:
> host all all 192.168.168.0/24 md5
> Our private network segment is 192.168.168.*
> * I stop PostgreSQL service.
> * I start PostgeSQL service.
>
> I can connect locally but not remotely.
> I will very much appreciate your feedback.
>
> Respectfully,
> Jorge Maldonado
>
>
--
Abcs
Victor Hugo - DBA
Mobile: (21) 99529-5585
Google Talk: vh.clemente
Skype: vh.clemente
"Antes de imprimir, pense em sua responsabilidade e compromisso com o MEIO
AMBIENTE"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Hugo | 2014-02-25 19:39:14 | Re: Cannot establish a remote connection |
| Previous Message | JORGE MALDONADO | 2014-02-25 17:20:57 | Cannot establish a remote connection |