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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


migration rejected from May 9 '15 at 1:33

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by dezso, Colin 't Hart, Phil, Paul White, RLF May 9 '15 at 1:33

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – dezso, Colin 't Hart, Phil, Paul White, RLF
If this question can be reworded to fit the rules in the help center, please edit the question.

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

Restart the postgres server from the terminal for ubuntu

sudo service postgresql restart

then it will dispay the results of the cause for failure e.g 2015-05-08 17:33:46 EAT FATAL: private key file "/etc/ssl/private/ssl-cert-snakeoil.key" has group or world access 2015-05-08 17:33:46 EAT DETAIL: File must be owned by the database user or root, must have no write permission for "group", and must have no permissions for "other". so you can use the chmod 740 ssl-cert-snakeoil.key or access the file by navigating through the folders, right click the file and change permissions to the postgres administrator

Thanks, your good to go.


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