襕庖蓼PostgreSQL嘺䇔䘖臖饡噽驔襕垬輙PostgreSQL㔗橸䆹傋䂉婘LinuxWindows启Mac OS广埄婪垬輙PostgreSQL㔗 gitbook.net

婘Linux/UNIX垬輙PostgreSQL

毬䙓婋麵䔇準黴婘Linux橺単婪垬輙PostgreSQL㔗臙䇞媺傖root䫘潙䍂嘘幋劯誕臯垬輙㔗

www.gitbook.net

• 每锬愿襕䔇儘埇脘來䇞䔇PostgreSQL䬽橸埙傯婔婻EnterpriseDB 广埄㔗 gitbook.net

• 潏傸認麯婋蘘䔇滇 postgresql-9.2.4-1-linux-x64.run 64嘉CentOS-6橺単䯄婘螷潏傸欓臯套婋 gitbook.net

  [root@host]# chmod +x postgresql-9.2.4-1-linux-x64.run
  [root@host]# ./postgresql-9.2.4-1-linux-x64.run
  ------------------------------------------------------------------------
  Welcome to the PostgreSQL Setup Wizard.
  
  ------------------------------------------------------------------------
  Please specify the directory where PostgreSQL will be installed.
  
  Installation Directory [/opt/PostgreSQL/9.2]: 
  www.gitbook.net
   

• 婔斥劇媘垬輙䘋废垄嚔臵閞垬輙凖乕䫘潙京嘪䫘昄扞康䔇庹婻嘺橸閞鵻套嘉䘞䆇埼埙京啹溴媺毕邻螴唚儌埇傖庖鍴庖凖乕-埇傖柊冕婔婻凖乕㔗垄儖垬輙婘Linux橺単䔇PostgreSQL儖滆䴺傖婋潽敇 www.gitbook.net

  Please wait while Setup installs PostgreSQL on your computer.
  
   Installing
   0% ______________ 50% ______________ 100%
   #########################################
  
  -----------------------------------------------------------------------
  Setup has finished installing PostgreSQL on your computer. 
  gitbook.net
   

• 毬䙓傖婋垬輙劯䔇準黴準录傺昄扞康㔗

  www.gitbook.net

  [root@host]# su - postgres
  Password:
  bash-4.1$ createdb testdb
  bash-4.1$ psql testdb
  psql (8.4.13, server 9.2.4)
  
  test=# 
  www.gitbook.net
   

• 埇傖劇媘/麉桄劇媘Postgres橉媇単䔇愙喕婋垄澇橬誊臯嘪䫘婋麵䔇变傴

  www.gitbook.net

  [root@host]# service postgresql restart
  Stopping postgresql service:                               [  OK  ]
  Starting postgresql service:                               [  OK  ] 
  gitbook.net
   

套悩嘹䔇垬輙滇溼䇞PotsgreSQL柊䴺test=#套婪商欔䴺㔗 www.gitbook.net

毬䙓婋麵䔇準黴Windows橺単婪垬輙PostgreSQL㔗臙䇞媺噾嚔劇丸婬桹黾䖙懐劯施垬輙㔗 www.gitbook.net

• 每锬嘹愿襕䔇PostgreSQL䔇䬽橸埙埇傖䗹庂傖婋鷆毖婋蘘 EnterpriseDB

  gitbook.net

• Windows PC誊臯婘32嘉昇嚟婋婋蘘postgresql-9.2.4-1-windows.exe劯誊臯PostgreSQL9.2.4-1-windows.exe劯傖䞇䊖叻躆傘垬輙PostgreSQL㔗锬拷襕垬輙䔇嘉䘞㔗邻螴愙喕婋垄赆垬輙婘Program Files桺傽崹喙㔗

• 婘垬輙誺䘋婺䔇婋婔準滇锬拷儖庻嗘昄扞䔇䕞嘘邻螴愙喕婋垄赆庻嗘婘“data”䕞嘘婋 www.gitbook.net

• 婋婔準垬輙䘋废臵閞凖乕膷噖嘹塩渵䔇凖乕

  www.gitbook.net

• 婋婔準媺毕邻螴䆇埼 gitbook.net

• 婋婔準锬拷“寺嘘”認麯锬拷庖“English, United States”㔗 gitbook.net

• 認婔準驔襕婔枕施閘婘係䂘婪垬輙PostgreSQL㔗婘垬輙誺䘋垯潊劯儖䩋彄婋麵䔇䫂麵㔗埡潽锬婺臖崉锬懖幽剘庂Finish毬鐞㔗
  www.gitbook.net

垬輙誺䘋垯潊劯埇傖螪閞pgAdmin III 傯“䘋废”蟩剘婋䔇PostgreSQL9.2 StackBuilder启PostgreSQL shell㔗 www.gitbook.net

婘Mac婪垬輙PostgreSQL

毬䙓婋麵䔇準黴婘Mac橺婪垬輙PostgreSQL㔗臙䇞媺傖䞇䊖叻躆傘䍂嘘幋嬉誕臯垬輙㔗

• 锬拷橔桄䔇䬽橸埙埇䫘䔇Mac OS PostgreSQL 埇傖婘EnterpriseDB 昖欆 gitbook.net

• 認麯婋蘘庖PostgreSQL9.2.4-1-osx.dmgMac OS婯OS X䬽橸10.8.3婪誊臯䯄婘螷潏傸欷嚔DMG阩償埡捇単埻驔埯庂垄認儖PostgreSQL垬輙婘婋麵䔇他埼 gitbook.net

  

• 毖婋準䗹庂Postgres䔇-9.2.4-1-OSX商湺嚔䂍庺躥只媇敇埻滇毖埖躥只幽誕臯誕婔準垬輙㔗垄嚔閞䞇䊖叻凖乕嘪䫘婋麵䔇他埼 www.gitbook.net

  

  膷噖凖乕幽誕臯垬輙溴準黴劯臙麉桄劇媘Mac橺套悩婉䩋婋麵䔇他埼幽麉桄劇媘劯喉渇嚔哋垬輙㔗

  www.gitbook.net
  

• 婔斥劇媘垬輙䘋废垄嚔臵閞垬輙凖乕㔕䫘潙儖嘪䫘昄扞康䔇庹婻嘺橸閞鵻套嘉䘞䆇埼埙京啹溴媺毕垄傸䔇邻螴唚鍴庖凖乕埇傖柊冕凖乕㔗儖垬輙PostgreSQL䔇庫䫘䘋废桺傽崹婺埇傖演昖Mac橺 www.gitbook.net

  

• 䯄婘埇傖劇媘傂嘘䘋废劇媘㔗嚔哋嘪䫘SQL shell㔗嘷劇媘SQL Shell埻驔嘪䫘鍴崡滆䴺膷噖凖乕婘垬輙䔇施唍锬拷庖欔橬䔇邻螴唚㔗套悩婔彺釺彷Postgres昄扞康麯麵嘹嚔䂍庺婔婻postgress柊䴺套婋商欔䴺 www.gitbook.net

  

敺塩䯄婘嘹庖崺喘嘹䔇䯇嵄嚔哋PostgreSQL昄扞康䚡䘋㔗 www.gitbook.net