[lug] postgres

[Hugh Brown]

I am in a situation where I have to learn postgres admin.

I am beating my head against how it does user authentication.

If I create a user with a password it creates a file named pg_pwd in
$PGDATA/global but it stores it in clear text.  I can use pg_passwd
pg_shadow to create a username:password pair where the password is
stored crypt'ed.  How do I get postgres to look there rather than in the
pg_pwd file?

Hugh
-- 
------------------------------------
System Administrator/Unix Consultant
hugh at vecna.com
Vecna Technologies, Inc
6525 Belcrest Rd, Suite 612
Hyattsville MD, 20782
301.864.7253
http://www.vecna.com