pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_shadow passwd decrypt
3+ messages / 3 participants
[nested] [flat]

* pg_shadow passwd decrypt
@ 2005-03-02 16:06 Hemapriya <priyam_1121@yahoo.com>
  2005-03-02 16:16 ` Re: pg_shadow passwd decrypt Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Hemapriya @ 2005-03-02 16:06 UTC (permalink / raw)
  To: pgsql-admin; pgsql-general@postgresql.org

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/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: pg_shadow passwd decrypt
  2005-03-02 16:06 pg_shadow passwd decrypt Hemapriya <priyam_1121@yahoo.com>
@ 2005-03-02 16:16 ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2005-03-02 16:16 UTC (permalink / raw)
  To: Hemapriya <priyam_1121@yahoo.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Fwd: Re: [GENERAL] pg_shadow passwd decrypt
@ 2005-03-02 20:10 Arcane_Rhino <arcane_rhino@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Arcane_Rhino @ 2005-03-02 20:10 UTC (permalink / raw)
  To: pgsql-admin; pgsql-general@postgresql.org

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@candle.pha.pa.us> wrote:

> From: Bruce Momjian <pgman@candle.pha.pa.us>
> Subject: Re: [GENERAL] [ADMIN] pg_shadow passwd
> decrypt
> To: Hemapriya <priyam_1121@yahoo.com>
> Date: Wed, 2 Mar 2005 11:16:19 -0500 (EST)
> CC: pgsql-admin@postgresql.org,
> pgsql-general@postgresql.org
> 
> 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
> 
> ---------------------------(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
> 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-03-02 20:10 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-02 16:06 pg_shadow passwd decrypt Hemapriya <priyam_1121@yahoo.com>
2005-03-02 16:16 ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-03-02 20:10 Fwd: Re: [GENERAL] pg_shadow passwd decrypt Arcane_Rhino <arcane_rhino@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox