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...@gmail.com> wrote: > 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 >
