Re: User names

"Glen and Rosanne Eustace" <agree@godzone.net.nz> writes:
> Is there a defined max length for postgreSQL user names ?
> If there is and it is 8, then createuser should enforce it.
> If the length is > 8 then pg_passwd needs fixing so that it doesn't
> truncate.

A quick look in the pg_passwd sources indeed shows some hardwired limits
on both username and password length.  This is bogus.  Anyone want to
contribute a patch?

For the record, the max username length should be NAMEDATALEN-1, and
the password field in pg_shadow is 'text', so it should be happy to
take any password that you're willing to type ;-).  However, crypt
password processing depends on crypt(3), which more than likely ignores
characters beyond the eighth on most platforms.

            regards, tom lane