sofiamay@mail.ru writes:
> 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)!
What's your evidence for this statement?
> but in reality:
> postgres.exe TCP 0.0.0.0 5432 and
> postgres.exe TCP :: 5432
I don't know what tool you're using here, but I wonder if you aren't
misinterpreting its output. For comparison's sake, when using Linux's
"netstat -l -n", I see this when PG's listen_addresses is '*':
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
...
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN
...
while when listen_addresses is 'localhost' the line is:
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
The all-zeroes foreign address does *not* mean that the socket is
accessible from everywhere, it just reflects an absence of data
for that column. The local address column is what's important
for a listening socket --- at least with netstat.
regards, tom lane
