| From: | Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> |
|---|---|
| To: | richard terry <rterry(at)pacific(dot)net(dot)au> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: de-encrypting a password |
| Date: | 2009-02-07 10:30:36 |
| Message-ID: | 498D62CC.5030509@netzmeister-st-pauli.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kulmacet101 | 2009-02-09 12:23:09 | Creating a test database and table |
| Previous Message | richard terry | 2009-02-07 05:29:24 | de-encrypting a password |