Subject: Re: [GENERAL] Database users Passwords
From: Jeff Davis <pgsql@j-davis.com>
To: DEV <dev@umpa-us.com>
Cc: pgsql-general@postgresql.org, pgsql-docs@postgresql.org
In-Reply-To: <002c01c6f1fa$652d3f60$0b01a8c0@LT003>
References: <002c01c6f1fa$652d3f60$0b01a8c0@LT003>
Content-Type: text/plain; charset=UTF-8
Date: Tue, 17 Oct 2006 09:36:25 -0700
Message-Id: <1161102985.31645.100.camel@dogma.v10.wvs>
Mime-Version: 1.0
Content-Transfer-Encoding: quoted-printable

On Tue, 2006-10-17 at 10:41 -0400, DEV wrote:
> Hello all,
>=20
>       I have user information in a table that I want to use to add
> users to the user roles tables that are part of postgresql.  My
> question is this: the passwords in my user table are in there as a
> text file with the data being encrypted using the crypt function, is
> there a way I can use this crypt password when I do a =E2=80=9CCREATE ROL=
E
> userid LOGIN PASSWORD 'crypt password' NOSUPERUSER INHERIT NOCREATEDB
> NOCREATEROLE=E2=80=9D  I know that in the current CREATE ROLE I have list=
ed
> will take a clear text password and encrypt it for me.  What do I need
> to change to use an encrypted password?
>=20

If user is foo and password is bar, do:

=3D# select md5('barfoo');
LOG:  duration: 0.140 ms  statement: select md5('barfoo');
               md5
----------------------------------
 96948aad3fcae80c08a35c9b5958cd89
(1 row)

=3D# create role foo login password 'md596948aad3fcae80c08a35c9b5958cd89'
nosuperuser inherit nocreatedb nocreaterole;

This seems to be lacking in the docs. At least, the only place I found
this information was a user comment in the 8.0 docs. Is this already in
the 8.1 docs? Should we add a description of the way postgresql does the
md5 hashes in the CREATE ROLE section?

Regards,
	Jeff Davis