{"id":41991,"date":"2023-06-21T16:52:31","date_gmt":"2023-04-25T00:08:46","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/"},"modified":"2024-04-30T10:00:51","modified_gmt":"2024-04-30T02:00:51","slug":"%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/","title":{"rendered":"\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2"},"content":{"rendered":"

\u8fd9\u662f\u5173\u4e8e\u4ece\u65b0\u5b89\u88c5PostgreSQL\u5230\u4f7f\u7528pgAdmin\u8fdb\u884c\u8fde\u63a5\u7684\u8bb0\u5f55\u3002<\/p>\n

\"image.png\"<\/div>\n

\u7ba1\u7406\u670d\u52a1\u5668
\nWindows Server 2019
\npgAdmin 4 v5.2<\/p>\n

1. \u5b89\u88c5PostgreSQL<\/h1>\n

\u7531\u4e8eCentOS7\u7684\u9ed8\u8ba4\u8f6f\u4ef6\u5305\u662fPostgreSQL 9.2\u7cfb\u5217\uff0c\u56e0\u6b64\u9700\u8981\u4ece\u5b89\u88c5\u5a92\u4f53\u8fdb\u884c\u4e0b\u8f7d\u3002
\n\u5b89\u88c5\u5a92\u4f53\u7684\u6302\u8f7d\u65b9\u6cd5\u5982\u4e0b\u53c2\u8003\u3002<\/p>\n

[root@cent76-d1 ~]# yum --disablerepo=\\* --enablerepo=local_dvd list postgre*\r\n\u8aad\u307f\u8fbc\u3093\u3060\u30d7\u30e9\u30b0\u30a4\u30f3:fastestmirror\r\nLoading mirror speeds from cached hostfile\r\n\u5229\u7528\u53ef\u80fd\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\r\npostgresql.x86_64                        9.2.24-1.el7_5                local_dvd\r\npostgresql-contrib.x86_64                9.2.24-1.el7_5                local_dvd\r\npostgresql-devel.x86_64                  9.2.24-1.el7_5                local_dvd\r\npostgresql-docs.x86_64                   9.2.24-1.el7_5                local_dvd\r\npostgresql-jdbc.noarch                   9.2.1002-6.el7_5              local_dvd\r\npostgresql-libs.x86_64                   9.2.24-1.el7_5                local_dvd\r\npostgresql-odbc.x86_64                   09.03.0100-2.el7              local_dvd\r\npostgresql-plperl.x86_64                 9.2.24-1.el7_5                local_dvd\r\npostgresql-plpython.x86_64               9.2.24-1.el7_5                local_dvd\r\npostgresql-pltcl.x86_64                  9.2.24-1.el7_5                local_dvd\r\npostgresql-server.x86_64                 9.2.24-1.el7_5                local_dvd\r\npostgresql-test.x86_64                   9.2.24-1.el7_5                local_dvd\r\n[root@cent76-d1 ~]# \r\n<\/code><\/pre>\n
\u8fdb\u884c\u5b89\u88c5\u3002<\/p>\n
[root@cent76-d1 ~]# yum --disablerepo=\\* --enablerepo=local_dvd install -y postgresql*\r\n\u8aad\u307f\u8fbc\u3093\u3060\u30d7\u30e9\u30b0\u30a4\u30f3:fastestmirror\r\nLoading mirror speeds from cached hostfile\r\n\u4f9d\u5b58\u6027\u306e\u89e3\u6c7a\u3092\u3057\u3066\u3044\u307e\u3059\r\n\r\n\u300a\u4e2d\u7565\u300b\r\n\r\n========================================================================================================================\r\n Package                                   \u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc       \u30d0\u30fc\u30b8\u30e7\u30f3                 \u30ea\u30dd\u30b8\u30c8\u30ea\u30fc          \u5bb9\u91cf\r\n========================================================================================================================\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d:\r\n postgresql                                x86_64                 9.2.24-1.el7_5             local_dvd            3.0 M\r\n postgresql-contrib                        x86_64                 9.2.24-1.el7_5             local_dvd            553 k\r\n postgresql-devel                          x86_64                 9.2.24-1.el7_5             local_dvd            952 k\r\n postgresql-docs                           x86_64                 9.2.24-1.el7_5             local_dvd            6.9 M\r\n postgresql-jdbc                           noarch                 9.2.1002-6.el7_5           local_dvd            448 k\r\n postgresql-libs                           x86_64                 9.2.24-1.el7_5             local_dvd            234 k\r\n postgresql-odbc                           x86_64                 09.03.0100-2.el7           local_dvd            273 k\r\n postgresql-plperl                         x86_64                 9.2.24-1.el7_5             local_dvd             83 k\r\n postgresql-plpython                       x86_64                 9.2.24-1.el7_5             local_dvd             96 k\r\n postgresql-pltcl                          x86_64                 9.2.24-1.el7_5             local_dvd             60 k\r\n postgresql-server                         x86_64                 9.2.24-1.el7_5             local_dvd            3.8 M\r\n postgresql-test                           x86_64                 9.2.24-1.el7_5             local_dvd            1.8 M\r\n\u4f9d\u5b58\u6027\u95a2\u9023\u3067\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u3057\u307e\u3059:\r\n copy-jdk-configs                          noarch                 3.3-10.el7_5               local_dvd             21 k\r\n java-11-openjdk-headless                  x86_64                 1:11.0.ea.28-7.el7         local_dvd             38 M\r\n javapackages-tools                        noarch                 3.4.1-11.el7               local_dvd             73 k\r\n libjpeg-turbo                             x86_64                 1.2.90-6.el7               local_dvd            134 k\r\n lksctp-tools                              x86_64                 1.0.17-2.el7               local_dvd             88 k\r\n perl                                      x86_64                 4:5.16.3-293.el7           local_dvd            8.0 M\r\n perl-Carp                                 noarch                 1.26-244.el7               local_dvd             19 k\r\n perl-Encode                               x86_64                 2.51-7.el7                 local_dvd            1.5 M\r\n perl-Exporter                             noarch                 5.68-3.el7                 local_dvd             28 k\r\n perl-File-Path                            noarch                 2.09-2.el7                 local_dvd             26 k\r\n perl-File-Temp                            noarch                 0.23.01-3.el7              local_dvd             56 k\r\n perl-Filter                               x86_64                 1.49-3.el7                 local_dvd             76 k\r\n perl-Getopt-Long                          noarch                 2.40-3.el7                 local_dvd             56 k\r\n perl-HTTP-Tiny                            noarch                 0.033-3.el7                local_dvd             38 k\r\n perl-PathTools                            x86_64                 3.40-5.el7                 local_dvd             82 k\r\n perl-Pod-Escapes                          noarch                 1:1.04-293.el7             local_dvd             51 k\r\n perl-Pod-Perldoc                          noarch                 3.20-4.el7                 local_dvd             87 k\r\n perl-Pod-Simple                           noarch                 1:3.28-4.el7               local_dvd            216 k\r\n perl-Pod-Usage                            noarch                 1.63-3.el7                 local_dvd             27 k\r\n perl-Scalar-List-Utils                    x86_64                 1.27-248.el7               local_dvd             36 k\r\n perl-Socket                               x86_64                 2.010-4.el7                local_dvd             49 k\r\n perl-Storable                             x86_64                 2.45-3.el7                 local_dvd             77 k\r\n perl-Text-ParseWords                      noarch                 3.29-4.el7                 local_dvd             14 k\r\n perl-Time-HiRes                           x86_64                 4:1.9725-3.el7             local_dvd             45 k\r\n perl-Time-Local                           noarch                 1.2300-2.el7               local_dvd             24 k\r\n perl-constant                             noarch                 1.27-2.el7                 local_dvd             19 k\r\n perl-libs                                 x86_64                 4:5.16.3-293.el7           local_dvd            688 k\r\n perl-macros                               x86_64                 4:5.16.3-293.el7           local_dvd             44 k\r\n perl-parent                               noarch                 1:0.225-244.el7            local_dvd             12 k\r\n perl-podlators                            noarch                 2.5.1-3.el7                local_dvd            112 k\r\n perl-threads                              x86_64                 1.87-4.el7                 local_dvd             49 k\r\n perl-threads-shared                       x86_64                 1.43-6.el7                 local_dvd             39 k\r\n python-javapackages                       noarch                 3.4.1-11.el7               local_dvd             31 k\r\n python-lxml                               x86_64                 3.2.1-4.el7                local_dvd            758 k\r\n tcl                                       x86_64                 1:8.5.13-8.el7             local_dvd            1.9 M\r\n tzdata-java                               noarch                 2018e-3.el7                local_dvd            185 k\r\n unixODBC                                  x86_64                 2.3.1-11.el7               local_dvd            413 k\r\n uuid                                      x86_64                 1.6.2-26.el7               local_dvd             55 k\r\n\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u8981\u7d04\r\n========================================================================================================================\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb  12 \u30d1\u30c3\u30b1\u30fc\u30b8 (+38 \u500b\u306e\u4f9d\u5b58\u95a2\u4fc2\u306e\u30d1\u30c3\u30b1\u30fc\u30b8)\r\n\r\n\u7dcf\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u5bb9\u91cf: 71 M\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5bb9\u91cf: 265 M\r\n\r\n\u300a\u4e2d\u7565\u300b\r\n\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n  postgresql.x86_64 0:9.2.24-1.el7_5                 postgresql-contrib.x86_64 0:9.2.24-1.el7_5        postgresql-devel.x86_64 0:9.2.24-1.el7_5         postgresql-docs.x86_64 0:9.2.24-1.el7_5         \r\n  postgresql-jdbc.noarch 0:9.2.1002-6.el7_5          postgresql-libs.x86_64 0:9.2.24-1.el7_5           postgresql-odbc.x86_64 0:09.03.0100-2.el7        postgresql-plperl.x86_64 0:9.2.24-1.el7_5       \r\n  postgresql-plpython.x86_64 0:9.2.24-1.el7_5        postgresql-pltcl.x86_64 0:9.2.24-1.el7_5          postgresql-server.x86_64 0:9.2.24-1.el7_5        postgresql-test.x86_64 0:9.2.24-1.el7_5         \r\n\r\n\u4f9d\u5b58\u6027\u95a2\u9023\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3057\u305f:\r\n  copy-jdk-configs.noarch 0:3.3-10.el7_5         java-11-openjdk-headless.x86_64 1:11.0.ea.28-7.el7      javapackages-tools.noarch 0:3.4.1-11.el7      libjpeg-turbo.x86_64 0:1.2.90-6.el7              \r\n  lksctp-tools.x86_64 0:1.0.17-2.el7             perl.x86_64 4:5.16.3-293.el7                            perl-Carp.noarch 0:1.26-244.el7               perl-Encode.x86_64 0:2.51-7.el7                  \r\n  perl-Exporter.noarch 0:5.68-3.el7              perl-File-Path.noarch 0:2.09-2.el7                      perl-File-Temp.noarch 0:0.23.01-3.el7         perl-Filter.x86_64 0:1.49-3.el7                  \r\n  perl-Getopt-Long.noarch 0:2.40-3.el7           perl-HTTP-Tiny.noarch 0:0.033-3.el7                     perl-PathTools.x86_64 0:3.40-5.el7            perl-Pod-Escapes.noarch 1:1.04-293.el7           \r\n  perl-Pod-Perldoc.noarch 0:3.20-4.el7           perl-Pod-Simple.noarch 1:3.28-4.el7                     perl-Pod-Usage.noarch 0:1.63-3.el7            perl-Scalar-List-Utils.x86_64 0:1.27-248.el7     \r\n  perl-Socket.x86_64 0:2.010-4.el7               perl-Storable.x86_64 0:2.45-3.el7                       perl-Text-ParseWords.noarch 0:3.29-4.el7      perl-Time-HiRes.x86_64 4:1.9725-3.el7            \r\n  perl-Time-Local.noarch 0:1.2300-2.el7          perl-constant.noarch 0:1.27-2.el7                       perl-libs.x86_64 4:5.16.3-293.el7             perl-macros.x86_64 4:5.16.3-293.el7              \r\n  perl-parent.noarch 1:0.225-244.el7             perl-podlators.noarch 0:2.5.1-3.el7                     perl-threads.x86_64 0:1.87-4.el7              perl-threads-shared.x86_64 0:1.43-6.el7          \r\n  python-javapackages.noarch 0:3.4.1-11.el7      python-lxml.x86_64 0:3.2.1-4.el7                        tcl.x86_64 1:8.5.13-8.el7                     tzdata-java.noarch 0:2018e-3.el7                 \r\n  unixODBC.x86_64 0:2.3.1-11.el7                 uuid.x86_64 0:1.6.2-26.el7                             \r\n\r\n\u5b8c\u4e86\u3057\u307e\u3057\u305f!\r\n[root@cent76-d1 ~]# \r\n<\/code><\/pre>\n
2. PostgreSQL\u7684\u81ea\u52a8\u542f\u52a8\u548c\u8fd0\u884c<\/h1>\n
\u542f\u7528\u8fdb\u7a0b\u7684\u81ea\u52a8\u542f\u52a8\u3002<\/p>\n
[root@cent76-d1 ~]# systemctl enable postgresql\r\n\r\n[root@cent76-d1 ~]# systemctl is-enabled postgresql\r\nenabled\r\n[root@cent76-d1 ~]# \r\n<\/code><\/pre>\n
\u6211\u5c1d\u8bd5\u542f\u52a8\u8fdb\u7a0b\uff0c\u4f46\u9047\u5230\u4e86\u9519\u8bef\u63d0\u793a\u3002<\/p>\n
[root@cent76-d1 ~]# systemctl start postgresql\r\nJob for postgresql.service failed because the control process exited with error code. See \"systemctl status postgresql.service\" and \"journalctl -xe\" for details.\r\n[root@cent76-d1 ~]# \r\n<\/code><\/pre>\n
\u7531\u4e8e\u672a\u6267\u884cinitdb\u5904\u7406\uff0c\u5bfc\u81f4\u9519\u8bef\u7684\u539f\u56e0\uff0c\u56e0\u6b64\u6267\u884cinitdb\u7684\u64cd\u4f5c\u3002<\/p>\n
[root@cent76-d1 ~]# postgresql-setup initdb\r\nInitializing database ... OK\r\n\r\n[root@cent76-d1 ~]#  \r\n<\/code><\/pre>\n
\u4f7f\u7528\u8fd9\u4e2a\uff0c\u8fdb\u7a0b\u53ef\u4ee5\u6210\u529f\u542f\u52a8\u3002<\/p>\n
[root@cent76-d1 ~]# systemctl start postgresql\r\n[root@cent76-d1 ~]# \r\n<\/code><\/pre>\n
3. \u672c\u5730\u8fde\u63a5\u786e\u8ba4<\/h1>\n
\u9996\u5148\uff0c\u5728\u672c\u5730\u8fdb\u884c\u8fde\u63a5\u786e\u8ba4\u3002<\/p>\n
[root@cent76-d1 ~]# sudo -u postgres psql -U postgres\r\ncould not change directory to \"\/root\"\r\npsql (9.2.24)\r\nType \"help\" for help.\r\n\r\npostgres=# \r\npostgres=# \\q\r\n[root@cent76-d1 ~]# \r\n<\/code><\/pre>\n
4.\u8fdc\u7a0b\u8fde\u63a5\u8bbe\u7f6e\uff08postgresql.conf\uff09<\/h1>\n
\u4e3a\u4e86\u5b9a\u4e49\u63a5\u6536\u8fdc\u7a0b\u8fde\u63a5\u7684\u81ea\u6bb5\uff0c\u5c06\u4ee5\u4e0b\u914d\u7f6e\u6587\u4ef6\u8fdb\u884c\u8ffd\u52a0\u3002\u8ffd\u52a0\u90e8\u5206\u5728\u6700\u9876\u90e8\u4e00\u884c\u3002<\/p>\n
\u6587\u4ef6\u8def\u5f84\uff1a\/var\/lib\/pgsql\/data\/postgresql.conf<\/p>\n
listen_addresses =<\/span> '*'<\/span>                  ### CUSTOM ADD ###<\/span>\r\n#listen_addresses = 'localhost'     # what IP address(es) to listen on;<\/span>\r\n<\/code><\/pre>\n
5. \u8fdc\u7a0b\u8fde\u63a5\u8bbe\u7f6e(pg_hba.conf)<\/h1>\n
\u4e3a\u4e86\u5bf9\u8fdc\u7a0b\u8fde\u63a5\u7684\u6bb5\u8fdb\u884c\u8fde\u63a5\u5141\u8bb8\u8bbe\u7f6e\uff0c\u6211\u4eec\u5c06\u5728\u4ee5\u4e0b\u914d\u7f6e\u6587\u4ef6\u4e2d\u8fdb\u884c\u8ffd\u52a0\u3002\u8ffd\u52a0\u90e8\u5206\u4f4d\u4e8e\u6700\u540e\u7684\u4e24\u884c\u3002<\/p>\n
\u6587\u4ef6\u8def\u5f84\uff1a\/var\/lib\/pgsql\/data\/pg_hba.conf<\/p>\n
# TYPE  DATABASE        USER            ADDRESS                 METHOD<\/span>\r\n\r\n# \"local\" is for Unix domain socket connections only<\/span>\r\nlocal   <\/span>all             all                                     peer\r\n# IPv4 local connections:<\/span>\r\nhost    all             all             127.0.0.1\/32            ident\r\n# IPv6 local connections:<\/span>\r\nhost    all             all             ::1\/128                 ident\r\n# Allow replication connections from localhost, by a user with the<\/span>\r\n# replication privilege.<\/span>\r\n#local   replication     postgres                                peer<\/span>\r\n#host    replication     postgres        127.0.0.1\/32            ident<\/span>\r\n#host    replication     postgres        ::1\/128                 ident<\/span>\r\n\r\n### CUSTOM ADD ###<\/span>\r\nhost    all             postgres        10.0.1.0\/24             trust\r\n<\/code><\/pre>\n
\n
\u9805\u76ee\u5185\u5bb9\u8aac\u660eTYPEhost\u8a8d\u8a3c\u5bfe\u8c61\u3002’host’\u306f\u4efb\u610f\u306e\u5bfe\u8c61\u3002DATABASEall\u5bfe\u8c61DB\u3002’all’\u306f\u5168\u3066\u306eDB\u3092\u5bfe\u8c61\u3002USERpostgres\u5bfe\u8c61\u30e6\u30fc\u30b6\u3002’postgres’\u3067\u30b9\u30fc\u30d1\u30fc\u30e6\u30fc\u30b6\u306e\u307f\u306e\u6307\u5b9aADDRESS10.0.1.0\/24\u63a5\u7d9a\u5143\u3002\u6307\u5b9a\u306e\u30bb\u30b0\u30e1\u30f3\u30c8\u3092CIDR\u8868\u8a18\u3067\u8a18\u8f09\u3002METHODtrust\u8a8d\u8a3c\u65b9\u5f0f\u3002trust\u306f\u8a8d\u8a3c\u7121\u3057\u3067\u30ed\u30b0\u30a4\u30f3\u53ef\u80fd\u3002<\/div>\n<\/div>\n
\u5982\u679c\u5c06\u8ba4\u8bc1\u65b9\u6cd5\u8bbe\u7f6e\u4e3atrust\uff0c\u5219\u53ea\u9700\u4f7f\u7528\u7528\u6237\u540d\u5373\u53ef\u8fde\u63a5\uff0c\u56e0\u6b64\u5efa\u8bae\u5728\u9002\u5f53\u7684\u5efa\u7acb\u65f6\u673a\u66f4\u6539\u4e3amd5\u8ba4\u8bc1\u6216\u5bf9\u7b49\u8ba4\u8bc1\u3002<\/p>\n
\u4f7f\u7528pgAdmin\u8fdb\u884c\u8fde\u63a5\u3002<\/h1>\n
\"image.png\"<\/div>\n
\"image.png\"<\/div>\n
\"image.png\"<\/div>\n
\"image.png\"<\/div>\n","protected":false},"excerpt":{"rendered":"
\u8fd9\u662f\u5173\u4e8e\u4ece\u65b0\u5b89\u88c5PostgreSQL\u5230\u4f7f\u7528pgAdmin\u8fdb\u884c\u8fde\u63a5\u7684\u8bb0\u5f55\u3002 \u7ba1\u7406\u670d\u52a1\u5668 Windows Serv […]<\/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-41991","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2 - 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\/\u5728centos-7-6\u4e0a\u5b89\u88c5postgresql-9-2\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2\" \/>\n<meta property=\"og:description\" content=\"\u8fd9\u662f\u5173\u4e8e\u4ece\u65b0\u5b89\u88c5PostgreSQL\u5230\u4f7f\u7528pgAdmin\u8fdb\u884c\u8fde\u63a5\u7684\u8bb0\u5f55\u3002 \u7ba1\u7406\u670d\u52a1\u5668 Windows Serv […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728centos-7-6\u4e0a\u5b89\u88c5postgresql-9-2\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-25T00:08:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T02:00:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d4a4537434c4406cb24fd\/1-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\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/\",\"name\":\"\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-25T00:08:46+00:00\",\"dateModified\":\"2024-04-30T02:00:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2\"}]},{\"@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\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2 - 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\/\u5728centos-7-6\u4e0a\u5b89\u88c5postgresql-9-2\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2","og_description":"\u8fd9\u662f\u5173\u4e8e\u4ece\u65b0\u5b89\u88c5PostgreSQL\u5230\u4f7f\u7528pgAdmin\u8fdb\u884c\u8fde\u63a5\u7684\u8bb0\u5f55\u3002 \u7ba1\u7406\u670d\u52a1\u5668 Windows Serv […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728centos-7-6\u4e0a\u5b89\u88c5postgresql-9-2\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-25T00:08:46+00:00","article_modified_time":"2024-04-30T02:00:51+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d4a4537434c4406cb24fd\/1-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\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/","name":"\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-25T00:08:46+00:00","dateModified":"2024-04-30T02:00:51+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5728CentOS 7.6\u4e0a\u5b89\u88c5PostgreSQL 9.2"}]},{"@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\/%e5%9c%a8centos-7-6%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-2%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41991","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=41991"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41991\/revisions"}],"predecessor-version":[{"id":91236,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41991\/revisions\/91236"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}