RE : RE :

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.
>
>
>