[lug] postgres

Riggs, Rob RRiggs at doubleclick.net
Wed Jan 9 23:34:39 MST 2002


Ah, yes. That one. pg_shadow is a *table*. "select * from pg_shadow". Notice
how the passwords are in plain-text. Ouch. I still don't get that.

-Rob


-----Original Message-----
From: Hugh Brown [mailto:hugh at vecna.com]
Sent: Wednesday, January 09, 2002 8:44 PM
To: lug at lug.boulder.co.us
Subject: Re: [lug] postgres


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


_______________________________________________
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