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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP
Дата
Msg-id 13383.1398540779@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP  (sdfasdf asdfasdf <sofiamay@mail.ru>)
Ответы Re[2]: [BUGS] Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP  (sdfasdf asdfasdf <sofiamay@mail.ru>)
Список pgsql-bugs
=?UTF-8?B?c2RmYXNkZiBhc2RmYXNkZg==?= <sofiamay@mail.ru> writes:
> IT IS A SECURITY (NETWORK) BUG (bind to all ip instead of 127.0.0.1).

No, it's pilot error.

> 2) In config file i wrote:
> listen_addresses = '127.0.0.1'
> 3) Then i do init db and run this command:

If you did things in that order, it would not have worked anyway, because
the config file that the postmaster will use doesn't exist until initdb
creates it.  However, the real problem appears to be here:

> C:\database\PostgreSQL-9.3.4\bin\pg_ctl.exe start -w -D "C:\Postgre" -s -o "-i"

The -o "-i" part is passing a -i command line switch to the postmaster,
and that sets listen_addresses to "*", overriding whatever might be in
the config file.  If you'd looked at pg_settings as I advised yesterday,
you'd have seen the evidence of this immediately.

            regards, tom lane



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #10144: PostgreSQL cost_index in costsize.c bug? (cann't estimate indexCorrelation correct)