{"id":41655,"date":"2023-03-03T22:46:49","date_gmt":"2023-08-30T03:50:48","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/"},"modified":"2024-04-29T17:16:40","modified_gmt":"2024-04-29T09:16:40","slug":"%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/","title":{"rendered":"\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL"},"content":{"rendered":"<p>\u64cd\u4f5c\u7cfb\u7edf\u73af\u5883\uff1aMac OS X 10.9.4<\/p>\n<h2>\u4f7f\u7528Homebrew\u5b89\u88c5<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>brew <span class=\"nb\">install <\/span>postgresql\r\n:\r\n:\r\n<span class=\"o\">==&gt;<\/span> \/usr\/local\/Cellar\/postgresql\/9.3.4\/bin\/initdb \/usr\/local\/var\/postgres\r\n<span class=\"o\">==&gt;<\/span> Summary\r\n?  \/usr\/local\/Cellar\/postgresql\/9.3.4: 2921 files, 38M\r\n<\/code><\/pre>\n<h2>\u4f7f\u7528UTF-8\u6765\u521d\u59cb\u5316\u6570\u636e\u5e93\u7684\u5b57\u7b26\u7f16\u7801\u3002<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>initdb \/usr\/local\/var\/postgres <span class=\"nt\">-E<\/span> utf8\r\nThe files belonging to this database system will be owned by user <span class=\"s2\">\"dai\"<\/span><span class=\"nb\">.<\/span>\r\nThis user must also own the server process.\r\n\r\nThe database cluster will be initialized with locale <span class=\"s2\">\"ja_JP.UTF-8\"<\/span><span class=\"nb\">.<\/span>\r\ninitdb: could not find suitable text search configuration <span class=\"k\">for <\/span>locale <span class=\"s2\">\"ja_JP.UTF-8\"<\/span>\r\nThe default text search configuration will be <span class=\"nb\">set <\/span>to <span class=\"s2\">\"simple\"<\/span><span class=\"nb\">.<\/span>\r\n\r\nData page checksums are disabled.\r\n\r\ninitdb: directory <span class=\"s2\">\"\/usr\/local\/var\/postgres\"<\/span> exists but is not empty\r\nIf you want to create a new database system, either remove or empty\r\nthe directory <span class=\"s2\">\"\/usr\/local\/var\/postgres\"<\/span> or run initdb\r\nwith an argument other than <span class=\"s2\">\"\/usr\/local\/var\/postgres\"<\/span><span class=\"nb\">.<\/span>\r\n<\/code><\/pre>\n<h2>\u68c0\u67e5Postgres\u7684\u7248\u672c<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>postgres <span class=\"nt\">--version<\/span>\r\npostgres <span class=\"o\">(<\/span>PostgreSQL<span class=\"o\">)<\/span> 9.3.4\r\n\r\n<\/code><\/pre>\n<h2>\u542f\u52a8PostgreSQL\u670d\u52a1\u5668<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>postgres <span class=\"nt\">-D<\/span> \/usr\/local\/var\/postgres\r\nLOG:  database system was shut down at 2014-07-09 00:37:58 JST\r\nLOG:  database system is ready to accept connections\r\nLOG:  autovacuum launcher started\r\n<\/code><\/pre>\n<h2>\u4f7f\u7528psql\u547d\u4ee4\u83b7\u53d6\u6570\u636e\u5e93\u5217\u8868\u3002<\/h2>\n<p>\u4e00\u65e6\u80fd\u591f\u83b7\u53d6\u6570\u636e\u5e93\u5217\u8868\uff0c\u4efb\u52a1\u5c31\u5b8c\u6210\u4e86\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>psql <span class=\"nt\">-l<\/span>\r\n                              List of databases\r\n   Name    | Owner      | Encoding |   Collate   |    Ctype    | Access privileges \r\n<span class=\"nt\">-----------<\/span>+------------+----------+-------------+-------------+-------------------\r\n postgres  | username   | UTF8     | ja_JP.UTF-8 | ja_JP.UTF-8 | \r\n template0 | username   | UTF8     | ja_JP.UTF-8 | ja_JP.UTF-8 | <span class=\"o\">=<\/span>c\/username      +\r\n           |            |          |             |             | <span class=\"nv\">dai<\/span><span class=\"o\">=<\/span>CTc\/username\r\n template1 | username   | UTF8     | ja_JP.UTF-8 | ja_JP.UTF-8 | <span class=\"o\">=<\/span>c\/username      +\r\n           |            |          |             |             | <span class=\"nv\">dai<\/span><span class=\"o\">=<\/span>CTc\/username\r\n<span class=\"o\">(<\/span>3 rows<span class=\"o\">)<\/span>\r\n<\/code><\/pre>\n<h2>\u5c06DB\u7684\u4f4d\u7f6e\u8bbe\u7f6e\u4e3a\u73af\u5883\u53d8\u91cf<\/h2>\n<pre class=\"post-pre\"><code><span class=\"c\"># PostgreSQL\u8a2d\u5b9a\uff08DB\u306e\u7f6e\u304d\u5834\u6240\uff09<\/span>\r\n<span class=\"nb\">export <\/span><span class=\"nv\">PGDATA<\/span><span class=\"o\">=<\/span>\/usr\/local\/var\/postgres\r\n<\/code><\/pre>\n<h2>\u4f7f\u7528pg_ctl\u547d\u4ee4\u542f\u52a8\u548c\u505c\u6b62PostgreSQL\u3002<\/h2>\n<h3>pg_sql\u662f\u4e00\u79cd\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u3002<\/h3>\n<p>\u636e\u8bf4pg_ctl\u662f\u7528\u4e8e\u542f\u52a8\u3001\u505c\u6b62\u3001\u91cd\u65b0\u542f\u52a8\u6216\u663e\u793a\u6b63\u5728\u8fd0\u884c\u7684postmaster\u72b6\u6001\u7684PostgreSQL\u540e\u53f0\u670d\u52a1\u5668\u7684\u5b9e\u7528\u7a0b\u5e8f\u3002<\/p>\n<p>\u901a\u5e38\u60c5\u51b5\u4e0b\uff0c\u6211\u4eec\u6309\u4ee5\u4e0b\u65b9\u5f0f\u8fdb\u884c\u542f\u52a8\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>pg_ctl <span class=\"nt\">-D<\/span> \/usr\/local\/pgsql\/data <span class=\"nt\">-l<\/span> \/var\/log\/postgres start\r\n<\/code><\/pre>\n<p>\u8bf7\u505c\u4e0b<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>pg_ctl <span class=\"nt\">-D<\/span> \/usr\/local\/pgsql\/data stop\r\n<\/code><\/pre>\n<p>\u5982\u679c\u8bbe\u7f6e\u4e86\u73af\u5883\u53d8\u91cfPGDATA\uff0c\u5219\u5728\u4f7f\u7528pg_ctl\u542f\u52a8\u6216\u505c\u6b62\u65f6\u4e0d\u9700\u8981\u4f20\u9012-D\u53c2\u6570\u3002<\/p>\n<p>\u5f00\u59cb\u8fd0\u884c<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>pg_ctl <span class=\"nt\">-l<\/span> \/usr\/local\/var\/postgres\/server.log\r\nserver starting\r\n<span class=\"err\">$<\/span>\r\n<\/code><\/pre>\n<p>[\u505c\u4e0b\u6765]<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>pg_ctl stop\r\nwaiiting <span class=\"k\">for <\/span>server to shut down.... <span class=\"k\">done\r\n<\/span>server stoped\r\n<span class=\"err\">$<\/span>\r\n<\/code><\/pre>\n<h2>\u521b\u5efa\u548c\u786e\u8ba4\u7528\u6237<\/h2>\n<h3>\u521b\u5efa\u7528\u6237<\/h3>\n<p>\u7531\u4e8e\u73af\u5883\u53d8\u91cf$USER\u88ab\u8bbe\u7f6e\u4e3a\u8d85\u7ea7\u7528\u6237\u5e76\u4e14\u76f4\u63a5\u4f7f\u7528\u4e0d\u592a\u597d\uff0c\u56e0\u6b64\u9700\u8981\u521b\u5efa\u4e00\u4e2a\u65b0\u7528\u6237\u3002<br \/>\n\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u6765\u521b\u5efaPostgres\u7528\u6237\uff0c\u4f46\u662f\u9700\u8981\u5148\u786e\u4fddpostgreSQL\u670d\u52a1\u5df2\u542f\u52a8\u3002<br \/>\n\u6b64\u5916\uff0c\u4e3a\u4e86\u7ed9\u7528\u6237\u5206\u914d\u5bc6\u7801\uff0c\u5728\u521b\u5efa\u7528\u6237\u65f6\u9700\u8981\u4f7f\u7528-P\u9009\u9879\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>createuser <span class=\"nt\">-P<\/span> &lt;pg-user&gt; \r\nEnter password <span class=\"k\">for <\/span>new role: \r\nEnter it again: \r\n<\/code><\/pre>\n<h3>\u786e\u8ba4\u5df2\u521b\u5efa\u7684\u7528\u6237<\/h3>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>psql <span class=\"nt\">-q<\/span> <span class=\"nt\">-c<\/span><span class=\"s1\">'select * from pg_user'<\/span> &lt;pg-user&gt;\r\n usename  | usesysid | usecreatedb | usesuper | usecatupd | userepl |  passwd  | valuntil | useconfig \r\n<span class=\"nt\">----------<\/span>+----------+-------------+----------+-----------+---------+----------+----------+-----------\r\n myuser   |       10 | t           | t        | t         | t       | <span class=\"k\">********<\/span> |          | \r\n postgres |    16384 | f           | f        | f         | f       | <span class=\"k\">********<\/span> |          | \r\n<span class=\"o\">(<\/span>2 rows<span class=\"o\">)<\/span>\r\n\r\n<\/code><\/pre>\n<h2>\u5efa\u7acbDB<\/h2>\n<p>\u672c\u6b21\u4f7f\u7528createdb\u547d\u4ee4\u521b\u5efa\u4e86\u6570\u636e\u5e93\uff0c\u540d\u79f0\u4e3aexample-db\u3002<\/p>\n<pre class=\"post-pre\"><code>$ createdb example-db -O &lt;pg-user&gt;\r\n<\/code><\/pre>\n<p>\u9009\u9879<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">-O [\u30aa\u30fc\u30ca\u30fc] or (&#8211;owner)<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u4f5c\u6210\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6240\u6709\u8005\u3068\u306a\u308b\u30e6\u30fc\u30b6\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/ul>\n<h2>\u5728PSL\u4e2d\u8fde\u63a5\u5230\u6570\u636e\u5e93\u3002<\/h2>\n<h3>\u6570\u636e\u5e93\u8fde\u63a5<\/h3>\n<p>\u53ef\u4ee5\u4f7f\u7528psql\u547d\u4ee4\u8fde\u63a5\u5230\u6570\u636e\u5e93\uff0c\u5e76\u6267\u884cSQL\u7b49\u64cd\u4f5c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>psql <span class=\"nt\">-U<\/span> &lt;pg-user&gt; example-db\r\npsql<span class=\"o\">(<\/span>9.4.0<span class=\"o\">)<\/span>\r\nType <span class=\"s2\">\"help\"<\/span> <span class=\"k\">for <\/span><span class=\"nb\">help\r\n\r\n<\/span>example-db<span class=\"o\">=&gt;<\/span>\r\n<\/code><\/pre>\n<p>\u9009\u9879<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">-f [\u30d5\u30a1\u30a4\u30eb\u540d] or (&#8211;filename)<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u6307\u5b9a\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u554f\u3044\u5408\u308f\u305b\u306e\u30bd\u30fc\u30b9\u3068\u3057\u3066\u4f7f\u7528\u3057\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">-U [\u63a5\u7d9a\u30e6\u30fc\u30b6\u540d] or (&#8211;username)<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">PostgreSQL\u306b\u63a5\u7d9a\u3059\u308b\u30e6\u30fc\u30b6\u540d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">-h [\u30db\u30b9\u30c8\u540d] or (&#8211;hostname)<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">PostgreSQL\u306b\u63a5\u7d9a\u3059\u308b\u30db\u30b9\u30c8\u540d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/ul>\n<h3>\u786e\u8ba4DB\u548c\u8868\u4fe1\u606f<\/h3>\n<div>\n<div class=\"post-table\">\u30b3\u30de\u30f3\u30c9\u8aac\u660e\\lDB\u4e00\u89a7\\c [DB\u540d]DB\u306e\u5207\u308a\u66ff\u3048\\d\u3000\u3000\u3000\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7\\d [\u30c6\u30fc\u30d6\u30eb\u540d]\u30c6\u30fc\u30d6\u30eb\u306e\u9805\u76ee(\u30d5\u30a3\u30fc\u30eb\u30c9)\u78ba\u8a8d\\qpsql\u3092\u7d42\u4e86\u3059\u308b<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u64cd\u4f5c\u7cfb\u7edf\u73af\u5883\uff1aMac OS X 10.9.4 \u4f7f\u7528Homebrew\u5b89\u88c5 $ brew install post [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41655","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL - Blog - Silicon Cloud<\/title>\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.silicloud.com\/zh\/blog\/\u5728mac\u4e0a\u5b89\u88c5postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"\u64cd\u4f5c\u7cfb\u7edf\u73af\u5883\uff1aMac OS X 10.9.4 \u4f7f\u7528Homebrew\u5b89\u88c5 $ brew install post [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728mac\u4e0a\u5b89\u88c5postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-30T03:50:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T09:16:40+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u626c\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/\",\"name\":\"\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-08-30T03:50:48+00:00\",\"dateModified\":\"2024-04-29T09:16:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL - Blog - Silicon Cloud","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.silicloud.com\/zh\/blog\/\u5728mac\u4e0a\u5b89\u88c5postgresql\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL","og_description":"\u64cd\u4f5c\u7cfb\u7edf\u73af\u5883\uff1aMac OS X 10.9.4 \u4f7f\u7528Homebrew\u5b89\u88c5 $ brew install post [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728mac\u4e0a\u5b89\u88c5postgresql\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-08-30T03:50:48+00:00","article_modified_time":"2024-04-29T09:16:40+00:00","author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/","name":"\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-08-30T03:50:48+00:00","dateModified":"2024-04-29T09:16:40+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5728Mac\u4e0a\u5b89\u88c5PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8mac%e4%b8%8a%e5%ae%89%e8%a3%85postgresql\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41655"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41655\/revisions"}],"predecessor-version":[{"id":86581,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41655\/revisions\/86581"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}