From: | Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: MD5 password issue |
Date: | 2009-01-15 18:17:56 |
Message-ID: | 496F7DD4.8010704@netzmeister-st-pauli.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-01-15 18:18:13 | Re: fastest way to upgrade from 8.2 to 8.3 |
Previous Message | Jeremy Kister | 2009-01-15 18:02:58 | fastest way to upgrade from 8.2 to 8.3 |