Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::')

> The following bug has been logged on the website:
>
> Bug reference: 13611
> Logged by: Kondo Yuta
> Email address: kondo(at)sraoss(dot)co(dot)jp
> PostgreSQL version: 9.4.4
> Operating system: Windows 7
> Description:
>
> Hello,
>
> According to PostgreSQL document, listen_addresses = '0.0.0.0' or '::' are
> allowed.
> http://www.postgresql.org/docs/9.4/static/runtime-config-connection.html#GUC-LISTEN-ADDRESSES
>
> But I found "pg_ctl -w ..." timeouts connection test on Windows with
> listen_addresses = '0.0.0.0' or '::'.
>
> I found this reason in src/bin/pg_ctl/pg_ctl.c
> [test_postmaster_connection(bool)].
>
> When pg_ctl tries to connect to postmaster, it uses "0.0.0.0" as the
> target ip address. Unfortunately "0.0.0.0" is not a valid address on
> Windows and it fails. Shouldn't pg_ctl translate "0.0.0.0" to
> "127.0.0.1" in this case?

I think this is definitely a bug. I privately heard from the reporter
that if postmaster is started by not using pg_ctl, it happily starts
with "listen_addresses = '0.0.0.0'. That means, postmaster itself
works as advertised, but pg_ctl does not.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp