FAQ
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/

Search Discussions

  • Bruce Momjian at Mar 2, 2005 at 4:16 pm

    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-admin @
categoriespostgresql
postedMar 2, '05 at 4:06p
activeMar 2, '05 at 4:16p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Bruce Momjian: 1 post Hemapriya: 1 post

People

Translate

site design / logo © 2022 Grokbase