Skip site navigation (1) Skip section navigation (2)

Re: crypt autorization

From: "Rashid N(dot) Achilov" <shelton(at)sentry(dot)granch(dot)ru>
To: Calvin NG <calvinng(at)brel(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: crypt autorization
Date: 2001-07-16 03:47:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Saturday 14 July 2001 18:17, you wrote:
> Greetings,
>   use pg_passwd to create the pwd file,
>   e.g.
>     # pg_passwd /usr/local/pgsql/data/pg_pwd
>   this will prompt you for the user ID, and then the password (and
> confirmation).
>   I would suggest executing the command as the user running the database
> daemon.

As root...:-) I did this, and change passowrd in password file from 
pg_hba.conf. Anything, `psql -d template1 -U shelton` said "Password 
authentication failed for user 'shelton'" ('shelton' exist in pg_pwd and 
password file). And pg_pwd zeroed when I create/drop users through 
'createuser' or 'dropuser' scripts. I don't doubt about pg_pwd. I doubt, how
can I setup 'crypt' autorization type. I wouldn't like clear password in 
   With Best Regards.
   Rashid N. Achilov (RNA1-RIPE), Web:
   Granch Ltd. system administrator, e-mail: achilov(at)granch(dot)ru
   PGP: 83 CD E2 A7 37 4A D5 81 D6 D6 52 BF C9 2F 85 AF 97 BE CB 0A

In response to


pgsql-admin by date

Next:From: Calvin NGDate: 2001-07-16 05:26:31
Subject: Re: crypt autorization
Previous:From: Chris RuprechtDate: 2001-07-16 00:11:25
Subject: Performance issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group