Re: pg_hba.conf problem?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Carlo Florendo" <fcarlo(at)ntsp(dot)nec(dot)co(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_hba.conf problem?
Date: 2002-02-11 16:15:09
Message-ID: 7113.1013444109@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Carlo Florendo" <fcarlo(at)ntsp(dot)nec(dot)co(dot)jp> writes:
> If I set the pg_hba.conf authentication entry for the client machine
> in the server machine to "trust", one could connect successfully.
> However, if I change the entry into "crypt" or "password", one
> couldn't connect even if the specified password was typed correctly.

Are you sure you tried "password" mode? One of the problems with
"crypt" is that the crypt library function isn't the same on all
platforms, so there are cases where a client on one machine can't
compute the right crypted password to send to a server on another.
(7.2's MD5 encryption mode avoids this problem, btw.)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-02-11 16:20:03 Re: SEMMAP
Previous Message Denis Perchine 2002-02-11 16:09:06 Re: Index on timestamp field, and now()