[lug] postgres

Evelyn Mitchell efm at tummy.com
Thu Jan 10 09:33:03 MST 2002


On Wed, Jan 09, 2002 at 10:53:06PM -0500, Hugh Brown wrote:
> how does one access the system catalogs?

http://www.postgresql.org/idocs/index.php?pg-system-catalogs.html
(I searched for 'system catalog' on postgresql.org, it's in
the docs.) They are all tables. So to find out what databases 
are available:
  select * from pg_database;

> Also, is there a way to keep passwords from showing up in the file
> pg_pwd in plaintext when they are set?

Don't know.

Evelyn Mitchell
efm at tummy.com

> 
> 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