[lug] postgres

Hugh Brown hugh at vecna.com
Wed Jan 9 20:43:40 MST 2002


I've stared at that a fair bit.  Where is pg_shadow supposed to be?  I
can't find it in my installation.  I'm using the stock rpm's for rh72.

Hugh


On Wed, 2002-01-09 at 19:23, Evelyn Mitchell wrote:
> Hi Hugh,
> 
> Take a look at 
>   http://www.postgresql.org/idocs/index.php?client-authentication.html
> 
> It explains how to select different authentication methods.
> 
> You'll want to use "CREATE USER" and "ALTER USER" to manage
> the passwords. They should be stored in pg_shadow. 
> Then, the line in the pg_hba.conf file for that database
> should have an authtype of 'crypt' (to use encrypted passwords)
> or 'password' (to use plain text passwords).
> 
> Evelyn Mitchell
> efm at tummy.com
> 
> On Wed, Jan 09, 2002 at 06:42:09PM -0500, Hugh Brown wrote:
> > 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
> > 
> > 
> > _______________________________________________
> > Web Page:  http://lug.boulder.co.us
> > Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug





More information about the LUG mailing list