{"id":12100,"date":"2022-09-16T05:04:23","date_gmt":"2022-09-16T05:04:23","guid":{"rendered":"https:\/\/www.varidata.com\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04"},"modified":"2022-10-11T06:06:20","modified_gmt":"2022-10-11T06:06:20","slug":"how-to-install-a-postgresql-server-on-ubuntu-18-04","status":"publish","type":"kb","link":"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/","title":{"rendered":"\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f"},"content":{"rendered":"

[vc_row gap=”25″ css=”.vc_custom_1659597621929{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column css=”.vc_custom_1659597638453{margin-top: 0px !important;padding-top: 0px !important;border-radius: 20px !important;}”][vc_column_text el_class=”sub-title” css=”.vc_custom_1663923333044{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;}”]\u76ee\u7684[\/vc_column_text][vc_column_text el_class=”content” css=”.vc_custom_1663920682509{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”]PostgreSQL\u4f5c\u70ba\u4e00\u500b\u5168\u7403\u652f\u6301\u7684\u958b\u6e90\u8cc7\u6599\u5eab\uff0c\u64c1\u6709\u8d85\u904e30\u5e74\u6b77\u53f2\uff0c\u5f97\u76ca\u65bc\u5404\u7a2e\u53ef\u7528\u7684\u63d2\u4ef6\uff0c\u5b83\u4ee5\u5065\u58ef\u6027\u3001\u53ef\u4f38\u7e2e\u6027\u548c\u6027\u80fd\u800c\u805e\u540d\u3002
\n\u9996\u5148\uff0c\u5982\u679c\u8981\u5b8c\u6210PostgreSQL\u7684\u5b89\u88dd\u8207\u4f7f\u7528\uff0c\u9700\u8981\u901a\u904eSSH\u9023\u63a5\u9023\u63a5\u5230\u4f3a\u670d\u5668\uff0c\u60a8\u53ef\u4ee5\u901a\u904e\u6709\u95dc\u6559\u7a0b\u9032\u884c\u9023\u63a5\u3002\u82e5\u662f\u672c\u5730\u4f3a\u670d\u5668\uff0c\u5247\u9032\u5165\u4e0b\u4e00\u6b65\uff0c\u6253\u958b\u4f3a\u670d\u5668\u7684\u7d42\u7aef\u3002
\n[\/vc_column_text][vc_column_text el_class=”sub-title” css=”.vc_custom_1663920608580{margin-top: 0px !important;margin-bottom: 0px !important;}”]PostgreSQL\u5b89\u88dd[\/vc_column_text][vc_column_text el_class=”content” css=”.vc_custom_1663920624854{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”]\u8981\u7e7c\u7e8c\u5b89\u88ddPostgreSQL\uff0c\u8acb\u4f7f\u7528apt\u5305\u7ba1\u7406\u5668\u3002\u78ba\u4fdd\u66f4\u65b0\u7de9\u5b58\uff1a<\/p>\n

$ sudo apt update && sudo apt install postgresql postgresql-contrib<\/code><\/pre>\n
\u4f7f\u7528systemctl start\u547d\u4ee4\u78ba\u4fdd\u4f3a\u670d\u5668\u6b63\u5728\u904b\u884c\uff1a<\/p>\n
sudo systemctl start postgresql.service<\/code><\/pre>\n
[\/vc_column_text][vc_column_text el_class=”sub-title” css=”.vc_custom_1663920632420{margin-top: 0px !important;margin-bottom: 0px !important;}”]\u9a57\u8b49\u5b89\u88dd[\/vc_column_text][vc_column_text el_class=”content” css=”.vc_custom_1663920673156{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”]\u73fe\u5728\u4f60\u5df2\u7d93\u5b8c\u6210\u4e86Ubuntu\u4e0aPostgres\u7684\u5b89\u88dd\uff0c\u5404\u9805\u670d\u52d9\u5c07\u81ea\u52d5\u555f\u52d5\u3002\u4f5c\u70ba\u7b2c\u4e00\u6b65\uff0c\u901a\u904e\u7528psql\u9023\u63a5\u5230PostgreSQL\u8cc7\u6599\u5eab\u4f86\u9a57\u8b49\u5b89\u88dd\u3002
\npsql\u662f\u4e00\u500b\u547d\u4ee4\u884c\u5de5\u5177\uff0c\u7528\u4f86\u8207PostgreSQL\u4f3a\u670d\u5668\u4ea4\u4e92\u3002\u9019\u5c07\u8f38\u51fa\u4f3a\u670d\u5668\u7684\u7248\u672c\u3002<\/p>\n
sudo -u postgres psql -c \"SELECT version();\"<\/code><\/pre>\n
\u8981\u4ee5postgre\u7528\u6236\u7684\u8eab\u4efd\u767b\u9304PostgreSQL\uff0c\u4f60\u53ef\u4ee5\u4f7f\u7528psql\u3002\u53ef\u4ee5\u6309\u7167\u4e0b\u9762\u7684\u65b9\u5f0f\u9032\u884c\uff1a<\/p>\n
sudo su \u2013 postgres<\/code><\/pre>\n
\u8981\u4f7f\u7528PostgreSQL\uff0c\u8acb\u8f38\u5165\uff1a<\/p>\n
psql<\/code><\/pre>\n
\u5b83\u5c07\u6388\u4e88\u4f60\u5c0dPostgreSQL\u5be6\u4f8b\u7684\u8a2a\u554f\u6b0a\u3002\u5982\u679c\u8981\u9000\u51fa\uff0c\u53ef\u4ee5\u4f7f\u7528\uff1a<\/p>\n
\\q<\/code><\/pre>\n
[\/vc_column_text][vc_column_text el_class=”sub-title” css=”.vc_custom_1663920695091{margin-top: 0px !important;margin-bottom: 0px !important;}”]\u7ba1\u7406\u7528\u6236\u548c\u6b0a\u9650[\/vc_column_text][vc_column_text el_class=”content” css=”.vc_custom_1663920806860{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”]\u5982\u524d\u6240\u8ff0\uff0cPostgreSQL\u5047\u8a2d\u5176\u670d\u52d9\u4e2d\u5b58\u5728\u7684\u6bcf\u500b\u7528\u6236\u4e5f\u5b58\u5728\u65bc\u7cfb\u7d71\u4e2d\u3002\u70ba\u4e86\u5275\u5efa\u4e00\u500b\u65b0\u7684\u7528\u6236\uff0c\u9996\u5148\u901a\u904eadduser\u628a\u5b83\u6dfb\u52a0\u5230\u7cfb\u7d71\u4e2d\u3002<\/p>\n
$ sudo adduser tutorial<\/code><\/pre>\n
\"\"
\n\u5728\u4e0b\u9762\u7684\u4f8b\u5b50\u4e2d\uff0c\u6b63\u5728\u5275\u5efa\u4e00\u500b\u540d\u70ba “tutorial “\u7684\u7528\u6236\uff0c\u6c92\u6709\u6307\u5b9a\u5176\u4ed6\u4fe1\u606f\u3002\u4e00\u65e6\u5b8c\u6210\uff0c\u5c31\u53ef\u4ee5\u5275\u5efaPostgreSQL\u7528\u6236\u3002\u9996\u5148\u7528postgres\u7528\u6236\u767b\u9304\u3002<\/p>\n
$ sudo -i -u postgres<\/code><\/pre>\n
$ createuser --interactive<\/code><\/pre>\n
\"\"
\n\u5275\u5efa\u5b8c\u7528\u6236\u5f8c\uff0c\u8a2d\u7f6e\u4e00\u500b\u5bc6\u78bc\uff0c\u901a\u904e\u8d85\u7d1a\u7528\u6236postgres\u767b\u9304\uff0c\u4e26\u6539\u8b8a\u4f60\u525b\u525b\u5275\u5efa\u7684\u7528\u6236\u3002<\/p>\n
$ psql postgres=# ALTER USER tutorial PASSWORD 'password'; ALTER ROLE;<\/code><\/pre>\n
\u4e5f\u53ef\u4ee5\u901a\u904e\u904b\u884c\u8a72\u547d\u4ee4\u70ba\u65b0\u5275\u5efa\u7684\u7528\u6236\u5275\u5efa\u4e00\u500b\u8cc7\u6599\u5eab\u3002<\/p>\n
$ createdb tutorial<\/code><\/pre>\n
\u5b8c\u6210\u5f8c\uff0c\u9000\u51fa\u4e26\u5617\u8a66\u7528\u65b0\u5275\u5efa\u7684\u7528\u6236\u767b\u9304\u3002<\/p>\n
$ sudo -i -u tutorial<\/code><\/pre>\n
[\/vc_column_text][vc_column_text el_class=”sub-title” css=”.vc_custom_1663920813618{margin-top: 0px !important;margin-bottom: 0px !important;}”]\u555f\u7528\u5c0d\u5916\u90e8\u5ba2\u6236\u7684\u8a2a\u554f[\/vc_column_text][vc_column_text el_class=”content” css=”.vc_custom_1663921000485{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”]\u5728\u67d0\u4e9b\u60c5\u6cc1\u4e0b\uff0c\u53ef\u80fd\u9700\u8981\u5141\u8a31\u5916\u90e8\u5ba2\u6236\uff08\u4f8b\u5982\u4f60\u7684\u6a5f\u5668\uff09\u8a2a\u554f\u4f3a\u670d\u5668\u4e0a\u7684\u4e00\u500b\u6216\u591a\u500b\u8cc7\u6599\u5eab\u3002\u901a\u5e38\u60c5\u6cc1\u4e0b\uff0cPostgreSQL\u4e0d\u88ab\u914d\u7f6e\u70ba\u63a5\u53d7\u975e\u672c\u5730\u7684\u9023\u63a5\uff0c\u6240\u4ee5\u8981\u4fee\u6539\u4e00\u4e9b\u914d\u7f6e\u6587\u4ef6\u3002
\n\u7b2c\u4e00\u500b\u8981\u4fee\u6539\u7684\u6587\u4ef6\u662f\u4e3b\u914d\u7f6e\u6587\u4ef6\uff0c\u5728<\/p>\n
\/etc\/postgresql\/10\/main\/postgresql.conf.<\/code><\/pre>\n
\u8acb\u78ba\u4fdd\u7de8\u8f2f<\/p>\n
listen_addresses = 'localhost'<\/code><\/pre>\n
\u548c:<\/p>\n
listen_addresses = '*'<\/code><\/pre>\n
\u901a\u904e\u9019\u7a2e\u65b9\u5f0f\uff0c\u4f60\u901a\u77e5PostgreSQL\u671f\u671b\u5f9e\u4efb\u4f55\u7db2\u7d61\u63a5\u53e3\u9032\u5165\u7684\u9023\u63a5\u3002
\n\u8acb\u78ba\u4fdd\u4fdd\u5b58\u4f60\u7684\u4fee\u6539\uff0c\u7e7c\u7e8c\u7de8\u8f2f\/etc\/postgresql\/10\/main\/pg_hba.conf\u4e2d\u7ba1\u7406\u4f3a\u670d\u5668\u8a2a\u554f\u898f\u5247\u7684\u6587\u4ef6\uff0c\u6dfb\u52a0\u4ee5\u4e0b\u4e00\u884c\u3002<\/p>\n
host    tutorial        tutorial 0.0.0.0\/0               md5<\/code><\/pre>\n
\u9019\u7a2e\u4fee\u6539\u5141\u8a31 “tutorial “\u7528\u6236\u5f9e\u4efb\u4f55\u4e3b\u6a5f\u8a2a\u554f\u5b83\u7684\u8cc7\u6599\u5eab\u3002\u800c\u5b83\u7684\u610f\u601d\u662f\uff1a<\/p>\n
\n
    \n
  1. \u00b7 local: \u4f86\u81ea\u7cfb\u7d71\u7684\u975e\u7db2\u8def\u9023\u63a5
    \n\u00b7 host: \u4efb\u4f55\u985e\u578b\u7684TCP \/ IP\u9023\u63a5
    \n\u00b7 hostssl: \u50c5\u5728SSL\u5354\u8b70\u4e0b\u7684TCP \/ IP\u9023\u63a5
    \n\u00b7 hostnossl: \u4e0d\u4f7f\u7528SSL\u5354\u8b70\u7684TCP \/ IP\u9023\u63a5<\/li>\n
  2. tutorial: \u8cc7\u6599\u5eab\u540d\u7a31\u8981\u5141\u8a31\u8a2a\u554f\uff0c\u7528\u300call\u300d\u6307\u4ee3\u6240\u6709\u8cc7\u6599\u5eab<\/li>\n
  3. tutorial: \u7528\u6237\u540d\u6388\u4e88\u8bbf\u95ee\u6743\u9650<\/li>\n
  4. 0.0.0.0\/0: IP\u4f4d\u5740\uff0c\u5728\u60a8\u7684\u60c5\u6cc1\u4e0b\uff0c\u60a8\u6b63\u5728\u6388\u6b0a\u8a2a\u554f\u4efb\u4f55IPv4\u5730\u5740<\/li>\n
  5. md5: \u516c\u8a8d\u7684\u8a8d\u8b49\u65b9\u6cd5\uff0c\u5176\u4e2d\u4e00\u4e9b\u91cd\u8981\u7684\u662f\uff1a
    \n\u00b7 md5: \u5bc6\u78bc\u8eab\u4efd\u9a57\u8b49
    \n\u00b7 trust: \u7121\u689d\u4ef6\u63a5\u53d7\u9023\u63a5
    \n\u00b7 peer: \u4f7f\u7528\u7cfb\u7d71\u7528\u6236\u540d\u53ea\u9023\u63a5\u540c\u540d\u7684\u8cc7\u6599\u5eab<\/li>\n<\/ol>\n<\/div>\n
    \u8981\u4e86\u89e3\u66f4\u591a\u4fe1\u606f\uff0c\u8acb\u8a2a\u554f\u5730\u5740 https:\/\/www.postgresql.org\/docs\/9.1\/auth-pg-hba-conf.html <\/a>\u6216\u5b98\u65b9PostgreSQL\u6587\u6863\u3002
    \n\u5b8c\u6210\u4e4b\u5f8c\uff0c\u8acb\u91cd\u65b0\u555f\u52d5\u670d\u52d9\u4ee5\u4f7f\u6240\u6709\u66f4\u6539\u751f\u6548\uff1a<\/p>\n
    $ sudo systemctl restart postgresql<\/code><\/pre>\n
    [\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n
    [\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"featured_media":0,"template":"","kb_category":[466],"class_list":["post-12100","kb","type-kb","status-publish","hentry","kb_category-ubuntu-tc"],"acf":[],"yoast_head":"\n\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f - Varidata Limited<\/title>\n<meta name=\"description\" content=\"\u76ee\u7684PostgreSQL\u4f5c\u70ba\u4e00\u500b\u5168\u7403\u652f\u6301\u7684\u958b\u6e90\u8cc7\u6599\u5eab\uff0c\u64c1\u6709\u8d85\u904e30\u5e74\u6b77\u53f2\uff0c\u5f97\u76ca\u65bc\u5404\u7a2e\u53ef\u7528\u7684\u63d2\u4ef6\uff0c\u5b83\u4ee5\u5065\u58ef\u6027\u3001\u53ef\u4f38\u7e2e\u6027\u548c\u6027\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f - Varidata Limited\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:site_name\" content=\"Varidata Limited\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T06:06:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.varidata.com\/wp-content\/uploads\/2023\/01\/varidata_logo_black.png\" \/>\n\t<meta property=\"og:image:width\" content=\"248\" \/>\n\t<meta property=\"og:image:height\" content=\"94\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/\",\"url\":\"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/\",\"name\":\"\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f - Varidata Limited\",\"isPartOf\":{\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/#website\"},\"datePublished\":\"2022-09-16T05:04:23+00:00\",\"dateModified\":\"2022-10-11T06:06:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.varidata.com\/zh-tw\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Knowledgebase\",\"item\":\"https:\/\/www.varidata.com\/zh-tw\/kb\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/#website\",\"url\":\"https:\/\/www.varidata.com\/zh-tw\/\",\"name\":\"Varidata Limited\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.varidata.com\/zh-tw\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/#organization\",\"name\":\"Varidata\",\"url\":\"https:\/\/www.varidata.com\/zh-tw\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.varidata.com\/wp-content\/uploads\/2021\/09\/varidata_logo_white_-748x480_hor_web-1.png\",\"contentUrl\":\"https:\/\/www.varidata.com\/wp-content\/uploads\/2021\/09\/varidata_logo_white_-748x480_hor_web-1.png\",\"width\":248,\"height\":94,\"caption\":\"Varidata\"},\"image\":{\"@id\":\"https:\/\/www.varidata.com\/zh-tw\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f - Varidata Limited","description":"\u76ee\u7684PostgreSQL\u4f5c\u70ba\u4e00\u500b\u5168\u7403\u652f\u6301\u7684\u958b\u6e90\u8cc7\u6599\u5eab\uff0c\u64c1\u6709\u8d85\u904e30\u5e74\u6b77\u53f2\uff0c\u5f97\u76ca\u65bc\u5404\u7a2e\u53ef\u7528\u7684\u63d2\u4ef6\uff0c\u5b83\u4ee5\u5065\u58ef\u6027\u3001\u53ef\u4f38\u7e2e\u6027\u548c\u6027","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/","og_locale":"zh_TW","og_type":"article","og_title":"\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f - Varidata Limited","og_url":"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/","og_site_name":"Varidata Limited","article_modified_time":"2022-10-11T06:06:20+00:00","og_image":[{"width":248,"height":94,"url":"https:\/\/www.varidata.com\/wp-content\/uploads\/2023\/01\/varidata_logo_black.png","type":"image\/png"}],"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/","url":"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/","name":"\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f - Varidata Limited","isPartOf":{"@id":"https:\/\/www.varidata.com\/zh-tw\/#website"},"datePublished":"2022-09-16T05:04:23+00:00","dateModified":"2022-10-11T06:06:20+00:00","breadcrumb":{"@id":"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.varidata.com\/zh-tw\/kb\/how-to-install-a-postgresql-server-on-ubuntu-18-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.varidata.com\/zh-tw\/"},{"@type":"ListItem","position":2,"name":"Knowledgebase","item":"https:\/\/www.varidata.com\/zh-tw\/kb\/"},{"@type":"ListItem","position":3,"name":"\u5982\u4f55\u5728Ubuntu 18.04\u5b89\u88ddPostgreSQL\u4f3a\u670d\u5668\uff1f"}]},{"@type":"WebSite","@id":"https:\/\/www.varidata.com\/zh-tw\/#website","url":"https:\/\/www.varidata.com\/zh-tw\/","name":"Varidata Limited","description":"","publisher":{"@id":"https:\/\/www.varidata.com\/zh-tw\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.varidata.com\/zh-tw\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-TW"},{"@type":"Organization","@id":"https:\/\/www.varidata.com\/zh-tw\/#organization","name":"Varidata","url":"https:\/\/www.varidata.com\/zh-tw\/","logo":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/www.varidata.com\/zh-tw\/#\/schema\/logo\/image\/","url":"https:\/\/www.varidata.com\/wp-content\/uploads\/2021\/09\/varidata_logo_white_-748x480_hor_web-1.png","contentUrl":"https:\/\/www.varidata.com\/wp-content\/uploads\/2021\/09\/varidata_logo_white_-748x480_hor_web-1.png","width":248,"height":94,"caption":"Varidata"},"image":{"@id":"https:\/\/www.varidata.com\/zh-tw\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.varidata.com\/zh-tw\/wp-json\/wp\/v2\/kb\/12100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.varidata.com\/zh-tw\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.varidata.com\/zh-tw\/wp-json\/wp\/v2\/types\/kb"}],"wp:attachment":[{"href":"https:\/\/www.varidata.com\/zh-tw\/wp-json\/wp\/v2\/media?parent=12100"}],"wp:term":[{"taxonomy":"kb_category","embeddable":true,"href":"https:\/\/www.varidata.com\/zh-tw\/wp-json\/wp\/v2\/kb_category?post=12100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}