{"id":41942,"date":"2023-08-12T05:47:27","date_gmt":"2022-12-16T23:42:39","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/"},"modified":"2024-04-30T18:11:12","modified_gmt":"2024-04-30T10:11:12","slug":"%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/","title":{"rendered":"\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL"},"content":{"rendered":"

OCI\u4e91\u8fc1\u79fb\u6307\u5357\u662f\u4ec0\u4e48\uff1f<\/h1>\n

\u8fd9\u662f\u7531\u4e91\u5de5\u7a0b\u5e08\uff08@araidon, @kazunishi, @yama6\uff09\u7ec4\u6210\u7684\u56e2\u961f\uff0c\u4ed6\u4eec\u81f4\u529b\u4e8e\u4ece\u672c\u5730\u73af\u5883\u6216AWS\u7b49\u591a\u4e2a\u5e73\u53f0\u5411Oracle Cloud Infrastructure\u8fdb\u884c\u8fc1\u79fb\u7684\u9879\u76ee\u3002\u672c\u7cfb\u5217\u6587\u7ae0\u603b\u7ed3\u4e86OCI\u8fc1\u79fb\u7684\u6b65\u9aa4\u3002\u6bcf\u4e00\u7bc7\u6587\u7ae0\u90fd\u4f1a\u9488\u5bf9\u4e00\u4e2a\u6837\u672c\u5de5\u4f5c\u8d1f\u8f7d\uff0c\u4ecb\u7ecd\u76f8\u5e94\u7684\u8fc1\u79fb\u6b65\u9aa4\u3002\u4e0b\u9762\u662f\u603b\u7ed3\u6587\u7ae0\u3002<\/p>\n

 <\/p>\n

\u670d\u52a1\u8fc1\u79fb\uff1a\u4e9a\u9a6c\u900aRDS\u7528\u4e8ePostgreSQL<\/h1>\n

\u672c\u6b21\u8fc1\u79fb\u7684\u76ee\u6807\u662fAmazon RDS for PostgreSQL\u3002
\n\u6211\u4eec\u5c06\u4f7f\u7528PostgreSQL\u5ba2\u6237\u7aef\u5e94\u7528\u7a0b\u5e8fpg_dump\u548cpg_restore\uff0c\u5c06RDS for PostgreSQL\u7684\u6570\u636e\u5e93\u8fc1\u79fb\u5230OCI\u5e26\u6709PostgreSQL\u7684\u6570\u636e\u5e93\u3002<\/p>\n

\u8f6c\u578b\u5f62\u8c61<\/h1>\n
\"image.png\"<\/div>\n

\u524d\u63d0\u6761\u4ef6 (qian2 ti2 tiao2 jian4)<\/h1>\n
    \n
  • \n
      AWS\u3068OCI\u3001\u305d\u308c\u305e\u308c\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306e\u8e0f\u307f\u53f0\u30fb\u4f5c\u696d\u7528\u30b5\u30fc\u30d0\u304c\u30d1\u30d6\u30ea\u30c3\u30af\u30b5\u30d6\u30cd\u30c3\u30c8\u4e0a\u306b\u69cb\u7bc9\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3002<\/ul>\n<\/li>\n<\/ul>\n

       <\/p>\n

        OCI Database with PostgreSQL\u304c\u69cb\u7bc9\u6e08\u307f\u306a\u3053\u3068\u3002<\/ul>\n

        OCI\u6570\u636e\u5e93\u4e0ePostgreSQL\u662f\u57282023\u5e7411\u670815\u65e5\u521a\u521a\u53d1\u5e03\u7684\u670d\u52a1\u3002
        \n\u5e0c\u671b\u60a8\u53ef\u4ee5\u53c2\u8003\u4e0b\u9762\u642d\u5efa\u7684\u6587\u7ae0\u3002<\/p>\n

         <\/p>\n

        \u64cd\u4f5c\u9a8c\u8bc1\u6570\u636e\u5e93<\/h2>\n

        \u5728\u672c\u535a\u5ba2\u4e2d\uff0c\u6211\u4eec\u5c06\u4f7f\u7528\u4ee5\u4e0b\u7f51\u7ad9\u63d0\u4f9b\u7684dvdrental\u6570\u636e\u5e93\u6765\u786e\u8ba4\u8fc1\u79fb\u524d\u540e\u7684\u8868\u5185\u5bb9\u3002<\/p>\n

         <\/p>\n

        \u5728Amazon RDS for PostgreSQL\u4e0a\u7684\u64cd\u4f5c\u786e\u8ba4\u7ed3\u679c\u3002<\/h2>\n
        \u52a8\u4f5c\u786e\u8ba4\u7ed3\u679c\uff08\u957f\u6587\u6298\u53e0\uff09DVD\u79df\u8d41=> \\dt;
        \n\u5173\u7cfb\u5217\u8868
        \n\u7ed3\u6784 | \u540d\u79f0 | \u7c7b\u578b | \u6240\u6709\u8005
        \n——–+—————+——-+———-
        \n\u516c\u5171 | \u6f14\u5458 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u5730\u5740 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u7c7b\u522b | \u8868\u683c | postgres
        \n\u516c\u5171 | \u57ce\u5e02 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u56fd\u5bb6 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u5ba2\u6237 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u7535\u5f71 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u7535\u5f71_\u6f14\u5458 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u7535\u5f71_\u7c7b\u522b | \u8868\u683c | postgres
        \n\u516c\u5171 | \u5e93\u5b58 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u8bed\u8a00 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u4ed8\u6b3e | \u8868\u683c | postgres
        \n\u516c\u5171 | \u79df\u8d41 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u5458\u5de5 | \u8868\u683c | postgres
        \n\u516c\u5171 | \u5546\u5e97 | \u8868\u683c | postgres
        \n(15 \u884c)<\/p>\n

        DVD\u79df\u8d41=> \u9009\u62e9*\u4ece\u6f14\u5458\u9650\u523620;
        \n\u6f14\u5458ID | \u540d\u5b57 | \u59d3 | \u6700\u540e\u66f4\u65b0
        \n———-+————+————–+————————
        \n1 | Penelope | Guiness | 2013-05-26 14:47:57.62
        \n2 | Nick | Wahlberg | 2013-05-26 14:47:57.62
        \n3 | Ed | Chase | 2013-05-26 14:47:57.62
        \n4 | Jennifer | Davis | 2013-05-26 14:47:57.62
        \n5 | Johnny | Lollobrigida | 2013-05-26 14:47:57.62
        \n6 | Bette | Nicholson | 2013-05-26 14:47:57.62
        \n7 | Grace | Mostel | 2013-05-26 14:47:57.62
        \n8 | Matthew | Johansson | 2013-05-26 14:47:57.62
        \n9 | Joe | Swank | 2013-05-26 14:47:57.62
        \n10 | Christian | Gable | 2013-05-26 14:47:57.62
        \n11 | Zero | Cage | 2013-05-26 14:47:57.62
        \n12 | Karl | Berry | 2013-05-26 14:47:57.62
        \n13 | Uma | Wood | 2013-05-26 14:47:57.62
        \n14 | Vivien | Bergen | 2013-05-26 14:47:57.62
        \n15 | Cuba | Olivier | 2013-05-26 14:47:57.62
        \n16 | Fred | Costner | 2013-05-26 14:47:57.62
        \n17 | Helen | Voight | 2013-05-26 14:47:57.62
        \n18 | Dan | Torn | 2013-05-26 14:47:57.62
        \n19 | Bob | Fawcett | 2013-05-26 14:47:57.62
        \n20 | Lucille | Tracy | 2013-05-26 14:47:57.62
        \n(20 \u884c)<\/p>\n

        DVD\u79df\u8d41=> \u9009\u62e9\u8ba1\u6570(*)\u4ece\u6f14\u5458;
        \n\u8ba1\u6570
        \n——-
        \n200
        \n(1 \u884c)<\/p>\n

        DVD\u79df\u8d41=>
        \nDVD\u79df\u8d41=> \u9009\u62e9*\u4ece\u7535\u5f71_\u6f14\u5458\u9650\u523610;
        \n\u6f14\u5458ID | \u7535\u5f71ID | \u6700\u540e\u66f4\u65b0
        \n———-+———+———————
        \n1 | 1 | 2006-02-15 10:05:03
        \n1 | 23 | 2006-02-15 10:05:03
        \n1 | 25 | 2006-02-15 10:05:03
        \n1 | 106 | 2006-02-15 10:05:03
        \n1 | 140 | 2006-02-15 10:05:03
        \n1 | 166 | 2006-02-15 10:05:03
        \n1 | 277 | 2006-02-15 10:05:03
        \n1 | 361 | 2006-02-15 10:05:03
        \n1 | 438 | 2006-02-15 10:05:03
        \n1 | 499 | 2006-02-15 10:05:03
        \n(10 \u884c)<\/p>\n

        DVD\u79df\u8d41=> \u9009\u62e9*\u4ece\u5546\u5e97\u9650\u523610;
        \n\u5546\u5e97ID | \u7ecf\u7406\u5458\u5de5ID | \u5730\u5740ID | \u6700\u540e\u66f4\u65b0
        \n———-+——————+————+———————
        \n1 | 1 | 1 | 2006-02-15 09:57:12
        \n2 | 2 | 2 | 2006-02-15 09:57:12
        \n(2 \u884c)<\/p>\n

        DVD\u79df\u8d41=> \u9009\u62e9*\u4ece\u57ce\u5e02\u9650\u523610;
        \n\u57ce\u5e02ID | \u57ce\u5e02 | \u56fd\u5bb6ID | \u6700\u540e\u66f4\u65b0
        \n———+——————–+————+———————
        \n1 | A Corua (La Corua) | 87 | 2006-02-15 09:45:25
        \n2 | Abha | 82 | 2006-02-15 09:45:25
        \n3 | Abu Dhabi | 101 | 2006-02-15 09:45:25
        \n4 | Acua | 60 | 2006-02-15 09:45:25
        \n5 | Adana | 97 | 2006-02-15 09:45:25
        \n6 | Addis Abeba | 31 | 2006-02-15 09:45:25
        \n7 | Aden | 107 | 2006-02-15 09:45:25
        \n8 | Adoni | 44 | 2006-02-15 09:45:25
        \n9 | Ahmadnagar | 44 | 2006-02-15 09:45:25
        \n10 | Akishima | 50 | 2006-02-15 09:45:25
        \n(10 \u884c)<\/p>\n<\/details>\n

        \u8f6c\u79fb\u6d41\u7a0b<\/h1>\n
          \n
        1. \n
            \u5728AWS\u7684\u5de5\u4f5c\u7528EC2\u5b9e\u4f8b\u4e0a\u5b89\u88c5PostgreSQL\u5ba2\u6237\u7aef<\/ol>\n<\/li>\n<\/ol>\n

             <\/p>\n

              \n
            1. \n
                \u4f7f\u7528pg_dump\u547d\u4ee4\u521b\u5efa\u6570\u636e\u5e93\u7684\u5907\u4efd\u6587\u4ef6<\/ol>\n<\/li>\n<\/ol>\n

                 <\/p>\n

                  \n
                1. \n
                    \u624b\u52a8\u5c06\u5907\u4efd\u6587\u4ef6\u590d\u5236\u5230OCI\u7684\u5de5\u4f5c\u7528Compute\u5b9e\u4f8b\u4e0a<\/ol>\n<\/li>\n<\/ol>\n

                     <\/p>\n

                      \n
                    1. \n
                        \u5728OCI\u7684\u5de5\u4f5c\u7528Compute\u5b9e\u4f8b\u4e0a\u5b89\u88c5PostgreSQL\u5ba2\u6237\u7aef<\/ol>\n<\/li>\n<\/ol>\n

                         <\/p>\n

                          \u4f7f\u7528pg_restore\u547d\u4ee4\u6267\u884c\u6570\u636e\u5e93\u8fd8\u539f\u64cd\u4f5c<\/ol>\n

                          1. \u5b89\u88c5 AWS \u4e0a\u7684\u5de5\u4f5c\u7528 EC2 \u4e0a\u7684 PostgreSQL \u5ba2\u6237\u7aef<\/h1>\n
                          \u5982\u679c\u5df2\u7ecf\u5b89\u88c5\u597d\u4e86\uff0c\u8bf7\u8df3\u5230\u6b65\u9aa42\u3002<\/div>\n

                          \u8bf7\u6309\u7167\u9002\u7528\u4e8e\u5404\u79cdLinux\u7684\u6b65\u9aa4\u8fdb\u884c\u5b89\u88c5\u3002
                          \n\u8bf7\u53c2\u8003\u4ee5\u4e0b\u5404\u79cd\u64cd\u4f5c\u7cfb\u7edf\u7684\u76f8\u5e94\u6b65\u9aa4\u3002<\/p>\n

                           <\/p>\n

                          \uff08\u4f8b\uff09\u4f7f\u7528Ubuntu\u7684\u6b65\u9aa4<\/p>\n

                          $ <\/span>sudo <\/span>apt install<\/span> -y<\/span> postgresql-client\r\n\r\n$ <\/span>psql --version<\/span>\r\npsql (<\/span>PostgreSQL)<\/span> 14.9 (<\/span>Ubuntu 14.9-0ubuntu0.22.04.1)<\/span>\r\n<\/code><\/pre>\n
                          2. \u4f7f\u7528AWS\u7684EC2\u5b9e\u4f8b\u8fdb\u884c\u5de5\u4f5c: \u4f7f\u7528pg_dump\u547d\u4ee4\u521b\u5efa\u6570\u636e\u5e93\u7684Dump\u6587\u4ef6<\/h1>\n
                          \u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u521b\u5efaDump\u6587\u4ef6\u3002<\/p>\n
                          $ <\/span>pg_dump -h<\/span> rds-postgresql.xxxxxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com -U<\/span> postgres -O<\/span> -x<\/span> --format<\/span>=<\/span>t --file<\/span>=<\/span>fromaws_dvdrental.tar dvdrental\r\nPassword: \r\n$<\/span>\r\n\r\n$ <\/span>ls<\/span> -l<\/span> .\/fromaws_dvdrental.tar \r\n-rw-rw-r--<\/span> 1 ubuntu ubuntu 2831872 Nov 15 14:22 .\/fromaws_dvdrental.tar\r\n$ <\/span>\r\n<\/code><\/pre>\n
                          \n
                          \u9805\u76ee\u8aac\u660e-h\u30db\u30b9\u30c8\u540d\u3092\u6307\u5b9a\u3002RDS for PostgreSQL\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002-U\u63a5\u7d9a\u30e6\u30fc\u30b6\u30fc\u540d\u3092\u6307\u5b9a\u3002\u5bfe\u8c61DB\u306e\u8aad\u307f\u53d6\u308a\u6a29\u9650\u304c\u5fc5\u8981\u3067\u3059\u3002-O\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u6240\u6709\u6a29\u3092\u51fa\u529b\u3057\u306a\u3044\u30aa\u30d7\u30b7\u30e7\u30f3\u3002\u5225\u306eDB\u306b\u30ea\u30b9\u30c8\u30a2\u3059\u308b\u305f\u3081\u306b\u306f\u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4ed8\u3051\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002-x\u30a2\u30af\u30bb\u30b9\u6a29\u9650\uff08grant\/revoke\u30b3\u30de\u30f3\u30c9\uff09\u306e\u30c0\u30f3\u30d7\u3092\u6291\u5236\u3057\u307e\u3059\u3002–format=tpg_restore\u3078\u306e\u5165\u529b\u306b\u9069\u3057\u305ftar\u5f62\u5f0f\u306e\u30a2\u30fc\u30ab\u30a4\u30d6\u3092\u51fa\u529b\u3057\u307e\u3059\u3002–file=\u51fa\u529b\u3092\u6307\u5b9a\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u9001\u308a\u307e\u3059\u3002<\/div>\n<\/div>\n
                          \u8bf7\u53c2\u8003\u4ee5\u4e0b\u5b98\u65b9\u7f51\u7ad9\u4ee5\u4e86\u89e3\u9879\u76ee\u7684\u8be6\u7ec6\u4fe1\u606f\u3002<\/p>\n
                           <\/p>\n
                          \u5c06Dump\u6587\u4ef6\u624b\u52a8\u590d\u5236\u5230OCI\u7684\u5de5\u4f5c\u8ba1\u7b97\u673a\u4e0a\u3002<\/h1>\n
                          \u8bf7\u4ee5\u4efb\u4f55\u65b9\u5f0f\u590d\u5236\u5df2\u521b\u5efa\u7684\u6587\u4ef6\u3002<\/p>\n
                          4. \u5b89\u88c5OCI\u64cd\u4f5cCompute\u6240\u9700\u7684PostgreSQL\u5ba2\u6237\u7aef\u3002<\/h1>\n
                          \u5982\u679c\u5df2\u7ecf\u5b89\u88c5\u5b8c\u6bd5\uff0c\u8bf7\u7ee7\u7eed\u8fdb\u884c\u6b65\u9aa45\u3002<\/div>\n
                          \u8bf7\u6839\u636e\u9002\u7528\u4e8e\u5404\u79cdLinux\u7684\u6b65\u9aa4\u8fdb\u884c\u5b89\u88c5\u3002
                          \n\u8bf7\u53c2\u8003\u4ee5\u4e0b\u5404\u79cd\u64cd\u4f5c\u7cfb\u7edf\u7684\u76f8\u5e94\u6b65\u9aa4\u3002<\/p>\n
                           <\/p>\n
                          \u4f7f\u7528OCI\u7684Compute\u8fdb\u884c\u64cd\u4f5c\uff1a\u4f7f\u7528pg_restore\u547d\u4ee4\u6267\u884c\u6570\u636e\u5e93\u7684\u6062\u590d\u64cd\u4f5c\u3002<\/h1>\n
                          5.1. \u521b\u5efa\u539f\u59cb\u6570\u636e\u5e93\u5907\u4efd<\/h2>\n
                          \u5728\u8fdb\u884c\u6062\u590d\u64cd\u4f5c\u4e4b\u524d\uff0c\u9700\u8981\u9884\u5148\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u3002
                          \n\u6570\u636e\u5e93\u7684\u540d\u79f0\u53ef\u4ee5\u4e0e\u8fc1\u79fb\u524d\u4e0d\u540c\u4e5f\u53ef\u4ee5\u3002
                          \n\u5728\u63a5\u4e0b\u6765\u7684\u6b65\u9aa4\u4e2d\uff0c\u6211\u4eec\u5c06\u4ee5\u201coci_dvdrental\u201d\u4f5c\u4e3a\u6570\u636e\u5e93\u540d\u79f0\u8fdb\u884c\u521b\u5efa\u3002<\/p>\n
                          $ <\/span>psql -h<\/span> 10.1.1.134 -U<\/span> postgres -d<\/span> postgres\r\nPassword for <\/span>user postgres: \r\npsql (<\/span>15.3, server 14.9)<\/span>\r\nSSL connection (<\/span>protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, compression: off)<\/span>\r\nType \"help\"<\/span> for <\/span>help.\r\n\r\npostgres<\/span>=><\/span> create database oci_dvdrental;<\/span>\r\nCREATE DATABASE\r\n\r\n<\/code><\/pre>\n
                          \u786e\u8ba4\u6570\u636e\u5e93\u5df2\u88ab\u521b\u5efa\uff0c\u5e76\u4e14\u5185\u5bb9\u4e3a\u7a7a\u3002<\/p>\n
                          postgres<\/span>=><\/span> \\l<\/span>\r\n                                                           List of databases\r\n     Name      |     Owner     | Encoding |   Collate   |    Ctype    | ICU Locale | Locale Provider |        Access privileges        \r\n---------------<\/span>+---------------+----------+-------------+-------------+------------+-----------------+---------------------------------\r\n oci_dvdrental | postgres      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | \r\n postgres      | oci_superuser | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | \r\n template0     | oci_superuser | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | =<\/span>c\/oci_superuser               +\r\n               |               |          |             |             |            |                 | oci_superuser<\/span>=<\/span>CTc\/oci_superuser\r\n template1     | oci_superuser | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | =<\/span>c\/oci_superuser               +\r\n               |               |          |             |             |            |                 | oci_superuser<\/span>=<\/span>CTc\/oci_superuser\r\n(<\/span>4 rows)<\/span>\r\n\r\npostgres<\/span>=><\/span> \\c<\/span> oci_dvdrental;<\/span>\r\npsql (<\/span>15.3, server 14.9)<\/span>\r\nSSL connection (<\/span>protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, compression: off)<\/span>\r\nYou are now connected to database \"oci_dvdrental\"<\/span> as user \"postgres\"<\/span>.<\/span>\r\n\r\noci_dvdrental<\/span>=><\/span> \\d<\/span>t;<\/span>\r\nDid not find any relations.\r\noci_dvdrental<\/span>=><\/span>\r\n<\/code><\/pre>\n
                          \u4f7f\u7528pg_restore\u5de5\u5177\u6267\u884c\u6570\u636e\u5e93\u7684\u8fd8\u539f\u64cd\u4f5c<\/h2>\n
                          \u7528\u4ee5\u4e0b\u547d\u4ee4\u6267\u884c\u6062\u590d\u64cd\u4f5c:<\/p>\n
                          $ <\/span>pg_restore -h<\/span> 10.1.1.134 -U<\/span> postgres -O<\/span> -d<\/span> oci_dvdrental .\/fromaws_dvdrental.tar \r\nPassword: \r\n$<\/span>\r\n<\/code><\/pre>\n
                          \n
                          \u9805\u76ee\u8aac\u660e-h\u30db\u30b9\u30c8\u540d\u3092\u6307\u5b9a\u3002OCI Database with PostgreSQL\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002-U\u63a5\u7d9a\u30e6\u30fc\u30b6\u30fc\u540d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002-O\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u6240\u6709\u6a29\u3092\u51fa\u529b\u3057\u306a\u3044\u30aa\u30d7\u30b7\u30e7\u30f3\u3002\u5168\u3066\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u6240\u6709\u8005\u304c\u30ea\u30b9\u30c8\u30a2\u3057\u305f\u30e6\u30fc\u30b6\u306b\u306a\u308a\u307e\u3059\u3002-d\u3053\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u76f4\u63a5\u30ea\u30b9\u30c8\u30a2\u3057\u307e\u3059\u3002<\/div>\n<\/div>\n
                          \u8bf7\u53c2\u8003\u4ee5\u4e0b\u5b98\u65b9\u7f51\u7ad9\u4ee5\u83b7\u53d6\u9879\u76ee\u7684\u8be6\u7ec6\u4fe1\u606f\u3002<\/p>\n
                           <\/p>\n
                          \u786e\u8ba4\u52a8\u4f5c<\/h1>\n
                          \u6211\u4f1a\u767b\u5f55\u5230OCI\u6570\u636e\u5e93\u4e0ePostgreSQL\u7684\u7ec8\u7aef\uff0c\u5e76\u8fdb\u884c\u64cd\u4f5c\u786e\u8ba4\u3002<\/p>\n
                          \u52a8\u4f5c\u786e\u8ba4\u7ed3\u679c\uff08\u957f\u6587\u6298\u53e0\uff09$ psql -h 10.1.1.134 -U postgres -d oci_dvdrental
                          \npostgres\u7528\u6237\u7684\u5bc6\u7801\uff1a
                          \npsql\uff0815.3\uff0c\u670d\u52a1\u566814.9\uff09
                          \nSSL\u8fde\u63a5\uff08\u534f\u8bae\uff1aTLSv1.2\uff0c\u5bc6\u7801\uff1aECDHE-RSA-AES256-GCM-SHA384\uff0c\u538b\u7f29\uff1a\u5173\u95ed\uff09
                          \n\u952e\u5165\u201chelp\u201d\u83b7\u53d6\u5e2e\u52a9\u3002<\/p>\n
                          oci_dvdrental=>
                          \noci_dvdrental=> \\dt;
                          \n\u5173\u7cfb\u5217\u8868
                          \n\u6a21\u5f0f|\u540d\u79f0|\u7c7b\u578b|\u6240\u6709\u8005
                          \n——–+—————+——-+———-
                          \npublic | actor | \u8868 | postgres
                          \npublic | address | \u8868 | postgres
                          \npublic | category | \u8868 | postgres
                          \npublic | city | \u8868 | postgres
                          \npublic | country | \u8868 | postgres
                          \npublic | customer | \u8868 | postgres
                          \npublic | film | \u8868 | postgres
                          \npublic | film_actor | \u8868 | postgres
                          \npublic | film_category | \u8868 | postgres
                          \npublic | inventory | \u8868 | postgres
                          \npublic | language | \u8868 | postgres
                          \npublic | payment | \u8868 | postgres
                          \npublic | rental | \u8868 | postgres
                          \npublic | staff | \u8868 | postgres
                          \npublic | store | \u8868 | postgres
                          \n\uff0815\u884c\uff09<\/p>\n
                          oci_dvdrental=> select * from actor limit 20;
                          \n\u6f14\u5458ID |\u540d\u5b57|\u59d3\u6c0f|\u6700\u540e\u66f4\u65b0\u65f6\u95f4
                          \n———-+————+————–+————————
                          \n1 | \u59d3\u6c0fA | \u540d\u5b57A | 2013-05-26 14:47:57.62
                          \n2 | \u59d3\u6c0fB | \u540d\u5b57B | 2013-05-26 14:47:57.62
                          \n3 | \u59d3\u6c0fC | \u540d\u5b57C | 2013-05-26 14:47:57.62
                          \n4 | \u59d3\u6c0fD | \u540d\u5b57D | 2013-05-26 14:47:57.62
                          \n5 | \u59d3\u6c0fE | \u540d\u5b57E | 2013-05-26 14:47:57.62
                          \n6 | \u59d3\u6c0fF | \u540d\u5b57F | 2013-05-26 14:47:57.62
                          \n7 | \u59d3\u6c0fG | \u540d\u5b57G | 2013-05-26 14:47:57.62
                          \n8 | \u59d3\u6c0fH | \u540d\u5b57H | 2013-05-26 14:47:57.62
                          \n9 | \u59d3\u6c0fI | \u540d\u5b57I | 2013-05-26 14:47:57.62
                          \n10 | \u59d3\u6c0fJ | \u540d\u5b57J | 2013-05-26 14:47:57.62
                          \n11 | \u59d3\u6c0fK | \u540d\u5b57K | 2013-05-26 14:47:57.62
                          \n12 | \u59d3\u6c0fL | \u540d\u5b57L | 2013-05-26 14:47:57.62
                          \n13 | \u59d3\u6c0fM | \u540d\u5b57M | 2013-05-26 14:47:57.62
                          \n14 | \u59d3\u6c0fN | \u540d\u5b57N | 2013-05-26 14:47:57.62
                          \n15 | \u59d3\u6c0fO | \u540d\u5b57O | 2013-05-26 14:47:57.62
                          \n16 | \u59d3\u6c0fP | \u540d\u5b57P | 2013-05-26 14:47:57.62
                          \n17 | \u59d3\u6c0fQ | \u540d\u5b57Q | 2013-05-26 14:47:57.62
                          \n18 | \u59d3\u6c0fR | \u540d\u5b57R | 2013-05-26 14:47:57.62
                          \n19 | \u59d3\u6c0fS | \u540d\u5b57S | 2013-05-26 14:47:57.62
                          \n20 | \u59d3\u6c0fT | \u540d\u5b57T | 2013-05-26 14:47:57.62
                          \n(20\u884c)<\/p>\n
                          oci_dvdrental=> select count(*) from actor;
                          \n\u8ba1\u6570
                          \n——-
                          \n200
                          \n(1\u884c)<\/p>\n
                          oci_dvdrental=> select * from film_actor limit 10;
                          \n\u6f14\u5458ID | \u7535\u5f71ID |\u6700\u540e\u66f4\u65b0\u65f6\u95f4
                          \n———-+———+———————
                          \n1 | 1 | 2006-02-15 10:05:03
                          \n1 | 23 | 2006-02-15 10:05:03
                          \n1 | 25 | 2006-02-15 10:05:03
                          \n1 | 106 | 2006-02-15 10:05:03
                          \n1 | 140 | 2006-02-15 10:05:03
                          \n1 | 166 | 2006-02-15 10:05:03
                          \n1 | 277 | 2006-02-15 10:05:03
                          \n1 | 361 | 2006-02-15 10:05:03
                          \n1 | 438 | 2006-02-15 10:05:03
                          \n1 | 499 | 2006-02-15 10:05:03
                          \n(10\u884c)<\/p>\n
                          oci_dvdrental=> select * from store limit 10;
                          \n\u5546\u5e97ID | \u5546\u5e97\u7ecf\u7406\u5458\u5de5ID | \u5730\u5740ID |\u6700\u540e\u66f4\u65b0\u65f6\u95f4
                          \n———-+——————+————+———————
                          \n1 | 1 | 1 | 2006-02-15 09:57:12
                          \n2 | 2 | 2 | 2006-02-15 09:57:12
                          \n(2\u884c)<\/p>\n
                          oci_dvdrental=> select * from city limit 10;
                          \n\u57ce\u5e02ID |\u57ce\u5e02|\u56fd\u5bb6ID|\u6700\u540e\u66f4\u65b0\u65f6\u95f4
                          \n———+——————–+————+———————
                          \n1 | \u963f\u79d1\u62c9\uff08\u62c9\u79d1\u9c81\u5c3c\u4e9a\uff09| 87 | 2006-02-15 09:45:25
                          \n2 | \u963f\u5e03\u54c8| 82 | 2006-02-15 09:45:25
                          \n3 | \u963f\u5e03\u624e\u6bd4| 101 | 2006-02-15 09:45:25
                          \n4 | \u963f\u5bbd| 60 | 2006-02-15 09:45:25
                          \n5 | \u963f\u8fbe\u7eb3| 97 | 2006-02-15 09:45:25
                          \n6 | \u4e9a\u7684\u65af\u4e9a\u8d1d\u5df4| 31 | 2006-02-15 09:45:25
                          \n7 | \u827e\u767b| 107 | 2006-02-15 09:45:25
                          \n8 | \u963f\u591a\u5c3c| 44 | 2006-02-15 09:45:25
                          \n9 | \u963f\u8d6b\u9a6c\u5fb7\u7eb3\u683c\u5c14| 44 | 2006-02-15 09:45:25
                          \n10 | \u660e\u5c9b| 50 | 2006-02-15 09:45:25
                          \n(10\u884c)<\/p>\n<\/details>\n
                          \u603b\u7ed3<\/h1>\n
                          \u7531\u4e8eOCI Database\u4e0ePostgreSQL\u57282023\u5e7411\u670815\u65e5\u53d8\u4e3aGA\uff0c\u6211\u5c1d\u8bd5\u4f7f\u7528\u5e38\u89c4\u6b65\u9aa4\u4eceRDS\u8fdb\u884c\u8fc1\u79fb\u3002<\/p>\n
                          \u670d\u52a1\u53d1\u5e03\u6587\u7ae0<\/p>\n
                           <\/p>\n
                          \u622a\u81f32023\u5e7411\u670815\u65e5\uff0cOCI Database with PostgreSQL\u7684\u5b98\u65b9\u6587\u6863\u5c1a\u672a\u63d0\u4f9b\u65e5\u6587\u624b\u518c\u3002<\/p>\n
                           <\/p>\n
                          \u8bf7\u5f52\u53c2\u8003\u3002<\/h1>\n
                           <\/p>\n","protected":false},"excerpt":{"rendered":"
                          OCI\u4e91\u8fc1\u79fb\u6307\u5357\u662f\u4ec0\u4e48\uff1f \u8fd9\u662f\u7531\u4e91\u5de5\u7a0b\u5e08\uff08@araidon, @kazunishi, @yama6\uff09\u7ec4\u6210\u7684\u56e2\u961f […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41942","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL - 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\/\u3010oci\u4e91\u8fc1\u79fb\u6307\u5357\u3011-\u5c1d\u8bd5\u5c06amazon-rds-for-postgresql\u8fc1\u79fb\u5230oci-database-with-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"OCI\u4e91\u8fc1\u79fb\u6307\u5357\u662f\u4ec0\u4e48\uff1f \u8fd9\u662f\u7531\u4e91\u5de5\u7a0b\u5e08\uff08@araidon, @kazunishi, @yama6\uff09\u7ec4\u6210\u7684\u56e2\u961f […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010oci\u4e91\u8fc1\u79fb\u6307\u5357\u3011-\u5c1d\u8bd5\u5c06amazon-rds-for-postgresql\u8fc1\u79fb\u5230oci-database-with-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-16T23:42:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T10:11:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d49a637434c4406cb067f\/6-0.png\" \/>\n<meta name=\"author\" content=\"\u5b87, \u534e\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5b87, \u534e\" \/>\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%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/\",\"name\":\"\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2022-12-16T23:42:39+00:00\",\"dateModified\":\"2024-04-30T10:11:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL\"}]},{\"@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\/513018e4e121d3add1b7c5de8be21458\",\"name\":\"\u5b87, \u534e\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"caption\":\"\u5b87, \u534e\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL - 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\/\u3010oci\u4e91\u8fc1\u79fb\u6307\u5357\u3011-\u5c1d\u8bd5\u5c06amazon-rds-for-postgresql\u8fc1\u79fb\u5230oci-database-with-postgresql\/","og_locale":"zh_CN","og_type":"article","og_title":"\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL","og_description":"OCI\u4e91\u8fc1\u79fb\u6307\u5357\u662f\u4ec0\u4e48\uff1f \u8fd9\u662f\u7531\u4e91\u5de5\u7a0b\u5e08\uff08@araidon, @kazunishi, @yama6\uff09\u7ec4\u6210\u7684\u56e2\u961f […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010oci\u4e91\u8fc1\u79fb\u6307\u5357\u3011-\u5c1d\u8bd5\u5c06amazon-rds-for-postgresql\u8fc1\u79fb\u5230oci-database-with-postgresql\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2022-12-16T23:42:39+00:00","article_modified_time":"2024-04-30T10:11:12+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d49a637434c4406cb067f\/6-0.png"}],"author":"\u5b87, \u534e","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5b87, \u534e","\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%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/","name":"\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2022-12-16T23:42:39+00:00","dateModified":"2024-04-30T10:11:12+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u3010OCI\u4e91\u8fc1\u79fb\u6307\u5357\u3011 \u5c1d\u8bd5\u5c06Amazon RDS for PostgreSQL\u8fc1\u79fb\u5230OCI Database with PostgreSQL"}]},{"@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\/513018e4e121d3add1b7c5de8be21458","name":"\u5b87, \u534e","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","caption":"\u5b87, \u534e"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90oci%e4%ba%91%e8%bf%81%e7%a7%bb%e6%8c%87%e5%8d%97%e3%80%91-%e5%b0%9d%e8%af%95%e5%b0%86amazon-rds-for-postgresql%e8%bf%81%e7%a7%bb%e5%88%b0oci-database-with-postgresql\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41942","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41942"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41942\/revisions"}],"predecessor-version":[{"id":93477,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41942\/revisions\/93477"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}