niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » PostgreSQL
pg_shadow passwd decrypt
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
Hemapriya
*nix forums beginner


Joined: 02 Mar 2005
Posts: 1

PostPosted: Wed Mar 02, 2005 4:06 pm    Post subject: pg_shadow passwd decrypt Reply with quote

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/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Back to top
Bruce Momjian
*nix forums Guru Wannabe


Joined: 02 Mar 2005
Posts: 287

PostPosted: Wed Mar 02, 2005 4:16 pm    Post subject: Re: [ADMIN] pg_shadow passwd decrypt Reply with quote

Hemapriya wrote:
Quote:
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
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Fri Jan 09, 2009 2:58 am | All times are GMT
navigation Forum index » Databases » PostgreSQL
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Different NIS servers for passwd and autofs maps silverbyte@gmail.com networking 0 Mon Jul 17, 2006 3:16 am
No new posts isw & w2k3 r2 passwd sync Neal A. Lucier Solaris 0 Thu Jul 13, 2006 5:02 pm
No new posts NIS Client 's /etc/passwd bnswami@gmail.com networking 3 Tue Jul 11, 2006 3:35 pm
No new posts HPSBUX02103 SSRT5953 rev.3 - HP-UX passwd(1) Local Denial... Security Alert HP-UX 0 Fri Jun 30, 2006 7:35 pm
No new posts how to generate master.passwd like passwords? renouxs FreeBSD 1 Wed Jun 28, 2006 12:41 pm

Bankruptcy | Car Finance | Cheap Loan | Credit Cards | Hotels in Rome
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.1258s ][ Queries: 16 (0.0410s) ][ GZIP on - Debug on ]