Re: Password? - Mailing list pgsql-general

Ms swati chande schrieb:

--- On *Wed, 7/8/09, Andreas Wenk /<a.wenk@netzmeister-st-pauli.de>/* wrote:


   From: Andreas Wenk <a.wenk@netzmeister-st-pauli.de>
   Subject: Re: [GENERAL] Password?
   To: "Ms swati chande" <swativc@yahoo.com>, "PG-General Mailing List"
   <pgsql-general@postgresql.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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general