Thread: de-encrypting a password

de-encrypting a password

From
richard terry
Date:
I wondered if it was possible to see what the original password put in was if
one does a select * from pg_shadow where user = 'the_user'; and you end up
with passwd as a great big long string.

regards

Ricahrd

Re: de-encrypting a password

From
Andreas Wenk
Date:

richard terry schrieb:
> I wondered if it was possible to see what the original password put in was if
> one does a select * from pg_shadow where user = 'the_user'; and you end up
> with passwd as a great big long string.
>
> regards
>
> Ricahrd
>
Hi,

all passwords are stored as MD5 strings in PostgreSQL. MD5 is a one way
encryption. So as long as you do not use a paramater (-N) while creating
a new user, the password will be encrypted and you cannot see it in
plain text.

Cheers

Andy
--

St.Pauli - Hamburg - Germany

Andreas Wenk