Re: Cannot establish a remote connection

The DB server IP address is 192.168.168.2

The client PC that tries to connect to DB server is 192.168.168.73

As you can see, the 2 machines are in the same private network and same subnet.

I assume that no firewall is needed in this case.

Regards.

On Tue, Feb 25, 2014 at 11:56 AM, Victor Hugo <vh.clemente@gmail.com> wrote:

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"