Postgres: Server does not listen even listen_addresses is set to '*' in postgresql.conf

Question

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.

Craig Ringer · Answer 1 · 2012-09-20 23:33:13Z

up vote 1 down vote

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.

answered Sep 20 '12 at 23:33

Craig Ringer
5,001519

	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

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