Re: MD5 password issue

Hi Joshua

Joshua D. Drake schrieb:
> On Thu, 2009-01-15 at 18:05 +0100, Andreas Wenk wrote:
>
>> postgres=# SELECT rolname,rolpassword from pg_authid;
>>   rolname  |             rolpassword
>> - -----------+-------------------------------------
>>  postgres  |
>>  pgadmin   | plaintext
>>  odie      | md5passswwwwooooorrrd
>>
>> The user odie was created with:
>> CREATE ROLE odie LOGIN ENCRYPTED PASSWORD 'feedme';
>>
>> The user pgadmin was created with:
>> $ createuser -a -d -P -N -U postgres pgadmin
>>
>
> Per the help. You need to pass -E to have it be an encrypted (md5 hash)
> style password.

Sure - I know .... we added -N so that the password is not encrypted

What version of PostgreSQL is this as I recall all newer
> versions do this by default.
>
this was made with a 8.1 version ...

> Usage:
>   createuser [OPTION]... [ROLENAME]
>
> Options:
>   -s, --superuser           role will be superuser
>   -S, --no-superuser        role will not be superuser
>   -d, --createdb            role can create new databases
>   -D, --no-createdb         role cannot create databases
>   -r, --createrole          role can create new roles
>   -R, --no-createrole       role cannot create roles
>   -l, --login               role can login (default)
>   -L, --no-login            role cannot login
>   -i, --inherit             role inherits privileges of roles it is a
>                             member of (default)
>   -I, --no-inherit          role does not inherit privileges
>   -c, --connection-limit=N  connection limit for role (default: no
> limit)
>   -P, --pwprompt            assign a password to new role
>   -E, --encrypted           encrypt stored password
>   -N, --unencrypted         do not encrypt stored password
>   -e, --echo                show the commands being sent to the server
>   --help                    show this help, then exit
>   --version                 output version information, then exit
>
> Connection options:
>   -h, --host=HOSTNAME       database server host or socket directory
>   -p, --port=PORT           database server port
>   -U, --username=USERNAME   user name to connect as (not the one to
> create)
>   -W, --password            force password prompt
>
> If one of -s, -S, -d, -D, -r, -R and ROLENAME is not specified, you will
> be prompted interactively.
>
>
> Joshua D. Drake
>
>

--

St.Pauli - Hamburg - Germany

Andreas Wenk