From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | kondo(at)sraoss(dot)co(dot)jp |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::') |
Date: | 2015-09-14 04:15:34 |
Message-ID: | 20150914.131534.102176843624802952.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-09-14 04:36:14 | Re: Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::') |
Previous Message | Michael Paquier | 2015-09-14 01:36:32 | Re: PQexec() hangs on OOM |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-09-14 04:36:14 | Re: Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::') |
Previous Message | Bruce Momjian | 2015-09-14 02:51:15 | We are doing well |