Re: User names

"Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)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