Re: 0.0.0.0 addresses in postgresql.conf on Windows

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(dot)pn(at)gmail(dot)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
>