Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot establish a remote connection - Mailing list pgsql-novice

From Victor Hugo
Subject Re: Cannot establish a remote connection
Date
Msg-id CALMSkPXZZEXEOfQKJG6Q28PasX+43=46DE0pN4JCqHczHFBjuQ@mail.gmail.com
Whole thread Raw
In response to Cannot establish a remote connection  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
Tree view
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@gmail.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"

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: Cannot establish a remote connection
Next
From: Victor Hugo
Date:
Subject: Re: Cannot establish a remote connection