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.
---
Raúl Gutiérrez Sánchez wrote:
> I have tried to perform a cryp authentication bu
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 on
Jodi Kanter wrote:
> We are currently using the pg_passwd utility to encrypt passwords.
> Someone here told me that I can now encrypt passwords within postgresql
> so that they are not stored in plain text in the pg_shadow file.
> Is this true? I cannot seem to find any mention of it in my postg
We are currently using the pg_passwd utility
to encrypt passwords. Someone here told me that I can now encrypt passwords
within postgresql so that they are not stored in plain text in the pg_shadow
file.
Is this true? I cannot seem to find any
mention of it in my postgresql books but it's qu
Hello,
I want to encrypt passwords with Postgresql the way mySQL does it with :
UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
How can I do that ?
Thanks a lot,
Laurent
