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
Fwd: Re: [ADMIN] pg_shadow passwd decrypt
Post new topic   Reply to topic Page 1 of 1 [1 Post] View previous topic :: View next topic
Author Message
Arcane_Rhino
*nix forums beginner


Joined: 02 Mar 2005
Posts: 1

PostPosted: Wed Mar 02, 2005 8:10 pm    Post subject: Fwd: Re: [ADMIN] pg_shadow passwd decrypt Reply with quote
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:

Quote:
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



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [1 Post] View previous topic :: View next topic
The time now is Thu Jan 08, 2009 8:14 am | All times are GMT
navigation Forum index » Databases » PostgreSQL
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts unable to start db2 admin server qin_23 IBM DB2 5 Wed Jul 19, 2006 3:31 pm
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 Small job for proficient qmail/linux admin Alan Valentine Qmail 0 Thu Jul 13, 2006 2:56 pm
No new posts NIS Client 's /etc/passwd bnswami@gmail.com networking 3 Tue Jul 11, 2006 3:35 pm

Debt Consolidation | Loans | Loans | Encyclopaedia | Loans
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.1156s ][ Queries: 16 (0.0491s) ][ GZIP on - Debug on ]