On Wed, Jul 8, 2009 at 4:12 PM, Andreas Wenk <a.w...@netzmeister-st-pauli.de > wrote:
> Ms swati chande schrieb: > >> --- On *Wed, 7/8/09, Andreas Wenk /<a.w...@netzmeister-st-pauli.de>/* >> wrote: >> >> >> From: Andreas Wenk <a.w...@netzmeister-st-pauli.de> >> Subject: Re: [GENERAL] Password? >> To: "Ms swati chande" <swat...@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 >> > 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
