On Wed, Jul 8, 2009 at 4:12 PM, Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
Yes, the * sign should removed and have to mention listen_addresses = ' * ' in Postgresql.conf file.
Ms swati chande schrieb:
--- On *Wed, 7/8/09, Andreas Wenk /<a.wenk@xxxxxxxxxxxxxxxxxxxxxxx>/* wrote:
From: Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Password?
To: "Ms swati chande" <swativc@xxxxxxxxx>, "PG-General Mailing List"
<pgsql-general@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
