Re: Password?

Ms swati chande schrieb:
> --- On *Wed, 7/8/09, Andreas Wenk /<a(dot)wenk(at)netzmeister-st-pauli(dot)de>/* wrote:
>
>
> From: Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
> Subject: Re: [GENERAL] Password?
> To: "Ms swati chande" <swativc(at)yahoo(dot)com>, "PG-General Mailing List"
> <pgsql-general(at)postgresql(dot)org>
> Date: Wednesday, July 8, 2009, 3:47 PM
>
> Ms swati chande schrieb:
> > Thanks Andy,
> > I am working on Windows XP. Have built from source using Visual
> Studio 2005.
> > I have made a change in pg_hba.conf to include the ipconfig of
> my system.
> > # TYPE DATABASE USER CIDR-ADDRESS METHOD
> > *host all all <my ipconfig> trust*
> > # IPv4 local connections:
> > host all all 127.0.0.1/32 trust
> > # IPv6 local connections:
> > #host all all ::1/128 trust
> >
> > This was to take care of the following problem:
> > LOG: could not bind IPv4 socket: Address already in use
> > HINT: Is another postmaster already running on port 5432? If not,
> wait a few seconds and retry.
> > WARNING: could not create listen socket for "*"
> > FATAL: could not create any TCP/IP sockets
> > For this I changed the listen_addresses to my current ip. and
> made the same change in pg_hba.conf.
> > Thanks
> > Regards
> > Swati
> >
>
> So does it work now ? Why is there a * sign before host? This seems
> to be incorrect ...
>
> P.S.: dont' forget to reply also to the mailinglist (reply to all)
>
>
>
> No its still not working.
> The * doesn't exist in pg_hba. It was probably in the mail as I had
> formatted that line to be 'bold'.

ah ok ..

Actually it should work if you set listen_addresses to '*' in postgresql.conf. Did you
change anything else in postgresql.conf or pg_hba.conf?

I am not too experienced with Windows so maybe someone with more knowledge is able to find
the trick (I installed 8.4 once with the one click installer ...no problems at all). But
as far as I understand something is wrong with:

> WARNING: could not create listen socket for "*"
> FATAL: could not create any TCP/IP sockets

I understand correct, that you fixed this? Then it should work as I mentioned earlier ...

Cheers Andy