pgAdmin doesn't use encryption itself, that tickbox just makes it use the ENCRYPTED keyword in CREATE/ALTER USER sql statements in PostgreSQL 7.2+. Check out the PostgreSQL 7.2 documentation for details on using the encrypted passwords.
BTW. PostgreSQL uses MD5.
Regards, Dave.
Hi Dave,
ok thank you!
but nevertheless the encryption of the user password is not a bad idea, so what encyption method is used by pgadmin?
i mean i create a user with pgadmin, specify a password for the user
if i check the pg_shadow table i see a long text in the pasword field.
if i want to connect this user to the database, what kind encyption method i have to use?
Ivan
----- Original Message -----
Sent: Wednesday, March 13, 2002 12:15 PM
Subject: RE: [pgadmin-support] password encyption
Hi,
Under Tools -> Options, on the PostgreSQL tab, uncheck the box labelled 'Use Encrypted Passwords', and then alter the password for your user.
Regards, Dave.
Hi All,
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem
Best Regards,
Iván Horváth
Chief Programmer
Alcatel NSD
PMS 2000 Product Team
H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page
Anyone who has never made a mistake has never tried anything new./Albert Einstein/