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:dpage@vale-housing.co.uk]
Sent: Wednesday, April 02, 2003 11:14 AM
To: Stéphane Coville
Cc: pgadmin-support@postgresql.org
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:s.coville@sig.pm.gouv.fr]
> Sent: 02 April 2003 08:57
> To: Dave Page
> Cc: pgadmin-support@postgresql.org
> 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.
>
>
>
