[GENERAL] unsubscribe

[Arcane_Rhino]

unsubscribe -farewell general [EMAIL PROTECTED]

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

   http://www.postgresql.org/docs/faq

[GENERAL] unsubscribe

[Arcane_Rhino]

 
 

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Fwd: Re: [GENERAL] [ADMIN] pg_shadow passwd decrypt

[Arcane_Rhino]

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 [EMAIL PROTECTED]
 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

Re: [GENERAL] OS X Install

[Arcane_Rhino]

Nathan:

Yes and no. My guess is that either postgres is now a default user included with the Pather version, you inadvertantly created the user once before (or during installation), or Marc Liyanage (bless his soul) created it for you during installation. Of the three, I doubt it is the latter because, though not infallable, Marc usually puts out pretty good, bug free stuff.

As for myself, I installed PG once under 10.2, then removed it and later, under 10.3 installed it again. I ran into this same problem. I thought at the time it was my fault. Now I am not so sure...

At any rate, the thing to do is to delete the user account both in User Accounts (if it exists) and in NetInfo. I cannot remember if this needs to be done as the root user. I don't think so but it might. Next reboot. This may not be technicallynecessary but a reboot covers a multitude of sins. The next thing to do is createan account namedPostgreSQL Administrator with the postgres short name. Since you now know the password, no problem.

This worked for me. Good luck.

JeffNathan Mealey [EMAIL PROTECTED] wrote:
I am trying to install PostgreSQL on OS X 10.3, using the package from Entropy.ch. The installation instructions there, as well as anywhere else I have seen them on the net, say to create a user (using the System Preferences pane) with a shortname "postgres". The problem is, this user already exists in my netinfo database/domain, and so I cannot either create a new user with the same short name, or use this user, because I do not know the password (I assume it is a system default user). Thus, I am unable to complete the installation, because I cannot run the following commands as user postgres./usr/local/bin/initdb -D /usr/local/pgsql/data/usr/local/bin/pg_ctl -D /usr/local/pgsql/data -l postgres.log startHas anyone else encountered this before? I'm so confused by this...why does this user already exist, and why can't
  I make
 use of it for this installation? Should I create a different user?NM--Nathan MealeyDirector of OperationsCycle-Smart, Inc.P.O. Box 1482Northampton, MA01061-1482[EMAIL PROTECTED](413) 587-3133(413) 210-7984 Mobile(512) 681-7043 Fax__Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com