Thread: Cannot establish a remote connection

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

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"