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've set listen_addresses to '*' in postgresql.conf and stopped/started Postgres to "reload" configs.

Even then, psql SHOW listen_addresses; is showing localhost.

I'm sure I've edited and saved the postgresql.conf file correctly. Am I missing something?

PostgreSQL 9.1.2 running on Ubuntu 12.04 Server.

share|improve this question

migrated from stackoverflow.com Sep 22 '12 at 22:17

This question came from our site for professional and enthusiast programmers.

1  
Did you by any chance forget to remove the hash # from the start of the line? –  Eelke Sep 20 '12 at 18:33
add comment

1 Answer

Either:

  • You edited a different postgresql.conf than the one your server is using; or
  • as @Eelke points out, you forgot to uncomment the directive by removing the # at the start of the line.

To find out where the postgresql.conf your server uses is, run SHOW config_file; in psql.

share|improve this answer
    
Yes, I did remove hash # from the start of the line, and I've edit the right postgresql.conf (as show in 'show config_file;'), but with no success. –  Christian Oct 9 '12 at 3:15
    
@Christian Does sudo netstat -ltnp | grep postgres report anything? If so what? Anything in the PostreSQL server logs? –  Craig Ringer Oct 9 '12 at 4:11
add comment

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.