One can, however, simply delete the forgotten password and create another for temporary usage until the user in question can create a new one. (At least one could in 7.4, I have not tried it in 8.0.) Jeff --- Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> wrote: > From: Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> > Subject: Re: [ADMIN] pg_shadow passwd > decrypt > To: Hemapriya <priyam_1121@xxxxxxxxx> > Date: Wed, 2 Mar 2005 11:16:19 -0500 (EST) > CC: pgsql-admin@xxxxxxxxxxxxxx, > pgsql-general@xxxxxxxxxxxxxx > > 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@xxxxxxxxxxxxxxxx | (610) > 359-1001 > + If your life is a hard drive, | 13 Roberts > Road > + Christ can be your backup. | Newtown > Square, Pennsylvania 19073 > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose > an index scan if your > joining column's datatypes do not match > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
