CREATEUSER
目录
CREATEUSER
NAMESYNOPSIS
DESCRIPTION æè¿°
OPTIONS é项
ENVIRONMENT ç¯å¢
DIAGNOSTICS è¯æ
EXAMPLES ä¾å
SEE ALSO åè§
è¯è
è·
NAME
createuser - å®ä¹ä¸ä¸ªæ°ç PostgreSQL ç¨æ·å¸æ·
SYNOPSIS
createuser [ option... ] [ username ]
DESCRIPTION æè¿°
createuser å建ä¸ä¸ªæ°ç PostgreSQL ç¨æ·ãåªæè¶çº§ç¨æ·ï¼å¨ pg_shadow 表ä¸è®¾ç½®äº usesuper çç¨æ·ï¼å¯ä»¥å建æ°ç PostgreSQL ç¨æ·ã å æ¤ï¼ createuser å¿é¡»ç±æä½å¯ä»¥ä»¥ PostgreSQL è¶çº§ç¨æ·è¿æ¥çç¨æ·æ§è¡ã
ä½ä¸ºè¶çº§ç¨æ·åæ¶ä¹æå³çç»å¼æ°æ®åºå访é®æ£æ¥çè½åï¼ å æ- ¤æ们åºè¯¥å°èµäºè¶çº§ç¨æ·æéã
createuser æ¯ SQL å½ä»¤ CREATE USER [create_user(7)] çå°è£ã å æ- ¤ï¼ç¨é£ç§æ¹æ³å建æ°ç¨æ·é½æ²¡ä»ä¹ç¹å«çã
OPTIONS é项
createuser
æ¥åä¸åå½ä»¤è¡åæ°ï¼
username
声æè¦å建ç PostgreSQL ç¨æ·å称ã 该å称å¿é¡»å¨ææ PostgreSQL ç¨æ·ä¸å¯ä¸ã
|
-a |
--adduser
å许该æ°å»ºç¨æ·å建å¶ä»ç¨æ·ã(注æ: å®éä¸è¿æ ·åç¸å½äºæè¿ä¸ªæ°ç¨æ·åæäº superuserï¼åªä¸è¿è¿ä¸ªé项å½åå¾æ¯è¾çã)
|
-A |
--no-adduser
ä¸å许该æ°å»ºç¨æ·å建å¶ä»ç¨æ·ã ï¼ä¹å°±æ¯è¯´ï¼è¯¥ç¨æ·æ¯ä¸ä¸ªæ®éç¨æ·ï¼ä¸æ¯è¶çº§ç¨æ·ï¼ã
|
-d |
--createdb
å许该æ°å»ºç¨æ·å建æ°æ®åºã
|
-D |
--no-createdb
ç¦æ¢è¯¥æ°å»ºç¨æ·å建æ°æ®åºã
|
-e |
||
|
--echo |
åæ¾ createuser çæçå½ä»¤å¹¶åéç»æå¡å¨ã
|
-E |
--encrypted
对ä¿åå¨æ°æ®åºéçç¨æ·å£ä»¤å å¯ãå¦æ没æ声æï¼ å使ç¨ç¼ºçå¼ã
-i number
--sysid number
å许ä½ç»æ°ç¨æ·ä½¿ç¨é缺çç¨æ·æè¯ãè¿ä¸ªä¹ä¸æ¯å¿é¡»çï¼ä½æ¯æäºäººå欢è¿æ·ã
|
-N |
--unencrypted
ä¸å¯¹ä¿åå¨æ°æ®åºéçç¨æ·å£ä»¤å å¯ãå¦æ没æ声æï¼ å使ç¨ç¼ºçå¼ï¼
|
-P |
--pwprompt
å¦æç»åºï¼createuser å°ååºä¸ä¸ªæ示符è¦æ±è¾å¥æ°ç¨æ·çå£ä»¤ã å¦æä½ ä¸æç®ç¨å£ä»¤è®¤è¯ï¼é£ä¹è¿æ¯ä¸å¿è¦çã
|
-q |
--quiet
ä¸æ¾ç¤ºååºã
å¦æ没æå¨å½ä»¤è¡ä¸å£°æå称åå¶ä»çä¸äºç¼ºå°çä¿¡æ¯ï¼èæ¬ä¼æç¤ºä½ è¾å¥ã
createuser
è¿æ¥åä¸åå½ä»¤è¡åæ°ç¨ä½è¿æ¥åæ°ï¼
-h host
--host host
声æè¿è¡æå¡å¨çæºå¨ç主æºåã å¦ææ°å¼ä»¥ææå¼å¤´ï¼åå®è¢«ç¨åå° Unix åå¥æ¥åçè·¯å¾ã
-p port
--port port
声ææå¡å¨ æ£å¨ä¾¦å¬çäºèç½ TCP 端å£å·ææ¬å°Unixåå¥æ¥å- çæ件æ©å±ï¼æ述符ï¼ã
-U username
--username username
è¿æ¥çç¨æ·åï¼ä¸æ¯è¦å建çç¨æ·åï¼ã
|
-W |
--password
强å¶å£ä»¤æ示ï¼ä¸æå¡å¨è¿æ¥çå£ä»¤ï¼ä¸æ¯æ°ç¨æ·çå£ä»¤ãï¼
ENVIRONMENT ç¯å¢
|
PGHOST |
||
|
PGPORT |
||
|
PGUSER |
缺çè¿æ¥åæ°ã
DIAGNOSTICS è¯æ
å¦æåºç°é误ï¼å°ä¼æ¾ç¤ºå端é误信æ¯ãåé CREATE USER [create_user(7)] å psql(1) è·åå¯è½ä¿¡æ¯æè¿°ãæ°æ®åºæå¡å¨å¿é¡»å¨ç®æ 主æºä¸è¿è¡ã åæ ·ï¼ä»»ä½ libpq å端åºä½¿ç¨ç缺çè¿æ¥è®¾ç½®åç¯å¢åéé½å°éç¨ã
EXAMPLES ä¾å
å¨ç¼ºçæ°æ®åºæå¡å¨ä¸å建ä¸ä¸ªç¨æ· joeï¼
$ createuser
joe
Is the new user allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users?
(y/n) n
CREATE USER
ç¨å¨ä¸»æºedenä¸çæå¡å¨å建ç¨æ· joeï¼ç«¯å£æ¯ 5000ï¼é¿åæ示并ä¸æ¾ç¤ºæ§è¡çå½ä»¤ï¼
$ createuser
-p 5000 -h eden -D -A -e joe
CREATE USER "joe" NOCREATEDB NOCREATEUSER
CREATE USER
SEE ALSO åè§
dropuser(1), CREATE USER [create_user(7)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh