{"id":1530,"date":"2022-05-14T17:22:06","date_gmt":"2022-05-14T09:22:06","guid":{"rendered":"https:\/\/fromideatocreation.com\/?p=667"},"modified":"2023-07-02T17:16:20","modified_gmt":"2023-07-02T09:16:20","slug":"%e5%a6%82%e4%bd%95%e5%9c%a8-ubuntu-20-04-%e4%b8%8a%e5%ae%89%e8%a3%85-postgresql","status":"publish","type":"post","link":"https:\/\/fromideatocreation.com\/?p=1530","title":{"rendered":"\u5982\u4f55\u5728 Ubuntu 20.04 \u4e0a\u5b89\u88c5 PostgreSQL"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u4ecb\u7d39<\/h2>\n\n\n\n<p>PostgreSQL \u6216 Postgres \u662f\u4e00\u7a2e\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\uff0c\u63d0\u4f9b SQL \u67e5\u8a62\u8a9e\u8a00\u7684\u5be6\u73fe\u3002 \u5b83\u7b26\u5408\u6a19\u6e96\u4e26\u5177\u6709\u8a31\u591a\u9ad8\u7d1a\u529f\u80fd\uff0c\u4f8b\u5982\u53ef\u9760\u6027\u8207\u4e26\u884c\u6027\u3002<\/p>\n\n\n\n<p>\u672c\u6559\u5b78\u5c07\u5f15\u5c0e\u60a8\u5728 Ubuntu 20.04 \u670d\u52d9\u5668\u4e0a\u5feb\u901f\u555f\u52d5\u548c\u904b\u4f5c Postgres\uff0c\u5f9e\u5b89\u88dd PostgreSQL \u5230\u8a2d\u5b9a\u65b0\u7528\u6236\u548c\u8cc7\u6599\u5eab\u3002 <\/p>\n\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c 1 \u6b65 \u2014 \u5b89\u88dd PostgreSQL<\/h2>\n\n\n\n<p>\u8981\u5b89\u88dd PostgreSQL\uff0c\u9996\u5148\u66f4\u65b0\u670d\u52d9\u5668\u672c\u5730\u7684\u5957\u4ef6\u7d22\u5f15\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo apt update<\/code><\/pre>\n\n\n\n<p>\u7136\u5f8c\uff0c\u5b89\u88dd Postgres \u5957\u4ef6\u4ee5\u53ca\u6dfb\u52a0\u4e00\u4e9b\u984d\u5916\u5be6\u7528\u7a0b\u5f0f\u548c\u529f\u80fd\u7684 <code>-contrib<\/code> \u5957\u4ef6\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo apt install postgresql postgresql-contrib<\/code><\/pre>\n\n\n\n<p>\u78ba\u4fdd\u670d\u52d9\u5df2\u555f\u52d5\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl start postgresql.service<\/code><\/pre>\n\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c 2 \u6b65 \u2014 \u4f7f\u7528 PostgreSQL \u89d2\u8272\u548c\u8cc7\u6599\u5eab<\/h2>\n\n\n\n<p>\u9810\u8a2d\u60c5\u6cc1\u4e0b\uff0cPostgres \u4f7f\u7528\u4e00\u500b\u7a31\u70ba\u201c\u89d2\u8272\u201d(Role)\u7684\u6982\u5ff5\u4f86\u8655\u7406\u8eab\u4efd\u9a57\u8b49\u548c\u6388\u6b0a\u3002 \u5728\u67d0\u4e9b\u65b9\u9762\uff0c\u5b83\u5011\u985e\u4f3c\u65bc\u5e38\u898f\u7684 Unix \u98a8\u683c\u7684\u7528\u6236\u548c\u7d44\u3002<\/p>\n\n\n\n<p>\u5b89\u88dd\u5f8c\uff0cPostgres \u4f7f\u7528 ident \u8eab\u4efd\u9a57\u8b49\uff0c\u9019\u610f\u5473\u8457\u5b83\u5c07 Postgres \u89d2\u8272\u8207\u5339\u914d\u7684 Unix\/Linux \u7cfb\u7d71\u5e33\u6236\u76f8\u95dc\u806f\u3002 \u5982\u679c Postgres \u4e2d\u5b58\u5728\u89d2\u8272\uff0c\u5247\u5177\u6709\u76f8\u540c\u540d\u7a31\u7684 Unix\/Linux \u7528\u6236\u540d\u53ef\u4ee5\u4f5c\u70ba\u8a72\u89d2\u8272\u767b\u9304\u3002<\/p>\n\n\n\n<p>\u5b89\u88dd\u904e\u7a0b\u5efa\u7acb\u4e86\u4e00\u500b\u540d\u70ba <strong>postgres <\/strong>\u7684\u7528\u6236\u5e33\u6236\uff0c\u8a72\u5e33\u6236\u8207\u9810\u8a2d Postgres \u89d2\u8272\u76f8\u95dc\u806f\u3002 \u6709\u5e7e\u7a2e\u65b9\u6cd5\u53ef\u4ee5\u5229\u7528\u6b64\u5e33\u6236\u8a2a\u554f Postgres\u3002 \u4e00\u7a2e\u65b9\u6cd5\u662f\u901a\u904e\u57f7\u884c\u4ee5\u4e0b\u547d\u4ee4\u5207\u63db\u5230\u670d\u52d9\u5668\u4e0a\u7684 <strong>postgres <\/strong>\u5e33\u6236\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo -i -u postgres<\/code><\/pre>\n\n\n\n<p>\u7136\u5f8c\u60a8\u53ef\u4ee5\u901a\u904e\u57f7\u884c\u4ee5\u4e0b\u547d\u4ee4\u8a2a\u554f Postgres \u547d\u4ee4\u5217\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ psql<\/code><\/pre>\n\n\n\n<p>\u9019\u5c07\u4f7f\u60a8\u767b\u9304\u5230 PostgreSQL \u547d\u4ee4\u5217\uff0c\u5f9e\u9019\u88e1\u60a8\u53ef\u4ee5\u7acb\u5373\u81ea\u7531\u5730\u8207\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\u4e92\u52d5\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">postgres=# \\q<\/code><\/pre>\n\n\n\n<p>\u8981\u9000\u51fa PostgreSQL \u547d\u4ee4\u5217\uff0c\u8acb\u57f7\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n\n\n\n<p>\u9019\u5c07\u4f7f\u60a8\u56de\u5230 postgres Linux \u547d\u4ee4\u5217\u3002 \u8981\u8fd4\u56de\u5230\u60a8\u7684\u5e38\u898f\u7cfb\u7d71\u7528\u6236\uff0c\u8acb\u57f7\u884c <code>exit<\/code> \u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">postgres@server:~$ exit<\/code><\/pre>\n\n\n\n<p>\u9023\u63a5\u5230 Postgres \u547d\u4ee4\u5217\u7684\u53e6\u4e00\u7a2e\u65b9\u6cd5\u662f\u4f7f\u7528 <code>sudo<\/code> \u76f4\u63a5\u4ee5 <strong>postgres <\/strong>\u5e33\u6236\u57f7\u884c <code>psql<\/code> \u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo -u postgres psql<\/code><\/pre>\n\n\n\n<p>\u9019\u5c07\u4f7f\u60a8\u76f4\u63a5\u767b\u9304 Postgres\uff0c\u800c\u7121\u9700\u4e2d\u9593\u7684 <code>bash<\/code> shell\u3002<\/p>\n\n\n\n<p>\u540c\u6a23\uff0c\u60a8\u53ef\u4ee5\u901a\u904e\u57f7\u884c\u4ee5\u4e0b\u547d\u4ee4\u9000\u51fa\u4e92\u52d5\u5f0f Postgres \u5c0d\u8a71\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">postgres=# \\q<\/code><\/pre>\n\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c 3 \u6b65 \u2014 \u5efa\u7acb\u65b0\u89d2\u8272<\/h2>\n\n\n\n<p>\u5982\u679c\u60a8\u4ee5 <strong>postgres <\/strong>\u5e33\u6236\u767b\u9304\uff0c\u5247\u53ef\u4ee5\u901a\u904e\u57f7\u884c\u4ee5\u4e0b\u547d\u4ee4\u4f86\u5efa\u7acb\u65b0\u89d2\u8272\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">postgres@server:~$ createuser --interactive<\/code><\/pre>\n\n\n\n<p>\u76f8\u53cd\uff0c\u5982\u679c\u60a8\u66f4\u559c\u6b61\u5c0d\u6bcf\u500b\u547d\u4ee4\u4f7f\u7528 <code>sudo<\/code> \u800c\u4e0d\u5f9e\u60a8\u7684\u666e\u901a\u5e33\u6236\u5207\u63db\uff0c\u8acb\u904b\u884c\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">sudo -u postgres createuser --interactive<\/code><\/pre>\n\n\n\n<p>\u7121\u8ad6\u54ea\u7a2e\u65b9\u5f0f\uff0c\u8173\u672c\u90fd\u6703\u63d0\u793a\u60a8\u4e00\u4e9b\u9078\u64c7\uff0c\u4e26\u6839\u64da\u60a8\u7684\u56de\u61c9\u57f7\u884c\u6b63\u78ba\u7684 Postgres \u547d\u4ee4\u4f86\u5efa\u7acb\u7b26\u5408\u60a8\u8981\u6c42\u7684\u7528\u6236\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"\" class=\"\">Output\nEnter name of role to add: sammy\nShall the new role be a superuser? (y\/n) y<\/code><\/pre>\n\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c 4 \u6b65 \u2014 \u5efa\u7acb\u65b0\u7684\u8cc7\u6599\u5eab<\/h2>\n\n\n\n<p>Postgres \u8eab\u4efd\u9a57\u8b49\u7cfb\u7d71\u9810\u8a2d\u505a\u51fa\u7684\u53e6\u4e00\u500b\u5047\u8a2d\u662f\uff0c\u5c0d\u65bc\u4efb\u4f55\u7528\u65bc\u767b\u9304\u7684\u89d2\u8272\uff0c\u8a72\u89d2\u8272\u5c07\u64c1\u6709\u4e00\u500b\u53ef\u4ee5\u8a2a\u554f\u7684\u540c\u540d\u8cc7\u6599\u5eab\u3002<\/p>\n\n\n\n<p>\u9019\u610f\u5473\u8457\u5982\u679c\u60a8\u5728\u4e0a\u4e00\u7bc0\u4e2d\u5275\u5efa\u7684\u7528\u6236\u540d\u70ba <strong>sammy<\/strong>\uff0c\u5247\u8a72\u89d2\u8272\u5c07\u5617\u8a66\u9023\u63a5\u5230\u9810\u8a2d\u60c5\u6cc1\u4e0b\u4e5f\u7a31\u70ba\u201csammy\u201d\u7684\u8cc7\u6599\u5eab\u3002 \u60a8\u53ef\u4ee5\u4f7f\u7528 <code>createdb<\/code> \u547d\u4ee4\u5efa\u7acb\u9069\u7576\u7684\u8cc7\u6599\u5eab\u3002<\/p>\n\n\n\n<p>\u5982\u679c\u60a8\u4ee5 postgres \u5e33\u6236\u767b\u9304\uff0c\u60a8\u53ef\u4ee5\u8f38\u5165\u5982\u4e0b\u5167\u5bb9\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">postgres@server:~$ createdb sammy<\/code><\/pre>\n\n\n\n<p>\u76f8\u53cd\uff0c\u5982\u679c\u60a8\u66f4\u559c\u6b61\u5c0d\u6bcf\u500b\u547d\u4ee4\u4f7f\u7528 sudo \u800c\u4e0d\u5f9e\u60a8\u7684\u666e\u901a\u5e33\u6236\u5207\u63db\uff0c\u5247\u53ef\u4ee5\u904b\u884c\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo -u postgres createdb sammy<\/code><\/pre>\n\n\n\n<div style=\"height:12px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u6709\u6642\u5019\u60a8\u7684\u4f5c\u696d\u7cfb\u7d71\u53ef\u80fd\u6c92\u6709 <code>createuser<\/code> \u6216 <code>createdb<\/code> \u9019\u4e9b\u4e8c\u9032\u4f4d\u6a94\u6848\uff0c\u53c8\u6216\u8005\u60a8\u53ef\u80fd\u51fa\u65bc\u67d0\u7a2e\u539f\u56e0\u60f3\u7d14\u7cb9\u901a\u904e psql \u57f7\u884c\u6b64\u64cd\u4f5c\uff0c\u90a3\u9ebc\u9019\u4e9b\u6307\u4ee4\u6703\u662f\u60a8\u60f3\u8981\u7684\uff1a<\/p>\n\n\n\n<p>\u4f9d\u5e8f\u70ba\u767b\u5165 PostgreSQL \u547d\u4ee4\u5217\uff0c\u65bc\u88e1\u9762\u5efa\u7acb\u8cc7\u6599\u5eab\u3001\u5efa\u7acb\u4f7f\u7528\u8005\u8207\u5bc6\u78bc\u3001\u4e26\u4e14\u6388\u4e88\u8a72\u4f7f\u7528\u8005\u64cd\u4f5c\u8cc7\u6599\u5eab\u7684\u6240\u6709\u6b0a\u9650\u3002 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo -u postgres psql\npostgres=# CREATE DATABASE yourdbname;\npostgres=# CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';\npostgres=# GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;<\/code><\/pre>\n\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c 5 \u6b65 \u2014 \u4f7f\u7528\u65b0\u89d2\u8272\u6253\u958b Postgres \u63d0\u793a<\/h2>\n\n\n\n<p>\u8981\u4f7f\u7528\u57fa\u65bc <code>ident<\/code> \u7684\u8eab\u4efd\u9a57\u8b49\u767b\u9304\uff0c\u60a8\u9700\u8981\u4e00\u500b\u8207\u60a8\u7684 Postgres \u89d2\u8272\u548c\u8cc7\u6599\u5eab\u540c\u540d\u7684 Linux \u7528\u6236\u3002<\/p>\n\n\n\n<p>\u5982\u679c\u60a8\u6c92\u6709\u5339\u914d\u7684 Linux \u7528\u6236\u53ef\u7528\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528 <code>adduser<\/code> \u547d\u4ee4\u5efa\u7acb\u4e00\u500b\u3002 \u60a8\u5fc5\u9808\u5f9e\u5177\u6709 <code>sudo<\/code> \u6b0a\u9650\u7684\u975e root \u5e33\u6236\u57f7\u884c\u6b64\u64cd\u4f5c\uff08\u610f\u601d\u662f\uff0c\u672a\u4ee5 <strong>postgres <\/strong>\u7528\u6236\u8eab\u4efd\u767b\u9304\uff09\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo adduser sammy<\/code><\/pre>\n\n\n\n<p>\u4e00\u65e6\u9019\u500b\u65b0\u5e33\u6236\u53ef\u7528\uff0c\u60a8\u53ef\u4ee5\u901a\u904e\u57f7\u884c\u4ee5\u4e0b\u547d\u4ee4\u5207\u63db\u4e26\u9023\u63a5\u5230\u8cc7\u6599\u5eab\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo -i -u sammy\n$ psql<\/code><\/pre>\n\n\n\n<p>\u6216\u8005\uff0c\u60a8\u53ef\u4ee5\u57f7\u884c\u6b64\u4e00\u884c\u64cd\u4f5c\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo -u sammy psql<\/code><\/pre>\n\n\n\n<p>\u5018\u82e5\u6240\u6709\u7684\u5143\u4ef6\u90fd\u6b63\u78ba\u8a2d\u5b9a\u4e86\u7684\u8a71\uff0c\u6b64\u547d\u4ee4\u5c07\u81ea\u52d5\u8b93\u60a8\u767b\u9304\u3002<\/p>\n\n\n\n<p>\u5982\u679c\u60a8\u5e0c\u671b\u60a8\u7684\u7528\u6236\u9023\u63a5\u5230\u4e0d\u540c\u7684\u8cc7\u6599\u5eab\uff0c\u60a8\u53ef\u4ee5\u901a\u904e\u8cc7\u6599\u5eab\uff0c\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ psql -d postgres<\/code><\/pre>\n\n\n\n<p>\u767b\u9304\u5f8c\uff0c\u60a8\u53ef\u4ee5\u901a\u904e\u57f7\u884c\u4ee5\u4e0b\u547d\u4ee4\u6aa2\u67e5\u60a8\u7576\u524d\u7684\u9023\u63a5\u72c0\u614b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">sammy=# \\conninfo<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"\" class=\"\">Output\nYou are connected to database \"sammy\" as user \"sammy\" via socket in \"\/var\/run\/postgresql\" at port \"5432\".<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL \u6216 Postgres \u662f\u4e00\u7a2e\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\uff0c\u63d0\u4f9b SQL \u67e5\u8a62\u8a9e\u8a00\u7684\u5be6\u73fe\u3002 \u5b83\u7b26\u5408\u6a19\u6e96\u4e26\u5177\u6709\u8a31\u591a\u9ad8\u7d1a\u529f\u80fd\uff0c\u4f8b\u5982\u53ef\u9760\u6027\u8207\u4e26\u884c\u6027\u3002<\/p>\n","protected":false},"author":1,"featured_media":714,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"qubely_global_settings":"","qubely_interactions":"","inline_featured_image":false,"_ti_tpc_template_sync":false,"_ti_tpc_template_id":"","footnotes":""},"categories":[106,95],"tags":[125,126],"class_list":["post-1530","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-106","category-programming","tag-postgresql","tag-126"],"acf":[],"aioseo_notices":[],"qubely_featured_image_url":{"full":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"landscape":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"portraits":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",411,320,false],"thumbnail":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",150,117,false],"medium":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",300,234,false],"medium_large":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"large":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"1536x1536":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"2048x2048":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"qubely_landscape":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"qubely_portrait":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",411,320,false],"qubely_thumbnail":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",128,100,false],"nazare_single_thumb":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"nazare_post_card_thumb":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",480,374,false],"nazare_widget_thumb":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",100,78,false],"nazare_widget_first_thumb":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",265,206,false],"nazare_el_banner_left":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"nazare_el_banner_right":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",560,436,false],"nazare_el_post_400x376":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",400,312,false],"nazare_el_post_520x460":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",520,405,false],"nazare_el_post_500x335":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",430,335,false],"nazare_el_post_500x300":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",385,300,false],"nazare_el_post_655x640":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"nazare_el_post_500x290":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",372,290,false],"nazare_el_post_416x278":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",357,278,false],"nazare_el_post_480x425":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",480,374,false],"nazare_el_post_635x640":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"nazare_el_post_305x177":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",227,177,false],"nazare_el_post_400x400":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",400,312,false],"nazare_el_post_400x360":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",400,312,false],"nazare_el_post_416x416":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",416,324,false],"nazare_el_post_485x430":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",485,378,false],"nazare_el_post_700x467":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"nazare_el_post_1000x581":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"nazare_post_1320x605":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"nazare_post_705x565":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"nazare_post_400x265":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",340,265,false],"nazare_el_post_1248x630":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"woocommerce_thumbnail":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",300,234,false],"woocommerce_single":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"woocommerce_gallery_thumbnail":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",100,78,false],"shop_catalog":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",300,234,false],"shop_single":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",565,440,false],"shop_thumbnail":["https:\/\/fromideatocreation.com\/wp-content\/uploads\/2023\/04\/about2.webp",100,78,false]},"qubely_author":{"display_name":"Wen","author_link":"https:\/\/fromideatocreation.com\/?author=1"},"qubely_comment":0,"qubely_category":"<a href=\"https:\/\/fromideatocreation.com\/?cat=106\" rel=\"category\">\u6559\u5b78<\/a> <a href=\"https:\/\/fromideatocreation.com\/?cat=95\" rel=\"category\">\u7a0b\u5f0f\u958b\u767c<\/a>","qubely_excerpt":"PostgreSQL \u6216 Postgres \u662f\u4e00\u7a2e\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\uff0c\u63d0\u4f9b SQL \u67e5\u8a62\u8a9e\u8a00\u7684\u5be6\u73fe\u3002 \u5b83\u7b26\u5408...","_links":{"self":[{"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=\/wp\/v2\/posts\/1530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1530"}],"version-history":[{"count":1,"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=\/wp\/v2\/posts\/1530\/revisions"}],"predecessor-version":[{"id":1701,"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=\/wp\/v2\/posts\/1530\/revisions\/1701"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=\/wp\/v2\/media\/714"}],"wp:attachment":[{"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fromideatocreation.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}