{"id":2315,"date":"2015-08-25T16:50:15","date_gmt":"2015-08-25T08:50:15","guid":{"rendered":"http:\/\/www.chenlianfu.com\/?p=2315"},"modified":"2015-08-25T16:50:25","modified_gmt":"2015-08-25T08:50:25","slug":"postgresql-%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e7%ae%80%e5%8d%95%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"http:\/\/www.chenlianfu.com\/?p=2315","title":{"rendered":"PostGreSQL \u6570\u636e\u5e93\u7684\u7b80\u5355\u4f7f\u7528"},"content":{"rendered":"<h1>1. PostGreSQL \u7b80\u4ecb<\/h1>\n<p>PostgreSQL \u662f\u4e00\u79cd\u975e\u5e38\u590d\u6742\u7684\u5bf9\u8c61-\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff08ORDBMS\uff09\uff0c\u4e5f\u662f\u76ee\u524d\u529f\u80fd\u6700\u5f3a\u5927\uff0c\u7279\u6027\u6700\u4e30\u5bcc\u548c\u6700\u590d\u6742\u7684\u81ea\u7531\u8f6f\u4ef6\u6570\u636e\u5e93\u7cfb\u7edf\u3002\u6709\u4e9b\u7279\u6027\u751a\u81f3\u8fde\u5546\u4e1a\u6570\u636e\u5e93\u90fd\u4e0d\u5177\u5907\u3002\u8fd9\u4e2a\u8d77\u6e90\u4e8e\u4f2f\u514b\u5229\uff08BSD\uff09\u7684\u6570\u636e\u5e93\u7814\u7a76\u8ba1\u5212\u76ee\u524d\u5df2\u7ecf\u884d\u751f\u6210\u4e00\u9879\u56fd\u9645\u5f00\u53d1\u9879\u76ee\uff0c\u5e76\u4e14\u6709\u975e\u5e38\u5e7f\u6cdb\u7684\u7528\u6237\u3002<br \/>\n<a href=\"http:\/\/bbs.chinaunix.net\/thread-1688208-1-1.html\" target=\"_blank\">\u6709\u4eba\u5c06 PostgreSQL \u548c MySQL \u4f5c\u4e86\u6bd4\u8f83<\/a>\uff0c PostgreSQL \u8c8c\u4f3c\u5b8c\u80dc\u3002<\/p>\n<h1>2. PostGreSQL \u7684\u5b89\u88c5<\/h1>\n<pre>\r\n# yum install postgres*\r\n# \/etc\/init.d\/postgresql start       \u542f\u52a8\u6570\u636e\u5e93\uff0c\u7b2c\u4e00\u6b21\u542f\u52a8\u5219\u4f1a\u521d\u59cb\u5316\u6570\u636e\u5e93\u3002\r\n<\/pre>\n<h1>3. PostGreSQL \u7684\u7b80\u5355\u4f7f\u7528<\/h1>\n<p>\u53c2\u8003\u81ea\uff1a<a href=\"http:\/\/www.php100.com\/manual\/PostgreSQL8\/\" target=\"_blank\"> PostgreSQL 8.1 \u4e2d\u6587\u6587\u6863<\/a><\/p>\n<h2>3.1 \u767b\u5f55 PostGreSQL \u7684\u547d\u4ee4<\/h2>\n<p>\u4f7f\u7528 psql \u547d\u4ee4\u767b\u5f55 PostGreSQL \u6570\u636e\u5e93\u3002<br \/>\n\u521d\u59cb\u5316 PostGreSQL \u6570\u636e\u5e93\u540e\uff0c\u5219\u4f1a\u6709\u540d\u4e3a postgres \u548c tempalte1 \u7684\u6570\u636e\u5e93\uff0c\u6709\u4e00\u4e2a\u540d\u4e3a postgres \u7684\u7528\u6237\uff0c\u65e0\u5bc6\u7801\u767b\u5f55\u3002<br \/>\n\u4f8b\u5982\uff0c\u4f7f\u7528 postgres \u7528\u6237\u767b\u5f55 postgres \u6570\u636e\u5e93<\/p>\n<pre>\r\n$ psql postgres postgres\r\npsql (8.4.18)\r\nType \"help\" for help.\r\n\r\npostgres=#\r\n<\/pre>\n<p>psql\u7684\u7528\u6cd5\u4e0e\u5e38\u7528\u53c2\u6570\uff1a<\/p>\n<pre>\r\npsql [options] [DBNAME [USERNAME]]\r\n\r\nDBNAME\r\n    \u8bbe\u7f6e\u8981\u767b\u5f55\u7684\u6570\u636e\u5e93\uff0c\u9ed8\u8ba4\u4e3a\u5f53\u524d\u7cfb\u7edf\u7528\u6237\u540d\r\nUSERNAME\r\n    \u8bbe\u7f6e\u767b\u5f55\u6570\u636e\u5e93\u7684\u7528\u6237\uff0c\u9ed8\u8ba4\u4e3a\u5f53\u524d\u7cfb\u7edf\u7528\u6237\u540d\r\n-h | --host=HOSTNAME\r\n    \u8bbe\u7f6e\u8fde\u63a5\u7684\u670d\u52a1\u5668\u540d\uff0cdefault: localhost\r\n-p | --port=PORT\r\n    \u8bbe\u7f6e\u7aef\u53e3\uff0c default: 5432\r\n-U | --username=USERNAME\r\n    \u8bbe\u7f6e\u767b\u5f55\u7684\u7528\u6237\u540d\uff0c\u9ed8\u8ba4\u4e3a\u5f53\u524d\u7cfb\u7edf\u7528\u6237\u540d\r\n<\/pre>\n<h2>3.2 \u7b80\u5355\u5e38\u7528\u7684 postgresql \u547d\u4ee4\u884c<\/h2>\n<p>\u767b\u5f55 postgresql \u6570\u636e\u5e93\u540e\uff0c\u63d0\u793a\u7b26\u4ee5\u767b\u5f55\u7684\u6570\u636e\u540d\u52a0\u7b49\u4e8e\u53f7\u8868\u793a\u3002\u6b64\u65f6\uff0c\u53ef\u4ee5\u8f93\u5165 postgresql \u547d\u4ee4\u884c\u7528\u4e8e\u8f85\u52a9\u6570\u636e\u5e93\u64cd\u4f5c\u3002\u8fd9\u4e9b\u547d\u4ee4\u884c\u4ee5 \\ \u5f00\u5934\u3002\u51e0\u4e2a\u7b80\u5355\u5e38\u7528\u7684\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n<pre>\r\n\\c[onnect] DBNAME\r\n    \u5207\u6362\u6570\u636e\u5e93\r\n\\l[+]\r\n    \u5217\u4e3e\u6570\u636e\u5e93\r\n\\dt\r\n    \u5217\u4e3e\u8868\r\n\\d TABLENAME\r\n    \u67e5\u770b\u8868\u7684\u7ed3\u6784\r\n\\q\r\n    \u9000\u51fa postgresql\r\n\\cd [DIR]\r\n    \u5207\u6362 linux \u7cfb\u7edf\u7684\u5de5\u4f5c\u76ee\u5f55\r\n\\! [COMMAD]\r\n    \u6267\u884c linux \u7cfb\u7edf\u547d\u4ee4\u3002\u6bd4\u5982 \\! ls --color \u7528\u4e8e\u6253\u5370\u51fa\u5f53\u524d\u76ee\u5f55\u7684\u6587\u4ef6\u540d\uff1b \u4f46\u662f \\! cd \u547d\u4ee4\u65e0\u6548\u3002\r\n\\?\r\n    \u5c55\u793a\u6240 postgresql \u7684\u547d\u4ee4\u884c\u5e2e\u52a9\u6587\u6863\r\n\\h CREATE ROLE\r\n    \\h \u4e3a\u67e5\u770b SQL \u547d\u4ee4\u7684\u5e2e\u52a9\u4fe1\u606f\uff0c\u4ee5\u4e0a\u547d\u4ee4\u4e3a\u67e5\u770b CREATE ROLE \u547d\u4ee4\u7684\u8be6\u7ec6\u5e2e\u52a9\u3002\r\n<\/pre>\n<h2>3.3 \u7b80\u5355\u5e38\u7528\u7684 SQL \u547d\u4ee4<\/h2>\n<p>\u4f7f\u7528 SQL \u8bed\u8a00\u5bf9 postgresql \u7684\u6570\u636e\u5e93\u548c\u8868\u8fdb\u884c\u64cd\u4f5c\uff0c\u521d\u5b66\u8005\u9700\u8981\u7684 SQL \u547d\u4ee4\uff1a<\/p>\n<pre>\r\nCREATE DATABASE chado\r\n    \u521b\u5efa\u540d\u4e3a chado \u7684\u6570\u636e\u5e93\r\nDROP DATABASE chado\r\n    \u5220\u9664\u540d\u4e3a chado \u7684\u6570\u636e\u5e93\r\nCREATE ROLE chenlianfu [PASSWORD '123456']\r\n    \u521b\u5efa\u540d\u4e3a chenlianfu \u7684\u7528\u6237\r\nDROP ROLE chenlianfu\r\n    \u5220\u9664\u540d\u4e3a chenlianfu \u7684\u7528\u6237\r\n<\/pre>\n<h2>3.4 PostGres \u7684 linux \u547d\u4ee4<\/h2>\n<p>\u5728 linux \u7ec8\u7aef\u4e0b\uff0c\u53ef\u4ee5\u4f7f\u7528\u4e00\u4e9b\u547d\u4ee4\u6765\u64cd\u4f5c PostGres \u6570\u636e\u5e93\u3002<\/p>\n<pre>\r\ncreatedb\r\n    \u521b\u5efa\u6570\u636e\u5e93\r\ncreatelang\r\n    \u7ed9\u6570\u636e\u5e93\u5b89\u88c5\u8bed\u8a00\r\ncreateuser\r\n    \u7528\u6237\u521b\u5efa\u7528\u6237\r\ndropdb\r\n    \u5220\u9664\u6570\u636e\u5e93\r\ndroplang\r\n    \u4ece\u6570\u636e\u5e93\u5220\u9664\u8bed\u8a00\r\ndropuser\r\n    \u5220\u9664\u7528\u6237\r\ninitdb\r\n    \u521d\u59cb\u5316\u6570\u636e\u5e93\r\npg_dump\r\n    \u5c06\u6570\u636e\u5e93\u8f6c\u6362\u4e3a\u6587\u672c\u6587\u4ef6\uff0c\u7528\u4e8e\u5907\u4efd\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1. PostGreSQL \u7b80\u4ecb PostgreSQL \u662f\u4e00\u79cd\u975e\u5e38\u590d\u6742\u7684\u5bf9\u8c61-\u5173 &hellip; <a href=\"http:\/\/www.chenlianfu.com\/?p=2315\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[76,10,77],"_links":{"self":[{"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=\/wp\/v2\/posts\/2315"}],"collection":[{"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2315"}],"version-history":[{"count":1,"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=\/wp\/v2\/posts\/2315\/revisions"}],"predecessor-version":[{"id":2316,"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=\/wp\/v2\/posts\/2315\/revisions\/2316"}],"wp:attachment":[{"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2315"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.chenlianfu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}