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
network...
--
With Best Regards.
Rashid N. Achilov (RNA1-RIPE), Web: http://granch.ru/~shelton
Granch Ltd. system administrator, e-mail: achilov@granch.ru
PGP: 83 CD E2 A7 37 4A D5 81 D6 D6 52 BF C9 2F 85 AF 97 BE CB 0A