Thread: pg_shadow passwd decrypt

Hi,

Does postgres support any system functions that
decode/decrypt the user passwords stored in pg_shadow
system catalog.

Is there a way to retrieve the passwords, if
forgotten.

Thanks in Advance.

Priya








__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/

Hemapriya wrote:
> Hi,
>
> Does postgres support any system functions that
> decode/decrypt the user passwords stored in pg_shadow
> system catalog.
>
> Is there a way to retrieve the passwords, if
> forgotten.

No.  They are MD5 and are designed to be unencryptable.

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