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-26 07:50:04
Message-ID: 1398498604.307715770@f420.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

IT IS A SECURITY (NETWORK) BUG (bind to all ip instead of 127.0.0.1).

1) I download binare form http://www.enterprisedb.com/products-services-training/pgbindownload

Versions wich i download: 9.3.4 and 9.2.8 (Win x86-32)

2) In config file i wrote:

listen_addresses = '127.0.0.1'

3) Then i do init db and run this command:

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

PostgreSQL start and work fine, but binds to all ips.

My system is WINDOWS 7. Win7 pro x64. NOT LINUX.

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:5432 UserPC:0 LISTENING
TCP [::]:5432 UserPC:0 LISTENING
**********************************

I test this bug with 9.3 and 9.2 (Win x86-32) versions of PostgreSQL. Another version not tested (i have not time).
You can check it yourself.

Sorry for my english.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Evgen Bodunov 2014-04-26 08:45:11 Re: BUG #10141: Server fails to send query result.
Previous Message David G Johnston 2014-04-26 06:38:01 Re: BUG #10140: Configured for 127.0.0.1 but binds to all IP