Thread: Re: RE : RE :

Re: RE : RE :

From
"Dave Page"
Date:
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
aspgsql-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.
> >
> >
> >
>
>
>


RE : RE : RE :

From
Stéphane Coville
Date:
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.
> >
> >
> >
>
>
>