Re: Password?

On Wed, Jul 8, 2009 at 4:12 PM, Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de
> wrote:

> 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
>>
>
Yes, the * sign should removed and have to mention listen_addresses = ' * '
in Postgresql.conf file.

>
>> >
>> > 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
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>