Re: Password Encryption

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Raúl Gutiérrez Sánchez <raul(at)laeff(dot)esa(dot)es>
Cc: PgSql-Admin Mailing List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Password Encryption
Date: 2003-01-26 23:51:36
Message-ID: 200301262351.h0QNpam17457@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Yes, it is. We now recommend MD5, and have since 7.2. The only way to
use crypt still is to store the password UNENCRYPTED in ALTER USER.

---------------------------------------------------------------------------

Ral Gutirrez Snchez wrote:
> I have tried to perform a cryp authentication but it seems not to work
> if the user passwords are stored md5-encrypted in the database. Is this
> behaviour normal?.
>
> Regards,
> Raul Gutierrez
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michiel Lange 2003-01-27 00:25:06 Cannot connect to the database (PG 7.3)
Previous Message Ross J. Reedstrom 2003-01-26 16:44:18 Re: what is the cause that scan type is showing as 'seq scan' after indexing