Re: Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP
Date
Msg-id 23958.1398456610@sss.pgh.pa.us
Whole thread Raw
In response to BUG #10140: Configured for 127.0.0.1 but binds to all IP  (sofiamay@mail.ru)
Responses Re[4]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP  (sdfasdf asdfasdf <sofiamay@mail.ru>)
List pgsql-bugs
=?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



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #10141: Server fails to send query result.
Next
From: sdfasdf asdfasdf
Date:
Subject: Re[4]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP