Thread: error postgresql remote access windows 7

error postgresql remote access windows 7

From
Arvind Singh
Date:
I have installed postgres server 9.3 on windows 7 network for the first time.

The systems are connected on wifi network.

Server in installed and working normal.

configured pghba with
host      all       all            0.0.0.0/0        md5
host    all             all             ::1/128                 md5

configured postgresql.conf with
listen_addresses = '*'   


I am using pgadmin III to access server
- From Server it works fine
- But from Client it cannot find the Server.

The client can access shared folders on server and Even ping is Ok from both sides.

Any hint or a checklist will Help.

regards
arvind

Re: error postgresql remote access windows 7

From
chiru r
Date:
Arvind,

It seems this is Firewall issue.Server side(where as postgresql installed) port(Ex:5432 default) was not opened to access postgres instance from client machines. please stop firewalls on windows 7 machine and try to connect from client machine. 

Best Regards,
Chiru


On Mon, May 27, 2013 at 11:01 AM, Arvind Singh <arvindps@hotmail.com> wrote:
I have installed postgres server 9.3 on windows 7 network for the first time.

The systems are connected on wifi network.

Server in installed and working normal.

configured pghba with
host      all       all            0.0.0.0/0        md5
host    all             all             ::1/128                 md5

configured postgresql.conf with
listen_addresses = '*'   


I am using pgadmin III to access server
- From Server it works fine
- But from Client it cannot find the Server.

The client can access shared folders on server and Even ping is Ok from both sides.

Any hint or a checklist will Help.

regards
arvind