Re: Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP

=?UTF-8?B?c2RmYXNkZiBhc2RmYXNkZg==?= <sofiamay(at)mail(dot)ru> writes:
> In Console:
> **********************************
> psql -U postgres
> show listen_addresses;

> output:
> listen_addresses
> ------------------
> *
> (1 User)
> **********************************

Well, if it's saying that, then it's not a bug that it is in fact
binding to all addresses.

I suspect Stephen was right that you forgot to restart the postmaster
after changing the configuration file. (pg_ctl reload is *not* enough for
changing this parameter.)

Another theory is that the file you edited isn't the one the postmaster
is looking at. ("show config_file" would help diagnose this.)

Another theory is that the config file setting is being overridden by
some higher-priority setting, such as "-i" on the postmaster command
line. (Looking at the source for listen_addresses in
"select * from pg_settings" would help diagnose this case.)

regards, tom lane