From: Fred Cox <sailorfred@yahoo.com>
To: pgsql-docs@postgresql.org <pgsql-docs@postgresql.org>
Subject: Algorithm for generating md5 encrypted password not found in documentation
Date: Wed, 19 Oct 2011 12:04:25 -0700 (PDT)
Message-ID: <1319051065.63555.YahooMailNeo@web160714.mail.bf1.yahoo.com> (raw)
On http://www.postgresql.org/docs/9.1/interactive/sql-createrole.html there is mention of a possibility of setting a password for a new role by supplying it in md5 format. This format doesn't seem to be documented.
"If the presented password string is already in MD5-encrypted format, then it is stored encrypted as-is"
Looking at pg_dumpall let me know that the string needs to start with "md5" but a naive running if my password through the command line md5 utility and prefixing "md5" was not correct.
If the algorithm is documented elsewhere, can it be linked from this page?
Thanks,
Fred
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: sailorfred@yahoo.com
Subject: Re: Algorithm for generating md5 encrypted password not found in documentation
In-Reply-To: <1319051065.63555.YahooMailNeo@web160714.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox