Hello,
On Wed, 22 Dec 1999, Nicolas Huillard wrote:
> The problem of the pg_passwd command (used to feed the password.dbname
> files) is that is only stores 8 characters from the username provided,
> even if you typed more, and even if the Postgres username have more
> characters. I don't know if one can add the missing characters or
> create the file with another tool (htpasswd from Apache). The problem
> is that you can't log in using the 8 chars username, nor the full
> username stored in the pg_shadow table.
Yeah, the tools provided to do what I've suggested are not ideal, but
there are ways around it. To start with, you could simply restrict
usernames to 8 characters.
You can make up password files using other tools - the encrypt command in
OpenBSD works for sure.
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com
************
