{"id":41595,"date":"2023-05-11T22:55:57","date_gmt":"2023-12-05T02:01:19","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/"},"modified":"2024-04-30T03:42:23","modified_gmt":"2024-04-29T19:42:23","slug":"%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/","title":{"rendered":"\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\uff09"},"content":{"rendered":"<p>\u5927\u5bb6\u597d\uff01<\/p>\n<p>\u6211\u662fharu\uff0c\u662f\u4ece\u533b\u7597\u884c\u4e1a\u8f6c\u5230IT\u884c\u4e1a\u6311\u6218\u7684\uff0c\u73b0\u5728\u662f\u7b2c\u4e8c\u5e74\u4e86\u3002<\/p>\n<p>\u7531\u4e8e\u5728\u7b2c\u4e00\u5e74\u7684\u5de5\u4f5c\u4e2d\u4e3b\u8981\u6d89\u53caOracle\u6570\u636e\u5e93\uff0c\u6055\u6211\u4ee5\u6127\uff0c\u6211\u5b8c\u5168\u6ca1\u6709\u63a5\u89e6\u8fc7PostgreSQL\u3002\u56e0\u6b64\uff0c\u6211\u60f3\u5206\u4eab\u4e00\u4e0b\u5982\u4f55\u6784\u5efaPostgreSQL\u7684\u5b66\u4e60\u73af\u5883\u3002<\/p>\n<p>\u5b89\u88c5\u670d\u52a1\u5668\u7684\u64cd\u4f5c\u7cfb\u7edf\u662f RHEL8\u3002<br \/>\n\u987a\u4fbf\u63d0\u4e00\u4e0b\uff0c\u8981\u786e\u8ba4 RHEL \u7684\u7248\u672c\uff0c\u53ef\u4ee5\u4f7f\u7528 cat \u547d\u4ee4\u6216 uname -a \u547d\u4ee4\u6765\u67e5\u770b\u3002<\/p>\n<p>[\u53c2\u8003]<br \/>\n\u25bc\u786e\u8ba4 Linux \u7248\u672c\u7684\u65b9\u6cd5<br \/>\nhttps:\/\/qiita.com\/bezeklik\/items\/5edb638becd8858abb80<\/p>\n<pre class=\"post-pre\"><code>[root@postgreSQL ~]# cat \/proc\/version\r\nLinux version 4.18.0-372.9.1.el8.x86_64 (****) (gcc version 8.5.0 20210514 (Red Hat 8.5.0-10) (GCC)) #1 SMP Fri Apr 15 22:12:19 EDT 2022\r\n[root@postgreSQL ~]# uname -a\r\nLinux postgreSQL 4.18.0-372.9.1.el8.x86_64 #1 SMP Fri Apr 15 22:12:19 EDT 2022 x86_64 x86_64 x86_64 GNU\/Linux\r\n<\/code><\/pre>\n<h3>\u9884\u5148\u51c6\u5907<\/h3>\n<p>\u5728\u6784\u5efa\u4e4b\u524d\uff0c\u6211\u4eec\u7b80\u5355\u5730\u5b66\u4e60\u4e00\u4e0bPostgreSQL\u3002<\/p>\n<p>\u5927\u81f4\u6982\u8ff0<br \/>\n\u8fd9\u662f\u4e00\u4e2a\u5b8c\u5168\u5f00\u6e90\u7684\u6570\u636e\u5e93\uff0c\u6240\u6709\u6e90\u4ee3\u7801\u90fd\u662f\u516c\u5f00\u7684\u3002<br \/>\n\u5373\u4f7f\u6dfb\u52a0\u6216\u6539\u8fdb\u4e86\u5176\u72ec\u7279\u7684\u529f\u80fd\uff0c\u4e5f\u6ca1\u6709\u516c\u5f00\u7684\u4e49\u52a1\u3002<br \/>\n\u56e0\u6b64\uff0c\u8fd1\u5e74\u6765\u5b83\u88ab\u5e7f\u6cdb\u7528\u4e8e\u8bb8\u591a\u7cfb\u7edf\u5f00\u53d1\uff0c\u4ee5\u8fbe\u5230\u964d\u4f4e\u6210\u672c\u7684\u76ee\u7684\u3002<br \/>\n\u76ee\u524d\uff0c\u5b83\u5728\u5168\u7403\u6392\u540d\u7b2c\u56db\u3002<\/p>\n<p>1986\u5e74\uff1a\u5728\u52a0\u5dde\u5927\u5b66\u4f2f\u514b\u5229\u5206\u6821\uff0c\u8fc8\u514b\u5c14\u00b7\u65af\u901a\u5e03\u96f7\u514b\u62c5\u4efb\u4e2d\u5fc3\u4eba\u7269\uff0c\u5f00\u53d1\u4e86POSTGRES\u4f5c\u4e3aIngres\u7684\u7ee7\u4efb\u8005\u3002<br \/>\n1995\u5e74\uff1a\u5728\u52a0\u5dde\u5927\u5b66\u5f00\u53d1\u7ed3\u675f\u540e\uff0c\u5b89\u5fb7\u9c81\u00b7\u5c24\u548c\u4e54\u4e3d\u00b7\u9648\u8fdb\u884c\u4e86\u6539\u8fdb\uff0c\u4f7fSQL\u53ef\u4f7f\u7528\uff0c\u5e76\u4ee5Postgres95\u7684\u540d\u79f0\u53d1\u5e03\u3002<br \/>\n1996\u5e74\uff1a\u4ecePostgres95\u66f4\u540d\u4e3aPostgreSQL\u3002<\/p>\n<p>\u7531\u4e8e\u4ee5\u7528\u6237\u793e\u533a\u4e3a\u4e3b\u4f53\u7684\u652f\u6301\uff0c\u4e0e\u5176\u4ed6\u5173\u7cfb\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u76f8\u6bd4\uff0c\u65e0\u6cd5\u671f\u671b\u5f00\u53d1\u8005\u5728\u6545\u969c\u53d1\u751f\u65f6\u63d0\u4f9b\u652f\u6301\u3002\u7136\u800c\uff0c\u6709\u4e9b\u516c\u53f8\u63d0\u4f9b\u5546\u4e1a\u652f\u6301\uff0c\u56e0\u6b64\u4e5f\u53ef\u4ee5\u9009\u62e9\u4f7f\u7528\u8be5\u9009\u9879\u3002<\/p>\n<p>\u8349\u7387\u7684\u4ef7\u683c<br \/>\n\u514d\u8d39<\/p>\n<p>\u7b80\u7565\u7684\u5e73\u53f0<br \/>\n\u5e7f\u6cdb\u7684<\/p>\n<p>\u4e0eMySQL\u4e0d\u540c\uff0cPostgreSQL\u64c5\u957f\u5904\u7406\u590d\u6742\u4e14\u5927\u91cf\u7684\u6570\u636e\u64cd\u4f5c\u548c\u7ba1\u7406\u3002<br \/>\n\u9664\u4e86\u5904\u7406\u8868\u683c\u548c\u5217\u7684\u4fe1\u606f\u5916\uff0c\u5b83\u8fd8\u80fd\u5b9a\u4e49\u6570\u636e\u7c7b\u578b\u3001\u7d22\u5f15\u7c7b\u578b\u548c\u51fd\u6570\uff0c\u5177\u6709\u826f\u597d\u7684\u591a\u5904\u7406\u5e76\u53d1\u6027\u3002<br \/>\n\u6b64\u5916\uff0c\u76f8\u6bd4MySQL\uff0cPostgreSQL\u64c5\u957f\u5904\u7406\u5e9e\u5927\u7684\u6570\u636e\u6392\u5e8f\uff0c\u5176\u6392\u5e8f\u7b97\u6cd5\u66f4\u4e3a\u4f18\u79c0\u3002<\/p>\n<p>\u3010\u53c2\u8003\u3011<br \/>\n\u25bc\u7ef4\u57fa\u767e\u79d1<br \/>\nhttps:\/\/zh.wikipedia.org\/wiki\/PostgreSQL<\/p>\n<p>\u25bcDB-Engines \u6392\u540d &#8211; \u8d8b\u52bf\u4eba\u6c14<br \/>\n\u8bf7\u8bbf\u95eehttps:\/\/db-engines.com\/en\/ranking_trend \u83b7\u53d6\u66f4\u591a\u4fe1\u606f\u3002<\/p>\n<p>\u90a3\u4e48\uff0c\u6211\u4eec\u5f00\u59cb\u6784\u5efa\u5427\u3002<\/p>\n<h3>\u4e0b\u8f7dPostgreSQL\u8f6f\u4ef6\u5305<\/h3>\n<p>\u4ece\u7f51\u7ad9\u4e0a\u4e0b\u8f7dPostgreSQL\u8f6f\u4ef6\u5305\u3002<\/p>\n<p>[\u53c2\u8003]<br \/>\n\u25bc PostgreSQL\u7528\u6237\u534f\u4f1a<br \/>\nhttps:\/\/www.postgresql.jp\/download<\/p>\n<pre class=\"post-pre\"><code>[root@postgreSQL tmp]# ll\r\n\u5408\u8a08 36\r\n\u30fb\u30fb\u30fb\r\n-rw-r--r--. 1 root     root     13168 10\u6708 14 03:04 pgdg-redhat-repo-latest.noarch.rpm\r\n\u30fb\u30fb\u30fb\r\n<\/code><\/pre>\n<h3>\u4f7f\u7528rpm\u547d\u4ee4\u5b89\u88c5\u8f6f\u4ef6\u5305\u3002<\/h3>\n<p>\u63a5\u4e0b\u6765\uff0c\u4f7f\u7528rpm\u547d\u4ee4\u5b89\u88c5\u4e0b\u8f7d\u7684\u8f6f\u4ef6\u5305\u3002<\/p>\n<pre class=\"post-pre\"><code>[root@postgreSQL tmp]# rpm -ivh pgdg-redhat-repo-latest.noarch.rpm\r\n\u8b66\u544a: pgdg-redhat-repo-latest.noarch.rpm: \u30d8\u30c3\u30c0\u30fc V4 DSA\/SHA1 Signature\u3001\u9375 ID 442df0f8: NOKEY\r\nVerifying...                          ################################# [100%]\r\n\u6e96\u5099\u3057\u3066\u3044\u307e\u3059...              ################################# [100%]\r\n        \u30d1\u30c3\u30b1\u30fc\u30b8 pgdg-redhat-repo-42.0-27.noarch \u306f\u65e2\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u307e\u3059\u3002\r\n\r\n-pgdg\uff5e \u30d5\u30a1\u30a4\u30eb\u304c \/etc\/yum.repo.d\/ \u914d\u4e0b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f\u304b\u78ba\u8a8d\r\n[root@postgreSQL etc]# cd yum.repos.d\r\n[root@postgreSQL yum.repos.d]# ll\r\n\u5408\u8a08 16\r\n-rw-r--r--. 1 root root 11419  9\u6708 29 10:22 pgdg-redhat-all.repo\r\n-rw-r--r--. 1 root root   358 10\u6708 14 02:31 redhat.repo\r\n\r\n[root@postgreSQL yum.repos.d]# pwd\r\n\/etc\/yum.repos.d\r\n<\/code><\/pre>\n<h3>\u641c\u7d22\u8981\u5b89\u88c5\u7684PostgreSQL\u3002<\/h3>\n<p>\u6211\u4f1a\u67e5\u627e\u8981\u5b89\u88c5\u7684\u8f6f\u4ef6\u5305\u7684\u540d\u79f0\u3002<\/p>\n<pre class=\"post-pre\"><code>[root@postgreSQL yum.repos.d]# yum search postgresql\r\n\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3\u7ba1\u7406\u30ea\u30dd\u30b8\u30c8\u30ea\u30fc\u3092\u66f4\u65b0\u3057\u3066\u3044\u307e\u3059\u3002\r\n\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30fc\u8b58\u5225\u5b50\u3092\u8aad\u307f\u8fbc\u3081\u307e\u305b\u3093\r\n\r\n\u3053\u306e\u30b7\u30b9\u30c6\u30e0\u306f\u3001\u30a8\u30f3\u30bf\u30a4\u30c8\u30eb\u30e1\u30f3\u30c8\u30b5\u30fc\u30d0\u30fc\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002subscription-manager \u3067\u767b\u9332\u3067\u304d\u307e\u3059\u3002\r\n\r\n\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u671f\u9650\u5207\u308c\u306e\u6700\u7d42\u78ba\u8a8d: 0:24:39 \u6642\u9593\u524d\u306e 2022\u5e7410\u670814\u65e5 03\u664214\u520603\u79d2 \u306b\u5b9f\u65bd\u3057\u307e\u3057\u305f\u3002\r\n====================================== \u540d\u524d &amp; \u6982\u8981 \u4e00\u81f4: postgresql ======================================\r\npostgresql-unit10.x86_64 : SI Units for PostgreSQL\r\npostgresql-unit11.x86_64 : SI Units for PostgreSQL\r\npostgresql-unit12.x86_64 : SI Units for PostgreSQL\r\npostgresql-unit13.x86_64 : SI Units for PostgreSQL\r\n\u30fb\r\n\u30fb\r\n\u30fb\r\npostgresql15-pltcl.x86_64 : The Tcl procedural language for PostgreSQL\r\npostgresql15-server.x86_64 : The programs needed to create and run a PostgreSQL server \/*\u4eca\u56de\u306f\u3053\u308c\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002*\/\r\npostgresql15-tcl.x86_64 : A Tcl client library for PostgreSQL\r\npostgresql15-test.x86_64 : The test suite distributed with PostgreSQL\r\n<\/code><\/pre>\n<h3>\u5b89\u88c5postgresql15-server.x86_64<\/h3>\n<p>\u6211\u4eec\u5c06\u4f7f\u7528yum\u5de5\u5177\u6765\u5b89\u88c5\u901a\u8fc73\u5728\u67e5\u627e\u5230\u7684postgresql15-server.x86_64\u7248\u672c\u3002<\/p>\n<pre class=\"post-pre\"><code>[root@postgreSQL yum.repos.d]# yum install postgresql15-server.x86_64\r\n\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3\u7ba1\u7406\u30ea\u30dd\u30b8\u30c8\u30ea\u30fc\u3092\u66f4\u65b0\u3057\u3066\u3044\u307e\u3059\u3002\r\n\u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u30fc\u8b58\u5225\u5b50\u3092\u8aad\u307f\u8fbc\u3081\u307e\u305b\u3093\r\n\r\n\u3053\u306e\u30b7\u30b9\u30c6\u30e0\u306f\u3001\u30a8\u30f3\u30bf\u30a4\u30c8\u30eb\u30e1\u30f3\u30c8\u30b5\u30fc\u30d0\u30fc\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002subscription-manager \u3067\u767b\u9332\u3067\u304d\u307e\u3059\u3002\r\n\r\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64                        111  B\/s | 195  B     00:01\r\nPostgreSQL 15 for RHEL \/ Rocky 8 - x86_64                                  94  B\/s | 195  B     00:02\r\nPostgreSQL 14 for RHEL \/ Rocky 8 - x86_64                                  87  B\/s | 195  B     00:02\r\nPostgreSQL 13 for RHEL \/ Rocky 8 - x86_64                                  89  B\/s | 195  B     00:02\r\nPostgreSQL 12 for RHEL \/ Rocky 8 - x86_64                                 112  B\/s | 195  B     00:01\r\nPostgreSQL 11 for RHEL \/ Rocky 8 - x86_64                                  89  B\/s | 195  B     00:02\r\nPostgreSQL 10 for RHEL \/ Rocky 8 - x86_64                                  84  B\/s | 195  B     00:02\r\n\u4f9d\u5b58\u95a2\u4fc2\u304c\u89e3\u6c7a\u3057\u307e\u3057\u305f\u3002\r\n==========================================================================================================\r\n \u30d1\u30c3\u30b1\u30fc\u30b8                      \u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc   \u30d0\u30fc\u30b8\u30e7\u30f3                   \u30ea\u30dd\u30b8\u30c8\u30ea\u30fc       \u30b5\u30a4\u30ba\r\n==========================================================================================================\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n postgresql15-server             x86_64             15.0-1PGDG.rhel8             pgdg15             5.8 M\r\n\u4f9d\u5b58\u95a2\u4fc2\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n postgresql15                    x86_64             15.0-1PGDG.rhel8             pgdg15             1.6 M\r\n postgresql15-libs               x86_64             15.0-1PGDG.rhel8             pgdg15             287 k\r\n\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u6982\u8981\r\n==========================================================================================================\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb  3 \u30d1\u30c3\u30b1\u30fc\u30b8\r\n\r\n\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30a4\u30ba\u306e\u5408\u8a08: 7.7 M\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5f8c\u306e\u30b5\u30a4\u30ba: 32 M\r\n\u3053\u308c\u3067\u3088\u308d\u3057\u3044\u3067\u3059\u304b? [y\/N]: y\r\n\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9:\r\n(1\/3): postgresql15-libs-15.0-1PGDG.rhel8.x86_64.rpm                      139 kB\/s | 287 kB     00:02\r\n(2\/3): postgresql15-15.0-1PGDG.rhel8.x86_64.rpm                           628 kB\/s | 1.6 MB     00:02\r\n(3\/3): postgresql15-server-15.0-1PGDG.rhel8.x86_64.rpm                    1.5 MB\/s | 5.8 MB     00:03\r\n----------------------------------------------------------------------------------------------------------\r\n\u5408\u8a08                                                                      2.0 MB\/s | 7.7 MB     00:03\r\nPostgreSQL 15 for RHEL \/ Rocky 8 - x86_64                                 1.6 MB\/s | 1.7 kB     00:00\r\nGPG \u9375 0x442DF0F8 \u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u4e2d:\r\n Userid     : \"PostgreSQL RPM Building Project &lt;pgsql-pkg-yum@postgresql.org&gt;\"\r\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\r\n From       : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\r\n\u3053\u308c\u3067\u3088\u308d\u3057\u3044\u3067\u3059\u304b? [y\/N]: y\r\n\u9375\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306b\u6210\u529f\u3057\u307e\u3057\u305f\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u3092\u5b9f\u884c\u4e2d\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30c6\u30b9\u30c8\u3092\u5b9f\u884c\u4e2d\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30c6\u30b9\u30c8\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u4e2d\r\n  \u6e96\u5099             :                                                                                  1\/1\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : postgresql15-libs-15.0-1PGDG.rhel8.x86_64                                        1\/3\r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: postgresql15-libs-15.0-1PGDG.rhel8.x86_64                                        1\/3\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : postgresql15-15.0-1PGDG.rhel8.x86_64                                             2\/3\r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: postgresql15-15.0-1PGDG.rhel8.x86_64                                             2\/3\r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: postgresql15-server-15.0-1PGDG.rhel8.x86_64                                      3\/3\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : postgresql15-server-15.0-1PGDG.rhel8.x86_64                                      3\/3\r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: postgresql15-server-15.0-1PGDG.rhel8.x86_64                                      3\/3\r\n  \u691c\u8a3c             : postgresql15-15.0-1PGDG.rhel8.x86_64                                             1\/3\r\n  \u691c\u8a3c             : postgresql15-libs-15.0-1PGDG.rhel8.x86_64                                        2\/3\r\n  \u691c\u8a3c             : postgresql15-server-15.0-1PGDG.rhel8.x86_64                                      3\/3\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f\u306e\u88fd\u54c1\u304c\u66f4\u65b0\u3055\u308c\u3066\u3044\u307e\u3059\u3002\r\n\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f:\r\n  postgresql15-15.0-1PGDG.rhel8.x86_64                 postgresql15-libs-15.0-1PGDG.rhel8.x86_64\r\n  postgresql15-server-15.0-1PGDG.rhel8.x86_64\r\n\r\n\u5b8c\u4e86\u3057\u307e\u3057\u305f!\r\n<\/code><\/pre>\n<p>\u4e3a\u4e86\u786e\u4fdd\uff0c\u6211\u60f3\u786e\u8ba4\u4e00\u4e0b\u3002<\/p>\n<pre class=\"post-pre\"><code>[root@postgreSQL yum.repos.d]# rpm -qa | grep postgres\r\npostgresql15-server-15.0-1PGDG.rhel8.x86_64\r\npostgresql15-libs-15.0-1PGDG.rhel8.x86_64\r\npostgresql15-15.0-1PGDG.rhel8.x86_64\r\n<\/code><\/pre>\n<p>\u770b\u8d77\u6765\u5b89\u88c5\u6210\u529f\u4e86\uff01<\/p>\n<p>\u5b89\u88c5\u597d\u4e86\uff0c\u4f46\u4e4b\u540e\u5e94\u8be5\u600e\u4e48\u529e\u5462\uff1f<\/p>\n<h3>5. \u542f\u52a8PostgreSQL<\/h3>\n<p>\u6211\u60f3\u542f\u52a8\uff0c\u4f46\u547d\u4ee4\u65e0\u6cd5\u6267\u884c\u3002<\/p>\n<pre class=\"post-pre\"><code>[root@postgreSQL yum.repos.d]# sudo postgresql-setup initdb\r\nsudo: postgresql-setup: \u30b3\u30de\u30f3\u30c9\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\r\n[root@postgreSQL init.d]# service start initdb\r\nThe service command supports only basic LSB actions (start, stop, restart, try-restart, reload, force-reload, status). For other actions, please try to use systemctl.\r\n[root@postgreSQL init.d]# systemctl start initdb\r\nFailed to start initdb.service: Unit initdb.service not found.\r\n\r\n\r\n\/*\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5931\u6557\u3057\u3066\u308b ??*\/\r\n\/*\u3067\u3082\u3001\u4ee5\u4e0b\u306e\u901a\u308a postgres \u30e6\u30fc\u30b6\u30fc\u306f\u5b58\u5728\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5931\u6557\u3063\u3066\u3044\u3046\u8a33\u3067\u306f\u306a\u3055\u305d\u3046\u3002*\/\r\n\r\n[root@postgreSQL ~]# id postgres\r\nuid=26(postgres) gid=26(postgres) groups=26(postgres)\r\n<\/code><\/pre>\n<p>\u5728\u8fd9\u91cc\u5411\u5e08\u7236\u8bf7\u6559\u540e\uff0c\u6211\u5f97\u5230\u4e86\u4ee5\u4e0b\u7684\u5efa\u8bae\u3002<\/p>\n<p>\u300c\u6211\u89c9\u5f97Oracle\u4e5f\u662f\u4e00\u6837\u7684\uff0c\u5982\u679c\u4e0d\u6307\u5b9abin\u547d\u4ee4\uff0c\u5c31\u4e0d\u80fd\u901a\u8fc7\u300d<br \/>\n\u300c\u5b89\u88c5\u540e\u53ef\u80fd\u8fd8\u9700\u8981\u4e00\u4e9b\u5fc5\u8981\u7684\u8bbe\u7f6e\uff08\u5982\u73af\u5883\u53d8\u91cf\uff09\uff0c\u6240\u4ee5\u8981\u6ce8\u610f\u8fd9\u4e00\u70b9\uff0c\u53ef\u80fd\u4f1a\u5f88\u6709\u5e2e\u52a9\u300d<\/p>\n<p>\u867d\u7136\u975e\u5e38\u57fa\u672c\u7684\u7684\u4e1c\u897f\u88ab\u5ffd\u7565\u4e86\uff0c\u611f\u5230\u5f88\u5c34\u5c2c\uff0c\u4f46\u662f\u786e\u5b9e\u5982\u6b64\u554a\uff0c\u771f\u662f\u611f\u6fc0\u4e0d\u5c3d\u3002<br \/>\n\u5c06\u73af\u5883\u53d8\u91cf\u8fdb\u884c\u8bbe\u7f6e\u3002\u3002<\/p>\n<p>\u3010\u53c2\u8003\u3011PostgreSQL\u7684\u5f15\u5165\u548c\u8fde\u63a5<\/p>\n<p>\u8bf7\u53c2\u8003\u4ee5\u4e0b\u94fe\u63a5\uff1a https:\/\/atmarkit.itmedia.co.jp\/ait\/articles\/0806\/10\/news144_2.html<\/p>\n<pre class=\"post-pre\"><code>[postgres@postgreSQL data]$ export PATH=$PATH:\/usr\/pgsql-15\/bin\r\n[postgres@postgreSQL data]$ export MANPATH=$MANPATH:\/usr\/pgsql-15\/share\/man\r\n[postgres@postgreSQL data]$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:\/usr\/pgsql-15\/lib\r\n[postgres@postgreSQL data]$ export PGDATA=\/var\/lib\/pgsql\/15\/data\r\n[postgres@postgreSQL data]$\r\n[postgres@postgreSQL data]$ initdb --encoding=UTF8 --no-locale\r\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b7\u30b9\u30c6\u30e0\u5185\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u6240\u6709\u8005\u306f\u30e6\u30fc\u30b6\u30fc\"postgres\"\u3068\u306a\u308a\u307e\u3059\u3002\r\n\u3053\u306e\u30e6\u30fc\u30b6\u30fc\u3092\u30b5\u30fc\u30d0\u30fc\u30d7\u30ed\u30bb\u30b9\u306e\u6240\u6709\u8005\u3068\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\r\n\r\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30af\u30e9\u30b9\u30bf\u306f\u30ed\u30b1\u30fc\u30eb\"C\"\u3067\u521d\u671f\u5316\u3055\u308c\u307e\u3059\u3002\r\n\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u69cb\u6210\u306f english \u306b\u8a2d\u5b9a\u3055\u308c\u307e\u3059\u3002\r\n\r\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b8\u306e\u30c1\u30a7\u30c3\u30af\u30b5\u30e0\u306f\u7121\u52b9\u3067\u3059\u3002\r\n\r\n\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\/var\/lib\/pgsql\/15\/data\u306e\u6a29\u9650\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059 ... ok\r\n\u30b5\u30d6\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059 ... ok\r\n\u52d5\u7684\u5171\u6709\u30e1\u30e2\u30ea\u306e\u5b9f\u88c5\u3092\u9078\u629e\u3057\u3066\u3044\u307e\u3059 ... posix\r\n\u30c7\u30d5\u30a9\u30eb\u30c8\u306emax_connections\u3092\u9078\u629e\u3057\u3066\u3044\u307e\u3059 ... 100\r\n\u30c7\u30d5\u30a9\u30eb\u30c8\u306eshared_buffers\u3092\u9078\u629e\u3057\u3066\u3044\u307e\u3059 ... 128MB\r\n\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u6642\u9593\u5e2f\u3092\u9078\u629e\u3057\u3066\u3044\u307e\u3059 ... America\/New_York\r\n\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059 ... ok\r\n\u30d6\u30fc\u30c8\u30b9\u30c8\u30e9\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3057\u3066\u3044\u307e\u3059 ... ok\r\n\u30d6\u30fc\u30c8\u30b9\u30c8\u30e9\u30c3\u30d7\u5f8c\u306e\u521d\u671f\u5316\u3092\u5b9f\u884c\u3057\u3066\u3044\u307e\u3059 ... ok\r\n\u30c7\u30fc\u30bf\u3092\u30c7\u30a3\u30b9\u30af\u306b\u540c\u671f\u3057\u3066\u3044\u307e\u3059 ... ok\r\n\r\ninitdb: \u8b66\u544a: \u30ed\u30fc\u30ab\u30eb\u63a5\u7d9a\u306b\u5bfe\u3057\u3066\"trust\"\u8a8d\u8a3c\u3092\u6709\u52b9\u306b\u3057\u307e\u3059\r\ninitdb: \u30d2\u30f3\u30c8: pg_hba.conf\u3092\u7de8\u96c6\u3059\u308b\u3001\u3082\u3057\u304f\u306f\u3001\u6b21\u56deinitdb\u3092\u5b9f\u884c\u3059\u308b\u6642\u306b -A \u30aa\u30d7\u30b7\u30e7\u30f3\u3001\r\n        \u3042\u308b\u3044\u306f --auth-local \u304a\u3088\u3073 --auth-host \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u5909\u66f4\u3067\u304d\u307e\u3059\u3002\r\n\r\n\u6210\u529f\u3057\u307e\u3057\u305f\u3002\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u3092\u8d77\u52d5\u3067\u304d\u307e\u3059: \/*\u6765\u305f\u6765\u305f\uff01*\/\r\n\r\n    pg_ctl -D \/var\/lib\/pgsql\/15\/data -l \u30ed\u30b0\u30d5\u30a1\u30a4\u30eb start \r\n<\/code><\/pre>\n<p>\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u6b63\u5f0f\u542f\u52a8 PostgreSQL\u3002<\/p>\n<pre class=\"post-pre\"><code>\/*\u8d77\u52d5*\/\r\n[postgres@postgreSQL data]$ pg_ctl -w start\r\n\u30b5\u30fc\u30d0\u30fc\u306e\u8d77\u52d5\u5b8c\u4e86\u3092\u5f85\u3063\u3066\u3044\u307e\u3059....2022-10-17 02:10:44.595 EDT [167739] LOG:  redirecting log output to logging collector process\r\n2022-10-17 02:10:44.595 EDT [167739] HINT:  Future log output will appear in directory \"log\".\r\n\u5b8c\u4e86\r\n\u30b5\u30fc\u30d0\u30fc\u8d77\u52d5\u5b8c\u4e86\r\n\r\n\/*\u505c\u6b62*\/\r\n[postgres@postgreSQL data]$ pg_ctl stop\r\n\u30b5\u30fc\u30d0\u30fc\u505c\u6b62\u51e6\u7406\u306e\u5b8c\u4e86\u3092\u5f85\u3063\u3066\u3044\u307e\u3059....\u5b8c\u4e86\r\n\u30b5\u30fc\u30d0\u30fc\u306f\u505c\u6b62\u3057\u307e\u3057\u305f\r\n<\/code><\/pre>\n<p>\u56e0\u4e3a\u5fd8\u8bb0\u4e86\u57fa\u672c\u7684\u73af\u5883\u53d8\u91cf\u800c\u7cbe\u795e\u5d29\u6e83\u4e86\uff0c\u6240\u4ee5\u8fd9\u6b21\u5c31\u5230\u8fd9\u91cc\u5427\u3002<\/p>\n<p>\u518d\u89c1\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5927\u5bb6\u597d\uff01 \u6211\u662fharu\uff0c\u662f\u4ece\u533b\u7597\u884c\u4e1a\u8f6c\u5230IT\u884c\u4e1a\u6311\u6218\u7684\uff0c\u73b0\u5728\u662f\u7b2c\u4e8c\u5e74\u4e86\u3002 \u7531\u4e8e\u5728\u7b2c\u4e00\u5e74\u7684\u5de5\u4f5c\u4e2d\u4e3b\u8981\u6d89\u53caOrac [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41595","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>\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\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\/\u968f\u4fbf\u5b66\u4e60-postgresql\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08rhel8\uff09\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\uff09\" \/>\n<meta property=\"og:description\" content=\"\u5927\u5bb6\u597d\uff01 \u6211\u662fharu\uff0c\u662f\u4ece\u533b\u7597\u884c\u4e1a\u8f6c\u5230IT\u884c\u4e1a\u6311\u6218\u7684\uff0c\u73b0\u5728\u662f\u7b2c\u4e8c\u5e74\u4e86\u3002 \u7531\u4e8e\u5728\u7b2c\u4e00\u5e74\u7684\u5de5\u4f5c\u4e2d\u4e3b\u8981\u6d89\u53caOrac [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u968f\u4fbf\u5b66\u4e60-postgresql\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08rhel8\uff09\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-05T02:01:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T19:42:23+00:00\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\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\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/\",\"name\":\"\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\uff09 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-12-05T02:01:19+00:00\",\"dateModified\":\"2024-04-29T19:42:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\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\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\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\/\u968f\u4fbf\u5b66\u4e60-postgresql\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08rhel8\uff09\/","og_locale":"zh_CN","og_type":"article","og_title":"\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\uff09","og_description":"\u5927\u5bb6\u597d\uff01 \u6211\u662fharu\uff0c\u662f\u4ece\u533b\u7597\u884c\u4e1a\u8f6c\u5230IT\u884c\u4e1a\u6311\u6218\u7684\uff0c\u73b0\u5728\u662f\u7b2c\u4e8c\u5e74\u4e86\u3002 \u7531\u4e8e\u5728\u7b2c\u4e00\u5e74\u7684\u5de5\u4f5c\u4e2d\u4e3b\u8981\u6d89\u53caOrac [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u968f\u4fbf\u5b66\u4e60-postgresql\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08rhel8\uff09\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-12-05T02:01:19+00:00","article_modified_time":"2024-04-29T19:42:23+00:00","author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/","name":"\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\uff09 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-12-05T02:01:19+00:00","dateModified":"2024-04-29T19:42:23+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%ef%bc%89\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u968f\u4fbf\u5b66\u4e60- PostgreSQL\u7684\u8bbe\u7f6e\u6559\u7a0b\uff08RHEL8\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\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%9a%8f%e4%be%bf%e5%ad%a6%e4%b9%a0-postgresql%e7%9a%84%e8%ae%be%e7%bd%ae%e6%95%99%e7%a8%8b%ef%bc%88rhel8%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\/41595","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41595"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41595\/revisions"}],"predecessor-version":[{"id":89470,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41595\/revisions\/89470"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}