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

From: sdfasdf asdfasdf <sofiamay(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP
Date: 2014-04-25 19:54:10
Message-ID: 1398455650.412259692@f346.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

My system is WINDOWS 7 ! Win7 pro x64. NOT LINUX.
All versions 9.x.x Postgresql have a BUG. Its configured for 127.0.0.1 but binds to all IP (0.0.0.0)!

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

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

But show in config file: C:\Postgre\postgresql.conf

In Console:
**********************************
sort<C:\Postgre\postgresql.conf
lalala....
listen_addresses = '127.0.0.1' # what IP address(es) to listen on;
lalala....
**********************************

then

In Console:
**********************************
netstat -a

TCP 0.0.0.0:135 UserPC:0 LISTENING
TCP 0.0.0.0:445 UserPC:0 LISTENING
TCP 0.0.0.0:1025 UserPC:0 LISTENING
TCP 0.0.0.0:1026 UserPC:0 LISTENING
TCP 0.0.0.0:1027 UserPC:0 LISTENING
TCP 0.0.0.0:1028 UserPC:0 LISTENING
TCP 0.0.0.0:1029 UserPC:0 LISTENING
TCP 0.0.0.0:1030 UserPC:0 LISTENING
TCP 0.0.0.0:5432 UserPC:0 LISTENING
TCP [::]:135 UserPC:0 LISTENING
TCP [::]:445 UserPC:0 LISTENING
TCP [::]:1025 UserPC:0 LISTENING
TCP [::]:1026 UserPC:0 LISTENING
TCP [::]:1027 UserPC:0 LISTENING
TCP [::]:1028 UserPC:0 LISTENING
TCP [::]:1029 UserPC:0 LISTENING
TCP [::]:1030 UserPC:0 LISTENING
TCP [::]:5432 UserPC:0 LISTENING
**********************************

Process start command:

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

(server in C:\database\PostgreSQL-9.3.4, data in C:\Postgre)

Config file is work, other parametres work fine, but not work this parameter: listen_addresses = '127.0.0.1'

What's the trouble? Please fix this bug.
Sorry for my english.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-04-25 20:10:10 Re: Re[2]: [BUGS] BUG #10140: Configured for 127.0.0.1 but binds to all IP
Previous Message Tom Lane 2014-04-25 19:20:15 Re: BUG #10141: Server fails to send query result.