Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote -1 down vote favorite

error is :

Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x0000274D/10061) Is the server running on > host "127.0.0.1" and accepting TCP/IP connections on port 5432?

share|improve this question
1  
Can you please explain your problem a bit better? What are you trying to do and where do you get the error? A bit of code will also help. – Divi Feb 21 at 10:24

closed as off topic by underdark♦ Feb 21 at 12:21

Questions on Geographic Information Systems Stack Exchange are expected to relate to geographic information systems within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

1 Answer

up vote 0 down vote

Usually default configuration only allows localhost connections. To allow other connections you should edit your postgresql.conf and pg_hba.conf file. In postgresql.conf you should find and uncomment the line:

listen_addresses = '*'

This will allow connecting from any ip. Secondly, you can fine tune which ip and which login method you want to use for specific hosts inside pg_hba.conf (instructions are commented inside the file)

Dont forget to restart the server for changes to take effect.

share|improve this answer
yeah. but it listen localhost as defautl so 127.0.0.1 should answer if postgresq lis started – simplexio Feb 21 at 12:38

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