FAQ

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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
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