I found the solution :
In fact, I was connected on windows on Administrator. When I searched
the file pg_hba.conf, I didn't find the real one because I couldn't
access to the data directory !
It's so easy when you log as postgres !!!
Thanks for all.
Stéphane.
-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Wednesday, April 02, 2003 12:01 PM
To: Stéphane Coville
Cc: pgadmin-support@postgresql.org
Subject: RE: RE : RE : [pgadmin-support]
Hi Stéphane,
That certainly should reject everything, in fact I've never seen a case
were it wouldn't.
As this is obviously a PostgreSQL problem and not pgAdmin, I would
suggest posting to one of the PostgreSQL lists such as
pgsql-general@postgresql.org.
Sorry I cannot help more.
Regards, Dave.
> -----Original Message-----
> From: Stéphane Coville [mailto:s.coville@sig.pm.gouv.fr]
> Sent: 02 April 2003 10:50
> To: Dave Page
> Cc: pgadmin-support@postgresql.org
> Subject: RE : RE : [pgadmin-support]
>
>
> 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.
> >
> >
> >
>
>
>
