Skip site navigation (1) Skip section navigation (2)

authentication and usermanagement

From: Lukas Ertl <l(dot)ertl(at)univie(dot)ac(dot)at>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: authentication and usermanagement
Date: 2001-06-08 16:27:54
Message-ID: 20010608181219.P514-100000@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I want to setup PostgreSQL on a machine with many users, and to restrict
access to the database I set the authtype in pg_hba.conf for local users
to "password", and set $PGDATA/passwords as the password-file.

Now I'm pretty confused:

When I create a user with "createuser", I have to give her a password with
"pg_passwd $PGDATA/passwords". Then she can connect to the db. (But she
doesn't get listed in $PGDATA/global/pg_pwd.)

When I create her with "createuser -P", I get asked for a password, but
that password will not be stored in $PGDATA/passwords, instead I get an
entry in $PGDATA/global/pg_pwd, with the username, several "x"s and the
password in clear text. But I still have to give her a password with
"pg_passwd $PGDATA/passwords" so that she can connect.

So I want to know what $PGDATA/global/pg_pwd is good for, and why I have
to still give her a password, although she was created with "createuser


Lukas Ertl                          eMail: l(dot)ertl(at)univie(dot)ac(dot)at
WWW-Redaktion                       Tel.:  (+43 1) 4277-14073
Zentraler Informatikdienst (ZID)    Fax.:  (+43 1) 4277-9140
der Universit├Ąt Wien

pgsql-novice by date

Next:From: Tom LaneDate: 2001-06-08 16:49:15
Subject: Re: dump database fails
Previous:From: HanusanDate: 2001-06-07 23:56:02
Subject: dump database fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group