用户名长度字符限制？ [英] username length character limits?
问题描述
请CC我：
如果我创建用户''web_user''
，密码为''密码''
我可以使用''psql'连接就好了。
如果我创建用户''D1Khb2g5m7FGk_web_user''
，密码为''password' '
我无法使用''psql''连接，我收到身份验证错误。
-------------- ---------------
任何人都有任何想法为什么？
------------- ----------------
PG_VERSION说它是7.3。我不知道如何更准确地找出颠覆它。
-------------------- -------（播出结束）---------------------------
提示3：如果通过Usenet发布/阅读，请发送适当的
subscribe-nomail命令到 ma **** ***@postgresql.org ，以便您的
消息可以干净地通过邮件列表
Please CC me:
If I create the user ''web_user''
with password ''password''
I can connect using ''psql'' just fine.
If I create the user ''D1Khb2g5m7FGk_web_user''
with password ''password''
I CANNOT connect using ''psql'', I get authentication error.
-----------------------------
ANYONE have any ideas why?
-----------------------------
PG_VERSION says it''s 7.3. I don''t know how to find out any more accurately the subversion of that.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
推荐答案
我现在尝试了一个等长的名字，并且它登录正常：
''t012345678901_web_user''用pword''密码''工作正常。
以下问题是一致的。我可以删除并重新调整用户，并且始终无法使用该名称登录。我可以成功改变用户，所以系统找到它，我就不能对它进行身份验证。
Dennis Gearon写道：
I now have tried an equal length name, and it logs in fine:
''t012345678901_web_user'' with pword ''password'' works fine.
The problem below is consistent. I can drop and recrate the user, and it always cannot be logged into using that name. I can successfully alter the user, so the system is finding it, I just can''t authenticate into it.
Dennis Gearon wrote:
请CC我：
如果我创建用户''web_user''
密码''密码''
我可以使用''psql''连接就好了。
如果我创建用户''D1Khb2g5m7FGk_web_user''
密码''密码''
我无法使用''psql''连接，我收到身份验证错误。
<
-----------------------------
任何人有什么想法？
---- -------------------------
PG_VERSION说这是7.3。我不知道如何找到更准确的颠覆它。
Please CC me:
If I create the user ''web_user''
with password ''password''
I can connect using ''psql'' just fine.
If I create the user ''D1Khb2g5m7FGk_web_user''
with password ''password''
I CANNOT connect using ''psql'', I get authentication error.
-----------------------------
ANYONE have any ideas why?
-----------------------------
PG_VERSION says it''s 7.3. I don''t know how to find out any more
accurately the subversion of that.
------------ ---------------（播出结束）---------------------------
提示4：不要杀死-9''邮政局长
---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster
另一个不起作用的名字是''H1q2W3e4R5_web_user ''。
似乎不喜欢数字和字母之间的多次交替。
Dennis Gearon写道：
another name that does not work is ''H1q2W3e4R5_web_user''.
It seems to not like many alternations between numbers and letters.
Dennis Gearon wrote:
请CC我：
如果我创建用户''web_user''
密码''密码''
我可以使用''psql'连接很好。
如果我创建用户''D1Khb2g5m7FGk_web_user''
密码''密码''
我无法使用''psql''连接，我得到身份验证错误。
-----------------------------
任何人有什么想法？<
-----------------------------
PG_V ERSION说这是7.3。我不知道如何找到更准确的颠覆它。
Please CC me:
If I create the user ''web_user''
with password ''password''
I can connect using ''psql'' just fine.
If I create the user ''D1Khb2g5m7FGk_web_user''
with password ''password''
I CANNOT connect using ''psql'', I get authentication error.
-----------------------------
ANYONE have any ideas why?
-----------------------------
PG_VERSION says it''s 7.3. I don''t know how to find out any more
accurately the subversion of that.
------------ ---------------（播出结束）---------------------------
提示5：您是否检查了我们广泛的常见问题解答？
http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
尝试过两个下划线和短名称：
H1q2W_web_user
，只有一个下划线和一个长名称：
H1q2W3e4R5t6Y7u8Iweb_user
只有一个单核和一个短名称：
H1q2Wweb_user
没有下划线和长名称：
H1q2W3e4R5t6Y7u8Iwebuser
没有欠压和短名称：
H1q2W3webuser
------ -------------------------------------------------- ------------
这些名称中的任何一个都不会被用户命名为T他是密码''密码''。
---------------------------------- ----------------------------------
我不知道为什么。
这里说什么是合法的：
长度
个字符
字符集（？）
用户名？
一个下划线和一个简短的名字。
Dennis Gearon写道：
tried it with two underscores and short name:
H1q2W_web_user
with only one underscore and a long name:
H1q2W3e4R5t6Y7u8Iweb_user
with only oneunderscore and a short name:
H1q2Wweb_user
with no underscore and a long name:
H1q2W3e4R5t6Y7u8Iwebuser
with no underschore and a short name:
H1q2W3webuser
--------------------------------------------------------------------
NONE OF THESE NAMES WORK AS USER NAMES WITH THE PASSWORD ''password''.
--------------------------------------------------------------------
I have no idea why.
Where does it say what is the legal:
length
characters
character set (?)
for user names?
one underscore and a short name.
Dennis Gearon wrote:
请CC我：
如果我创建用户''web_user''
密码' '密码''
我可以使用''psql''连接就好了。
如果我创建用户''D1Khb2g5m7FGk_web_user''
密码''密码''
我无法使用''psql''连接，我收到身份验证错误。
------------------------ -----
任何人有什么想法为什么？
-----------------------------
PG_VERSION说这是7.3。我不知道如何更准确地找到颠覆它。
Please CC me:
If I create the user ''web_user''
with password ''password''
I can connect using ''psql'' just fine.
If I create the user ''D1Khb2g5m7FGk_web_user''
with password ''password''
I CANNOT connect using ''psql'', I get authentication error.
-----------------------------
ANYONE have any ideas why?
-----------------------------
PG_VERSION says it''s 7.3. I don''t know how to find out any more accurately the subversion of that.
------------ ---------------（播出结束）---------------------------
提示2：您可以使用取消注册命令一次性取消所有列表
（发送取消注册YourEmailAddressHere到 ma ******* @ postgresql.org ）
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
这篇关于用户名长度字符限制？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
