Re: 0.0.0.0 addresses in postgresql.conf on Windows - Mailing list pgsql-general

From deepak
Subject Re: 0.0.0.0 addresses in postgresql.conf on Windows
Date
Msg-id CAALYutd=xSiRodjaFygdkC-cCx+Y+th8VWNUHjG_nYOUbS=PGA@mail.gmail.com
Whole thread Raw
In response to 0.0.0.0 addresses in postgresql.conf on Windows  (deepak <deepak.pn@gmail.com>)
List pgsql-general
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:
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

pgsql-general by date:

Previous
From: Phoenix Kiula
Date:
Subject: Re: Installed. Now what?
Next
From: Phoenix Kiula
Date:
Subject: Re: Huge number of INSERTs