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

I am not stupid. I start and stop postresql manually, not as sevice.

In Console:
 **********************************
psql -U postgres
show config_file;

output:
 C:/Postgre/postgresql.conf
**********************************
in file:  listen_addresses = '127.0.0.1'

File works fine, but PostreSQL binds to all IP.
Parameter [i] in pg_ctl cmd line is i[mmediate] and does not affect for IP adress.

It is a bug.


Fri, 25 Apr 2014 16:10:10 -0400 от Tom Lane <tgl@sss.pgh.pa.us>:
> =?UTF-8?B?c2RmYXNkZiBhc2RmYXNkZg==?= <sofiamay@mail.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
>