Обсуждение: Question regarding whether the Postgres JDBC driver supports password encryption . . .

Hey All,

Does anyone know whether or not the Postgres JDBC driver supports password
encryption?  I have set the AUTHTYPE to "encrypt" and I have been able to
successfully connect to the database with the JDBC driver.  Does this mean
that the password via Postgres JDBC is encrypted?  And if so, what type of
encryption is this?

Thanks in advance,
Peter

Peter E. Chen wrote:
> Hey All,
>
> Does anyone know whether or not the Postgres JDBC driver supports password
> encryption?  I have set the AUTHTYPE to "encrypt" and I have been able to
> successfully connect to the database with the JDBC driver.  Does this mean
> that the password via Postgres JDBC is encrypted?  And if so, what type of
> encryption is this?

There is no 'encrypt' auth, just 'crypt' which uses Unix crypt()
encryption.  7.2 will also support MD5 encryption, and encryption of
passwords stored in the server.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026