Thread: passwords

passwords

From
acchung@mit.edu
Date:
Hi,

I'm running pgAdmin II on a Win2k Computer running
postgresql 7.2 along with cygwin.  I'm trying to
get pgAdmin to authenticate password every time I connect
to the server.  It seems that no matter what password
i type in, it accepts it, even blank ones.  Could it be
because I'm trying to log in when I'm already on the server
computer?  How can I get pgAdmin to authenticate passwords correctly?

Alex



Re: passwords

From
"Dave Page"
Date:

> -----Original Message-----
> From: acchung@mit.edu [mailto:acchung@mit.edu]
> Sent: 24 June 2002 16:24
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] passwords
>
>
> Hi,
>
> I'm running pgAdmin II on a Win2k Computer running
> postgresql 7.2 along with cygwin.  I'm trying to
> get pgAdmin to authenticate password every time I connect
> to the server.  It seems that no matter what password
> i type in, it accepts it, even blank ones.  Could it be
> because I'm trying to log in when I'm already on the server
> computer?  How can I get pgAdmin to authenticate passwords correctly?

pgAdmin doesn't authenticate the passwords, PostgreSQL does (it wouldn't
be a very secure system if any old bit of client software could
authenticate a user :-) ).

Check $PGDATA/pg_hba.conf on the server - it sounds like there is a
'trust' entry in there that is allowing you to connect.

Regards, Dave.