Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a PostgreSQL 9.3.1 DB Server running in Windows 7 Ultimate. I have checked the file postgresql.conf and this lines are uncommented:

listen_addresses="*"
port=5432

And this is the configuration at pg_hba.conf file:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             127.168.1.0/24          md5

# IPv6 local connections:
host    all             all             ::1/128                 md5

# Allow replication connections from localhost, by a user with the
# replication privilege.
#host    replication     postgres        127.0.0.1/32           md5
#host    replication     postgres        ::1/128                md5

Apparently all is fine but if I run the command netstat -an I don't see the port 5432 open to any host unless this line:

0.0.0.0:5432 

means that. The problem is I can't connect from any PC in subnet 192.168.1.x and the message says PostgreSQL isn't installed on the PC or it doesn't listen. I have disable any firewall in all PC looking for a solution but can't. Can any help me to find the problem here?

UPDATE

This is the error I'm getting:

enter image description here

share|improve this question
    
Please post the exact error message! –  Milen A. Radev Oct 16 '13 at 14:10
    
@MilenA.Radev basically the error looks like the one showed in the picture (see edition) but pointing to my local address 192.168.1.101 and port 5432 –  Reynier Oct 16 '13 at 15:06
    
0.0.0.0:5432 does indeed mean that it's listening on all addresses at port 5432. –  Colin 't Hart Oct 16 '13 at 15:18
1  
And this is from the same client PC that you've tried to connect using your PG client (looks like PGAdmin)? –  Colin 't Hart Oct 16 '13 at 16:12
1  
There is a typo in the pg_hba.conf: 127 should be 192 on the second uncommented line -- assuming this line is meant to allow password connections from the LAN. But this should give a different error than the one you report. –  Colin 't Hart Oct 16 '13 at 16:14

1 Answer 1

i have the same problem. I disabled all my third party antiviruses and firewalls and reinstall PostgreSQL again and its now working fine... :)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.