Here it is : # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all reject host all all 127.0.0.1 255.255.255.255 reject host all all a.b.c.d 255.255.255.255 reject a.b.c.d is the ip adress of my computer. With this file, I can connect from the server when I type 'localhost' in the field 'server' of pgadmin, not when I type the ip adress of this server ! Thanks, Stéphane. -----Original Message----- From: Dave Page [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 11:14 AM To: Stéphane Coville Cc: [EMAIL PROTECTED] Subject: RE: RE : [pgadmin-support] Hi Stéphane, Can you send a copy of your pg_hba.conf file please? Regards, Dave. > -----Original Message----- > From: Stéphane Coville [mailto:[EMAIL PROTECTED] > Sent: 02 April 2003 08:57 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: RE : [pgadmin-support] > > > > //It's rumoured that Stéphane Coville once said: > //> Hello, > //> > //> I just installed postgres 7.3 on windows 2000 server with cygwin. > //> Everything is ok, but I cannot connect via pgadmin II. I > started the > > //> postmaster with -i. Everything is ok in pg_hba.conf, but when I > //> restart the services, there is no change, even if I > reject connections > //> from localhost !!! (PGAdmin works perfectly from > localhost). I hope > //> anybody has an idea ... > //> > //> Thanks for all, and sorry for my poor english ;-) > //> > //> Stéphane. > // > //Hi Stéphane, > // > //I know it sounds odd, but are you sure you're editting the > right pg_hba.conf file? Try a //search of your system to look > for others, because if you deny access from localhost, then > //it *does* work. Regards, Dave. // // > > Thank you for your answer. I allready tried to look for > others, but the one I edit is the only one on my system ... > The owner of this file is the postgres user. > > The versions I use are : > Windows 2000 SERVER > Cygwin 1.3.22-1 > Postgresql 7.3.2-1 > > Regards, > > Stéphane. > > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
