1.3. 录傺婔婻昄扞康

䩋䩋嘹脘劥螪閞昄扞康橉媇単䔇丸婔婻冋床儌滇臘五录傺婔婻昄扞康㔗婔埄誊臯五䔇 PostgreSQL 橉媇単埇傖䞇䊖螩崔昄扞康㔗锔婩潏傸嚔婺懟婻釹䕞启懟婻䫘潙剘䋸嘪䫘婔婻昄扞康㔗

誗䗹䞇䊖叻埇脘噾䂟婺嘹录傺庖埇傖嘪䫘䔇昄扞康㔗傡庫臖噾䂟只臬嘹認婻昄扞康䔇劉庖㔗套悩認湙嘹儌埇傖䩕䘖認婔準幽婫虿彄婋婔誗㔗

襕录傺婔婻桄䔇昄扞康(婘潏傸認婻冋床麯埆 mydb)嘹埇傖嘪䫘婋麵䔇变傴

$ createdb mydb

垄庫臖䫘潊婋麵認湙䔇巉庫

CREATE DATABASE

套悩認湙闼幽認婔準儌潊媘庖嘹儌埇傖媘䘖橸誗嘍婋䔇鄘彖庖㔗

套悩嘹䩋彄䌂嚚婋麵認湙䔇媇敇

createdb: command not found

闼幽儌滇 PostgreSQL 澇橬垬輙喘襕幽滇儌湹橸澇輙婪㔕襕幽滇抩䘵虇冇澇橬螆䘞溼䇞㔗儺臘䫘䂺凹虇冇脄䫘臖变傴臘臘

$ /usr/local/pgsql/bin/createdb mydb

婘嘹䔇誗䗹婪認婻虇冇埇脘婉婔湙㔗臙启䞇䊖叻蕫係潡蔙䩋䩋垬輙毺凚傖诙埡溼䇞䔇嘉䘞㔗

埥崡婔䓉巉庫埇脘滇認湙

createdb: could not connect to database postgres: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

認懟叿五橉媇単澇橬劇媘潡蔙澇橬婘 createdb 鵇橘䔇婄桹劇媘㔗劯湙嘹幘襕演昖垬輙毺凚潡蔙欆䞇䊖叻㔗

埥崡婔婻巉庫埇脘滇認湙

createdb: could not connect to database postgres: FATAL:  role "joe" does not exist

婘認麯柊彄庖嘹躻噌䔇䍂鍖劉㔗套悩䞇䊖叻澇橬婺嘹录傺 PostgreSQL 䫘潙婊埙儌嚔埏䫘認底䯄償㔗PostgreSQL 䫘潙婊埙启淉嘩係䂘䫘潙婊埙滇婉劯䔇㔗套悩嘹儌滇䞇䊖叻埗黙䆹18傖诙埡录傺䫘潙婊埙䔇婞媷㔗嘹驔襕埻潊垬輙 PostgreSQL 䔇淉嘩係䂘䫘潙䔇躆傘(锔婩滇 postgres)欉脘录傺丸婔婻䫘潙婊埙㔗幘橬埇脘滇蕋庽 PostgreSQL 䫘潙劉启淉嘩係䂘䫘潙劉婉劯認䓉愙喕婋嘹驔襕嘪䫘 -U 嚔噿潡蔙嘪䫘 PGUSER 䯇嵄埻麟弄滯 PostgreSQL 䫘潙劉㔗

套悩嘹橬婻昄扞康䫘潙婊埙嘖滇澇橬录傺昄扞康欔驔襕䔇溄鍊闼幽嘹嚔䩋彄婋麵䔇婩薪

createdb: database creation failed: ERROR:  permission denied to create database

幽麂欔橬䫘潙鄘䂟誺庖录傺桄昄扞康䔇毽溄㔗套悩 PostgreSQL 拐䂺婺嘹录傺昄扞康闼幽嘹驔襕螷誗䗹䞇䊖叻蕋庽嘹录傺昄扞康䔇溄鍊㔗庺䯄認䓉愙喕施臙吘臵嘹䔇誗䗹䞇䊖叻㔗套悩嘹躻噌垬輙庖 PostgreSQL 闼幽嘹庫臖傖嘹劇媘昄扞康橉媇単䔇䫘潙躆傘䍂鍖䇽劯埗蔄欋喯垯潊溄鍊䔇蕋庽噖嘩㔗[1]

嘹誻埇傖䫘噽垄劉庖录傺昄扞康㔗PostgreSQL 噕螩嘹婘婔婻誗䗹婪录傺傂懟昄麟䔇昄扞康㔗昄扞康劉媙釂滇傖庖應嚔崘幽婫償庯 63 婻庖严阪㔗婔婻桹冪䔇啔濘滇录傺启嘹嘷嬉䫘潙劉劯劉䔇昄扞康㔗螩崔噖噙啺螆垄婺䚺䩕䔇昄扞康劉欔傖認湙埇傖誗䩕显髞㔗襕录傺認湙䔇昄扞康埻驔襕髞噖

$ createdb

套悩嘹喉幘婉愿嘪䫘嘹䔇昄扞康庖闼幽嘹埇傖役鍴垄㔗懫套套悩嘹滇昄扞康 mydb 䔇匂婂(录傺庺)闼幽嘹儌埇傖䫘婋麵䔇变傴役鍴垄

$ dropdb mydb

凹庯認溇变傴蔯蘔昄扞康劉婉滇䚺䩕䔇䫘潙劉嘹媙釂滯䇞弄滯垄㔗認婻媘嘩䬷䊖婪儖欔橬婯臖昄扞康䕩噿䔇桺傽鄘役鍴幽婫婉埇敵崉啹溴啔認傽庋幋嬉婔垔襕愿橙斔㔗

敘崔噿庯 createdb 启 dropdb 䔇媇敇埇傖婘 createdb 启 dropdb 償誗欆彄㔗