{"id":41813,"date":"2023-12-09T15:34:20","date_gmt":"2023-12-06T21:33:47","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/"},"modified":"2024-05-04T12:50:47","modified_gmt":"2024-05-04T04:50:47","slug":"%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/","title":{"rendered":"\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09"},"content":{"rendered":"<h4>\u6211\u5e0c\u671b\u80fd\u591f\u8fde\u63a5\u5230\u4eceCloud9\u8fc1\u79fb\u5230EC2\u7684postgresql\u670d\u52a1\u5668\u3002<\/h4>\n<p>\u6211\u521b\u5efa\u4e86\u4e00\u4e2aPostgreSQL\u670d\u52a1\u5668\uff1a\u3010\u521d\u5b66\u8005\u3011\u3010\u5907\u5fd8\u3011\u5728EC2\u4e0a\u5b89\u88c5\u4e86PostgreSQL 12.3\uff0c\u6240\u4ee5\u6211\u5e0c\u671b\u80fd\u591f\u901a\u8fc7Cloud9\u8fde\u63a5\u5230psql\u5ba2\u6237\u7aef\u3002<\/p>\n<h5>\u6211\u88ab\u7ed3\u6784\u56f0\u4f4f\u4e86\u3002<\/h5>\n<p>\u7531\u4e8eCloud9\u4e5f\u662fEC2\uff0c\u6240\u4ee5\u6211\u4ee5\u4e3a\u53ef\u4ee5\u6309\u7167\u521b\u5efapostgresql\u670d\u52a1\u5668\u7684\u65b9\u5f0f\u6765\u8fdb\u884c\u64cd\u4f5c\u3002\u7136\u800c\u2026\u2026\u51fa\u4e4e\u610f\u6599\u7684\u662f\uff0c\u6211AWS\u73af\u5883\u4e2d\u7684EC2\u548cCloud9\u7684\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c\u662f\u4e0d\u540c\u7684\u3002<\/p>\n<div>\n<div class=\"post-table\">\u30b5\u30fc\u30d3\u30b9OS\u30d9\u30fc\u30b9\u306b\u306a\u308bOSCloud9Amazon LinuxRHEL6\u7cfbEC2Amazon Linux 2RHEL7\u7cfb<\/div>\n<\/div>\n<blockquote><p>\u53c2\u8003\uff1a Amazon Linux \u5c5e\u4e8e\u54ea\u4e00\u7c7b\u53d1\u884c\u7248\uff1f<\/p><\/blockquote>\n<ul class=\"post-ul\">Cloud9\u306eOS\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> <span class=\"nb\">cat<\/span> \/etc\/system-release\r\n<span class=\"go\">Amazon Linux AMI release 2018.03\r\n<\/span><\/code><\/pre>\n<ul class=\"post-ul\">EC2\u306eOS\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> <span class=\"nb\">cat<\/span> \/etc\/system-release\r\n<span class=\"go\">Amazon Linux release 2 (Karoo)\r\n<\/span><\/code><\/pre>\n<h4>\u4f7f\u7528repo\u5b89\u88c5<\/h4>\n<p>\u7531\u4e8eAmazon Linux 1\u4f3c\u4e4e\u662f\u57fa\u4e8eRHEL6\uff08Red Hat Enterprise Linux 6\uff09\uff0c\u56e0\u6b64\u53ef\u4ee5\u901a\u8fc7\u5728\u6b64\u5904\u5b89\u88c5repo\u6587\u4ef6\u6765\u5b9e\u73b0\u3002<\/p>\n<blockquote><p>https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-6-x86_64\/<br \/>\npgdg-redhat-repo-latest.noarch.rpm<\/p><\/blockquote>\n<h4>\u4e0b\u8f7drepo\u6587\u4ef6\u3002<\/h4>\n<p>\u5728Cloud9\u7684root\u7528\u6237\u4e0b\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> <span class=\"nb\">sudo <\/span>su -\r\n<span class=\"gp\">#<\/span> wget <span class=\"nt\">--no-check-certificate<\/span> https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-6-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\r\n<span class=\"go\">--2021-10-05 07:15:01--  https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-6-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\r\nResolving download.postgresql.org (download.postgresql.org)... 217.196.149.55, 72.32.157.246, 147.75.85.69, ...\r\nConnecting to download.postgresql.org (download.postgresql.org)|217.196.149.55|:443... connected.\r\nHTTP request sent, awaiting response... 200 OK\r\nLength: 6636 (6.5K) [application\/x-redhat-package-manager]\r\nSaving to: \u2018pgdg-redhat-repo-latest.noarch.rpm\u2019\r\n\r\n<\/span><span class=\"gp\">pgdg-redhat-repo-late 100%[=========================&gt;<\/span><span class=\"o\">]<\/span>   6.48K  <span class=\"nt\">--<\/span>.-KB\/s    <span class=\"k\">in <\/span>0s      \r\n<span class=\"go\">\r\n2021-10-05 07:15:02 (913 MB\/s) - \u2018pgdg-redhat-repo-latest.noarch.rpm\u2019 saved [6636\/6636]\r\n<\/span><\/code><\/pre>\n<h4>\u5b89\u88c5repo\u6587\u4ef6<\/h4>\n<p>\u4f7f\u7528&#8211;nodeps\u9009\u9879\u5b89\u88c5.rpm\u6587\u4ef6\uff0c\u5ffd\u7565\u5bf9\/etc\/redhat-release\u6587\u4ef6\u7684\u4f9d\u8d56\u5173\u7cfb\uff0c\u8be5.rpm\u6587\u4ef6\u662f\u901a\u8fc7\u2191\u4e0b\u8f7d\u7684\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> rpm <span class=\"nt\">-Uvh<\/span> <span class=\"nt\">--nodeps<\/span> .\/pgdg-redhat-repo-latest.noarch.rpm \r\n<span class=\"go\">warning: .\/pgdg-redhat-repo-latest.noarch.rpm: Header V4 DSA\/SHA1 Signature, key ID 442df0f8: NOKEY\r\n<\/span><span class=\"gp\">Preparing...                          #<\/span><span class=\"c\">################################ [100%]<\/span>\r\n<span class=\"go\">Updating \/ installing...\r\n<\/span><span class=\"gp\">   1:pgdg-redhat-repo-42.0-11         #<\/span><span class=\"c\">################################ [100%]<\/span>\r\n<\/code><\/pre>\n<p>\u5f53\u67e5\u770brepolist\u65f6\uff0c\u53ef\u4ee5\u53d1\u73b0\u8be5\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c\u4e3aRHEL\/CentOS\u6700\u65b0\u7248\u672c\u7684PostgreSQL 12 &#8211; x86_64\uff0c\u5bfc\u81f4\u5b89\u88c5\u5931\u8d25\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> yum repolist\r\n<span class=\"go\">Loaded plugins: priorities, update-motd, upgrade-helper\r\namzn-main                                                        | 2.1 kB  00:00:00     \r\namzn-updates                                                     | 3.8 kB  00:00:00     \r\nhttps:\/\/download.postgresql.org\/pub\/repos\/yum\/9.5\/redhat\/rhel-latest-x86_64\/repodata\/repomd.xml: [Errno 14] HTTPS Error 404 - Not Found\r\nTrying other mirror.\r\nTo address this issue please refer to the below knowledge base article \r\n\r\nhttps:\/\/access.redhat.com\/articles\/1320623\r\n\r\nIf above article doesn't help to resolve this issue please open a ticket with Red Hat Support.\r\n\r\nhttps:\/\/download.postgresql.org\/pub\/repos\/yum\/9.5\/redhat\/rhel-latest-x86_64\/repodata\/repomd.xml: [Errno 14] HTTPS Error 404 - Not Found\r\nTrying other mirror.\r\nrepo id                   repo name                                               status\r\namzn-main\/latest          amzn-main-Base                                           5,934\r\namzn-updates\/latest       amzn-updates-Base                                        6,428\r\nepel\/x86_64               Extra Packages for Enterprise Linux 6 - x86_64          12,581\r\nhashicorp\/latest\/x86_64   Hashicorp Stable - x86_64                                  321\r\npgdg-common\/latest\/x86_64 PostgreSQL common RPMs for RHEL\/CentOS latest - x86_64     326\r\npgdg10\/latest\/x86_64      PostgreSQL 10 for RHEL\/CentOS latest - x86_64              980\r\npgdg11\/latest\/x86_64      PostgreSQL 11 for RHEL\/CentOS latest - x86_64            1,080\r\npgdg12\/latest\/x86_64      PostgreSQL 12 for RHEL\/CentOS latest - x86_64              659\r\npgdg95\/latest\/x86_64      PostgreSQL 9.5 for RHEL\/CentOS latest - x86_64               0\r\npgdg96\/latest\/x86_64      PostgreSQL 9.6 for RHEL\/CentOS latest - x86_64             942\r\nrepolist: 29,251\r\n<\/span><\/code><\/pre>\n<h4>\u4ed3\u5e93\u7f16\u8f91<\/h4>\n<p>\u5982\u679c\u7ee7\u7eed\u8fd9\u6837\uff0cyum install \u5c31\u65e0\u6cd5\u6210\u529f\uff0c\u6240\u4ee5\u9700\u8981\u7f16\u8f91 yum.repos.d \u6587\u4ef6\u3002<br \/>\n\u636e\u8bf4 $releasever \u8fd9\u4e2a\u53d8\u91cf\u4e2d\u4f1a\u5305\u542b RHEL \u6216 CentOS \u7684\u7248\u672c\u53f7\uff08\u6bd4\u5982 7 \u6216 8\uff09\uff0c\u4f46\u5728 EC2 \u7684 Amazon Linux \u4e2d\uff0c\u5b83\u4f1a\u5305\u542b\u4e00\u4e2a\u540d\u4e3a system-release \u7684\u5b57\u7b26\u4e32\uff0c\u5bfc\u81f4 yum install \u65e0\u6cd5\u6210\u529f\u3002<br \/>\n\u53c2\u8003\uff1a\u3010CentOS7\u3011\u5982\u4f55\u83b7\u53d6 yum \u7684 $releasever\u3001$basearch \u548c $infra \u503c\u3002<br \/>\n\u5c06\u5176\u66ff\u6362\u4e3a 6 \u8868\u793a\u6307\u7684\u662f RHEL\/CentOS \u7684\u7248\u672c 6\uff0c\u9700\u8981\u4f7f\u7528\u9002\u7528\u4e8e 6 \u7248\u672c\u7684\u4e8c\u8fdb\u5236\u6587\u4ef6\u7684\u8def\u5f84\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> <span class=\"nb\">sed<\/span> <span class=\"nt\">--in-place<\/span> <span class=\"nt\">-e<\/span> <span class=\"s2\">\"s\/<\/span><span class=\"se\">\\$<\/span><span class=\"s2\">releasever\/6\/g\"<\/span> \/etc\/yum.repos.d\/pgdg-redhat-all.repo\r\n<\/code><\/pre>\n<p>\u5df2\u7ecf\u5347\u7ea7\u5230\u7248\u672c6\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> yum repolist\r\n<span class=\"go\">Loaded plugins: priorities, update-motd, upgrade-helper\r\n1277 packages excluded due to repository priority protections\r\nrepo id                  repo name                                          status\r\namzn-main\/latest         amzn-main-Base                                            5,934\r\namzn-updates\/latest      amzn-updates-Base                                         6,428\r\nepel\/x86_64              Extra Packages for Enterprise Linux 6 - x86_64     11,514+1,067\r\nhashicorp\/latest\/x86_64  Hashicorp Stable - x86_64                                   321\r\npgdg-common\/x86_64       PostgreSQL common RPMs for RHEL\/CentOS 6 - x86_64         324+2\r\npgdg10\/x86_64            PostgreSQL 10 for RHEL\/CentOS 6 - x86_64                    980\r\npgdg11\/x86_64            PostgreSQL 11 for RHEL\/CentOS 6 - x86_64                  1,080\r\npgdg12\/x86_64            PostgreSQL 12 for RHEL\/CentOS 6 - x86_64                    659\r\npgdg95\/x86_64            PostgreSQL 9.5 for RHEL\/CentOS 6 - x86_64                317+88\r\npgdg96\/x86_64            PostgreSQL 9.6 for RHEL\/CentOS 6 - x86_64               822+120\r\nrepolist: 28,379\r\n<\/span><\/code><\/pre>\n<p>yum install\u3067\u30a8\u30e9\u30fc\u3067\u30cf\u30de\u308b\u3002<br \/>\nsystemd\u304c\u7121\u3044\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308b\u304c\u3001RHEL6\u30d9\u30fc\u30b9\u306eAmazon Linux 1\u3067\u306f\u305d\u308a\u3083\u7121\u3044\u3088\u3002<br \/>\n\u3069\u3046\u3082\u8abf\u3079\u305f\u3089Postgresql9\u307e\u3067\u3057\u304bRHEL6\u30d9\u30fc\u30b9\u306b\u306f\u5165\u3089\u306a\u3044\u3063\u307d\u3044<\/p>\n<p>\u8bf7\u786e\u8ba4\u5b58\u50a8\u5e93\u4e2d\u662f\u5426\u6709postgresql\u5ba2\u6237\u7aef\u7248\u672c9\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> yum search postgresql9|grep client\r\n<span class=\"go\">postgresql92.x86_64 : PostgreSQL client programs\r\n                       : clients\r\n                         : clients\r\npostgresql93.x86_64 : PostgreSQL client programs\r\n                       : clients\r\n                         : clients\r\npostgresql94.x86_64 : PostgreSQL client programs\r\n                       : clients\r\n                         : clients\r\npostgresql95.x86_64 : PostgreSQL client programs\r\n                       : clients\r\n                         : clients\r\npostgresql95-tcl.x86_64 : A Tcl client library for PostgreSQL\r\npostgresql96.x86_64 : PostgreSQL client programs\r\n                       : clients\r\n                         : clients\r\npostgresql96-tcl.x86_64 : A Tcl client library for PostgreSQL\r\n<\/span><\/code><\/pre>\n<h4>\u5b89\u88c5\u6700\u65b0\u7248\u7684PostgreSQL 9\u3002<\/h4>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> yum <span class=\"nb\">install <\/span>postgresql96.x86_64\r\n<span class=\"go\">Loaded plugins: priorities, update-motd, upgrade-helper\r\n1277 packages excluded due to repository priority protections\r\nResolving Dependencies\r\n<\/span><span class=\"gp\">--&gt;<\/span> Running transaction check\r\n<span class=\"gp\">---&gt;<\/span> Package postgresql96.x86_64 0:9.6.22-1.85.amzn1 will be installed\r\n<span class=\"gp\">--&gt;<\/span> Processing Dependency: postgresql96-libs<span class=\"o\">(<\/span>x86-64<span class=\"o\">)<\/span> <span class=\"o\">=<\/span> 9.6.22-1.85.amzn1 <span class=\"k\">for <\/span>package: postgresql96-9.6.22-1.85.amzn1.x86_64\r\n<span class=\"gp\">--&gt;<\/span> Processing Dependency: libpq.so.5<span class=\"o\">()(<\/span>64bit<span class=\"o\">)<\/span> <span class=\"k\">for <\/span>package: postgresql96-9.6.22-1.85.amzn1.x86_64\r\n<span class=\"gp\">--&gt;<\/span> Running transaction check\r\n<span class=\"gp\">---&gt;<\/span> Package postgresql96-libs.x86_64 0:9.6.22-1.85.amzn1 will be installed\r\n<span class=\"gp\">--&gt;<\/span> Finished Dependency Resolution\r\n<span class=\"go\">\r\nDependencies Resolved\r\n\r\n========================================================================================\r\n Package                 Arch         Version                  Repository          Size\r\n========================================================================================\r\nInstalling:\r\n postgresql96            x86_64       9.6.22-1.85.amzn1        amzn-updates       4.3 M\r\nInstalling for dependencies:\r\n postgresql96-libs       x86_64       9.6.22-1.85.amzn1        amzn-updates       290 k\r\n\r\nTransaction Summary\r\n========================================================================================\r\nInstall  1 Package (+1 Dependent package)\r\n\r\nTotal download size: 4.6 M\r\nInstalled size: 17 M\r\nIs this ok [y\/d\/N]: y\r\nDownloading packages:\r\n(1\/2): postgresql96-libs-9.6.22-1.85.amzn1.x86_64.rpm            | 290 kB  00:00:00     \r\n(2\/2): postgresql96-9.6.22-1.85.amzn1.x86_64.rpm                 | 4.3 MB  00:00:00     \r\n----------------------------------------------------------------------------------------\r\nTotal                                                       22 MB\/s | 4.6 MB  00:00     \r\nRunning transaction check\r\nRunning transaction test\r\nTransaction test succeeded\r\nRunning transaction\r\nWarning: RPMDB altered outside of yum.\r\n** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:\r\npgdg-redhat-repo-42.0-11.noarch has missing requires of \/etc\/redhat-release\r\n  Installing : postgresql96-libs-9.6.22-1.85.amzn1.x86_64                           1\/2 \r\n  Installing : postgresql96-9.6.22-1.85.amzn1.x86_64                                2\/2 \r\n  Verifying  : postgresql96-libs-9.6.22-1.85.amzn1.x86_64                           1\/2 \r\n  Verifying  : postgresql96-9.6.22-1.85.amzn1.x86_64                                2\/2 \r\n\r\nInstalled:\r\n  postgresql96.x86_64 0:9.6.22-1.85.amzn1                                               \r\n\r\nDependency Installed:\r\n  postgresql96-libs.x86_64 0:9.6.22-1.85.amzn1                                          \r\n\r\nComplete!\r\n<\/span><\/code><\/pre>\n<ul class=\"post-ul\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> psql <span class=\"nt\">-V<\/span>\r\n<span class=\"go\">psql (PostgreSQL) 9.6.22\r\n<\/span><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6211\u5e0c\u671b\u80fd\u591f\u8fde\u63a5\u5230\u4eceCloud9\u8fc1\u79fb\u5230EC2\u7684postgresql\u670d\u52a1\u5668\u3002 \u6211\u521b\u5efa\u4e86\u4e00\u4e2aPostgreSQL\u670d\u52a1 [&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-41813","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>\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09 - 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\/\u3010\u5907\u5fd8\u3011\u5728cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09\" \/>\n<meta property=\"og:description\" content=\"\u6211\u5e0c\u671b\u80fd\u591f\u8fde\u63a5\u5230\u4eceCloud9\u8fc1\u79fb\u5230EC2\u7684postgresql\u670d\u52a1\u5668\u3002 \u6211\u521b\u5efa\u4e86\u4e00\u4e2aPostgreSQL\u670d\u52a1 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010\u5907\u5fd8\u3011\u5728cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-06T21:33:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T04:50:47+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=\"4 \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\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/\",\"name\":\"\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-12-06T21:33:47+00:00\",\"dateModified\":\"2024-05-04T04:50:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09\"}]},{\"@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\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09 - 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\/\u3010\u5907\u5fd8\u3011\u5728cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09\/","og_locale":"zh_CN","og_type":"article","og_title":"\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09","og_description":"\u6211\u5e0c\u671b\u80fd\u591f\u8fde\u63a5\u5230\u4eceCloud9\u8fc1\u79fb\u5230EC2\u7684postgresql\u670d\u52a1\u5668\u3002 \u6211\u521b\u5efa\u4e86\u4e00\u4e2aPostgreSQL\u670d\u52a1 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010\u5907\u5fd8\u3011\u5728cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-12-06T21:33:47+00:00","article_modified_time":"2024-05-04T04:50:47+00:00","author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/","name":"\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-12-06T21:33:47+00:00","dateModified":"2024-05-04T04:50:47+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u3010\u5907\u5fd8\u3011\u5728Cloud9\u4e0a\u5b89\u88c5psql\uff08\u5ba2\u6237\u7aef\uff09"}]},{"@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\/%e3%80%90%e5%a4%87%e5%bf%98%e3%80%91%e5%9c%a8cloud9%e4%b8%8a%e5%ae%89%e8%a3%85psql%ef%bc%88%e5%ae%a2%e6%88%b7%e7%ab%af%ef%bc%89\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41813","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=41813"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41813\/revisions"}],"predecessor-version":[{"id":98423,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41813\/revisions\/98423"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}