0.0.0.0 addresses in postgresql.conf on Windows
Hi!
It appears that when I try to configure listen_addresses in postgresql.conf
(on Windows)
with '0.0.0.0' , pg_ctl doesn't properly detect that server has started and
blocks forever.
C:\pg\pgsql>bin\pg_ctl.exe -D data -w start
waiting for server to
start.....................................................
.......... stopped waiting
pg_ctl: could not start server
Examine the log output.
(although, the postgres.exe processes were started)
If I change listen_addresses to '*', then pg_ctl exits fine after starting
up.
The documentation at the following link still mentions that one could use
'0.0.0.0' to listen on
all IPv4 addresses:
http://www.postgresql.org/docs/9.1/static/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS
Did something change in 9.1.1 in this area or am I missing something?
--
Deepak
Hi!
This seems to be the problem on Windows 2008 server, though starting with
'0.0.0.0' on Windows 2003 server worked fine.
I tried turning off IPv6 on the 2008 server to see if that has a effect,
but it still
behaved the same way after that change.
Please let me know if you have any thoughts on this one?
--
Deepak
On Fri, Nov 18, 2011 at 6:35 PM, deepak <deepak.pn@gmail.com> wrote:
Show quoted text
Hi!
It appears that when I try to configure listen_addresses in
postgresql.conf (on Windows)
with '0.0.0.0' , pg_ctl doesn't properly detect that server has started
and blocks forever.C:\pg\pgsql>bin\pg_ctl.exe -D data -w start
waiting for server to
start.....................................................
.......... stopped waiting
pg_ctl: could not start server
Examine the log output.(although, the postgres.exe processes were started)
If I change listen_addresses to '*', then pg_ctl exits fine after starting
up.The documentation at the following link still mentions that one could use
'0.0.0.0' to listen on
all IPv4 addresses:Did something change in 9.1.1 in this area or am I missing something?
--
Deepak