{"id":42037,"date":"2023-12-26T07:53:39","date_gmt":"2023-08-23T21:02:04","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/"},"modified":"2024-05-04T15:27:09","modified_gmt":"2024-05-04T07:27:09","slug":"%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/","title":{"rendered":"\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6"},"content":{"rendered":"<h1>\u76ee\u7684\u548c\u80cc\u666f h\u00e9<\/h1>\n<p>\u7531\u4e8e\u5b89\u88c5\u6b65\u9aa4\u5206\u6563\u5728\u5404\u5904\uff0c\u6211\u5e0c\u671b\u6709\u4e00\u4efd\u6574\u5408\u4e86\u7684\u5b89\u88c5\u624b\u518c\u3002<\/p>\n<h1>\u6b64\u6587\u4ef6\u6240\u6db5\u76d6\u7684\u4e3b\u9898<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">CentOS 7.5 (systemd)<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Postgresql 9.6 (CentOS\u516c\u5f0f\u306f9.2)<\/ul>\n<h1>\u5b89\u88c5<\/h1>\n<h2>\u5c06 yum \u4ed3\u5e93\u8fdb\u884c\u6ce8\u518c<\/h2>\n<p>\u8bf7\u5728https:\/\/yum.postgresql.org\/repopackages.php\u9009\u62e9\u9002\u5408\u7684\u4ed3\u5e93\uff0c\u7136\u540e\u6267\u884cyum install &lt;\u9009\u62e9\u7684RPM\u7684URL&gt;<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>yum <span class=\"nb\">install <\/span>https:\/\/download.postgresql.org\/pub\/repos\/yum\/9.6\/redhat\/rhel-7-x86_64\/pgdg-centos96-9.6-3.noarch.rpm\r\n<span class=\"o\">(<\/span>\u4e2d\u7565<span class=\"o\">)<\/span>\r\n<span class=\"o\">================================================================================<\/span>\r\n Package           Arch       Version     Repository                       Size\r\n<span class=\"o\">================================================================================<\/span>\r\nInstalling:\r\n pgdg-centos96     noarch     9.6-3       \/pgdg-centos96-9.6-3.noarch     2.7 k\r\n\r\nTransaction Summary\r\n<span class=\"o\">================================================================================<\/span>\r\nInstall  1 Package\r\n\r\nTotal size: 2.7 k\r\nInstalled size: 2.7 k\r\nIs this ok <span class=\"o\">[<\/span>y\/d\/N]: y\r\n<span class=\"o\">(<\/span>\u4e2d\u7565<span class=\"o\">)<\/span>\r\nInstalled:\r\n  pgdg-centos96.noarch 0:9.6-3                                                  \r\n\r\nComplete!\r\n<\/code><\/pre>\n<h2>\u5b89\u88c5\u76ee\u6807\u8f6f\u4ef6\u5305\u3002<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>yum <span class=\"nb\">install <\/span>postgresql96-server\r\n<span class=\"o\">(<\/span>\u4e2d\u7565<span class=\"o\">)<\/span>\r\n<span class=\"o\">================================================================================<\/span>\r\n Package                  Arch        Version                 Repository   Size\r\n<span class=\"o\">================================================================================<\/span>\r\nInstalling:\r\n postgresql96-server      x86_64      9.6.9-1PGDG.rhel7       pgdg96      4.3 M\r\nInstalling <span class=\"k\">for <\/span>dependencies:\r\n postgresql96             x86_64      9.6.9-1PGDG.rhel7       pgdg96      1.4 M\r\n postgresql96-libs        x86_64      9.6.9-1PGDG.rhel7       pgdg96      315 k\r\n\r\nTransaction Summary\r\n<span class=\"o\">================================================================================<\/span>\r\nInstall  1 Package <span class=\"o\">(<\/span>+2 Dependent packages<span class=\"o\">)<\/span>\r\n\r\nTotal download size: 6.0 M\r\nInstalled size: 26 M\r\nIs this ok <span class=\"o\">[<\/span>y\/d\/N]: y\r\n<span class=\"o\">(<\/span>\u4e2d\u7565<span class=\"o\">)<\/span>\r\nInstalled:\r\n  postgresql96-server.x86_64 0:9.6.9-1PGDG.rhel7                                \r\n\r\nDependency Installed:\r\n  postgresql96.x86_64 0:9.6.9-1PGDG.rhel7                                       \r\n  postgresql96-libs.x86_64 0:9.6.9-1PGDG.rhel7                                  \r\n\r\nComplete!\r\n<\/code><\/pre>\n<h1>\u8fdb\u884c\u521d\u59cb\u8bbe\u7f6e<\/h1>\n<h2>\u6267\u884c\u6570\u636e\u5e93\u7684\u521d\u59cb\u5316\u64cd\u4f5c<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo<\/span> \/usr\/pgsql-9.6\/bin\/postgresql96-setup initdb\r\nInitializing database ... OK\r\n<\/code><\/pre>\n<h2>\u6253\u5f00\u7aef\u53e3\uff08\u53ef\u9009\uff09<\/h2>\n<p>\u5982\u679c\u60a8\u60f3\u8981\u4ece\u5916\u90e8\u8bbf\u95eePostgreSQL\u7aef\u53e3\uff0c\u8bf7\u6309\u7167\u4ee5\u4e0b\u6b65\u9aa4\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n<h3>\u8046\u542c&#8221;\u30a2\u30c9\u30ec\u30b9&#8221;\u7684\u914d\u7f6e<\/h3>\n<p>\u786e\u4fdd\u5bf9\u6240\u6709IP\u5730\u5740\u8fdb\u884c\u63a5\u6536\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>vi \/var\/lib\/pgsql\/9.6\/data\/postgresql.conf\r\n<\/code><\/pre>\n<p>\u8bf7\u6253\u5f00\u4e0a\u8ff0\u8bbe\u5b9a\u6587\u4ef6\uff0c\u6dfb\u52a0listen_addresses = &#8216;*&#8217;\u3002<\/p>\n<pre class=\"post-pre\"><code> # - Connection Settings -\r\n\r\n+listen_addresses = '*'\r\n #listen_addresses = 'localhost'         # what IP address(es) to listen on;\r\n                                         # comma-separated list of addresses;\r\n                                         # defaults to 'localhost'; use '*' for all\r\n                                         # (change requires restart)\r\n #port = 5432                            # (change requires restart)\r\n<\/code><\/pre>\n<h3>\u914d\u7f6e\u53d7\u4fe1\u8bb8\u53ef\u5730\u5740<\/h3>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>vi \/var\/lib\/pgsql\/9.6\/data\/pg_hba.conf\r\n<\/code><\/pre>\n<p>\u4ee5\u4e0b\u662f\u5141\u8bb8\u6765\u81ea\u6240\u6709IPv4\u5730\u5740\u7684\u8fde\u63a5\u3002<\/p>\n<pre class=\"post-pre\"><code> # IPv4 local connections:\r\n<span class=\"gd\">-host    all             all             127.0.0.1\/32            ident\r\n<\/span><span class=\"gi\">+#host    all             all             127.0.0.1\/32            ident\r\n+host    all             all             0.0.0.0\/0               md5\r\n<\/span> # IPv6 local connections:\r\n<\/code><\/pre>\n<h2>\u6253\u5f00\u9632\u706b\u5899\u7aef\u53e3<\/h2>\n<p>\u5982\u679cPostgreSQL\u7684\u7aef\u53e3\u8bbe\u7f6e\u4e3a\u9ed8\u8ba4\u503c\uff0c\u5219\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u6253\u5f00\u7aef\u53e3\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>firewall-cmd <span class=\"nt\">--add-service<\/span><span class=\"o\">=<\/span>postgresql <span class=\"nt\">--zone<\/span><span class=\"o\">=<\/span>public <span class=\"nt\">--permanent<\/span>\r\nsuccess\r\n<span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>firewall-cmd <span class=\"nt\">--reload<\/span>\r\nsuccess\r\n<\/code><\/pre>\n<h1>\u670d\u52a1\u542f\u52a8<\/h1>\n<h2>\u8fdb\u884c\u5bf9systemd\u7684\u6ce8\u518c<\/h2>\n<p>\u7531\u4e8e\u51c6\u5907\u5de5\u4f5c\u5df2\u7ecf\u5b8c\u6210\uff0c\u90a3\u4e48\u9996\u5148\u8981\u8ba9postgresql\u5904\u4e8e\u53ef\u7528\u72b6\u6001\u3002<\/p>\n<pre class=\"post-pre\"><code>$ sudo systemctl daemon-reload\r\n$ sudo systemctl enable postgresql-9.6.service\r\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/postgresql-9.6.service to \/usr\/lib\/systemd\/system\/postgresql-9.6.service.\r\n<\/code><\/pre>\n<h2>\u5f00\u59cb\u670d\u52a1<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>systemctl start postgresql-9.6\r\n<span class=\"o\">[<\/span>da@centos2 ~]<span class=\"nv\">$ <\/span><span class=\"nb\">sudo <\/span>systemctl status postgresql-9.6\r\n\u25cf postgresql-9.6.service - PostgreSQL 9.6 database server\r\n   Loaded: loaded <span class=\"o\">(<\/span>\/usr\/lib\/systemd\/system\/postgresql-9.6.service<span class=\"p\">;<\/span> enabled<span class=\"p\">;<\/span> vendor preset: disabled<span class=\"o\">)<\/span>\r\n   Active: active <span class=\"o\">(<\/span>running<span class=\"o\">)<\/span> since Tue 2018-07-17 12:35:35 EDT<span class=\"p\">;<\/span> 5s ago\r\n<span class=\"o\">(<\/span>\u4e2d\u7565<span class=\"o\">)<\/span>\r\nJul 17 12:35:35 centos2 systemd[1]: Started PostgreSQL 9.6 database server.\r\nHint: Some lines were ellipsized, use <span class=\"nt\">-l<\/span> to show <span class=\"k\">in <\/span>full\r\n<\/code><\/pre>\n<h1>\u767b\u5f55<\/h1>\n<h2>\u8fdb\u884c\u767b\u5f55\u8bbe\u7f6e<\/h2>\n<p>\u7528postgres\u7528\u6237\u4ecepsql\u8bbf\u95ee\u5e76\u521b\u5efa\u6570\u636e\u5e93\u5e76\u8bbe\u7f6e\u8bbf\u95ee\u6743\u9650\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span><span class=\"nb\">sudo<\/span> <span class=\"nt\">-u<\/span> postgres \/usr\/pgsql-9.6\/bin\/psql <span class=\"nt\">-U<\/span> postgres\r\npsql <span class=\"o\">(<\/span>9.6.9<span class=\"o\">)<\/span>\r\nType <span class=\"s2\">\"help\"<\/span> <span class=\"k\">for <\/span>help.\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"n\">postgres<\/span><span class=\"o\">=#<\/span> <span class=\"c1\">--\u30e6\u30fc\u30b6\u30fc\u4f5c\u6210(\u6ce8\u610f:test\u3068\u3044\u3046\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u305f\u3081\u3001\u305d\u306e\u307e\u307e\u4f7f\u7528\u3057\u306a\u3044\u3053\u3068)<\/span>\r\n<span class=\"n\">postgres<\/span><span class=\"o\">=#<\/span> <span class=\"k\">CREATE<\/span> <span class=\"k\">ROLE<\/span> <span class=\"n\">test<\/span> <span class=\"k\">WITH<\/span> <span class=\"n\">LOGIN<\/span> <span class=\"n\">PASSWORD<\/span> <span class=\"s1\">'test'<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">CREATE<\/span> <span class=\"k\">ROLE<\/span>\r\n<span class=\"n\">postgres<\/span><span class=\"o\">=#<\/span> <span class=\"c1\">--DB\u306e\u4f5c\u6210<\/span>\r\n<span class=\"n\">postgres<\/span><span class=\"o\">=#<\/span> <span class=\"k\">CREATE<\/span> <span class=\"k\">DATABASE<\/span> <span class=\"n\">test<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">CREATE<\/span> <span class=\"k\">DATABASE<\/span>\r\n<span class=\"n\">postgres<\/span><span class=\"o\">=#<\/span> <span class=\"c1\">--DB\u306e\u6240\u6709\u6a29\u3092\u79fb\u8ee2<\/span>\r\n<span class=\"n\">postgres<\/span><span class=\"o\">=#<\/span> <span class=\"k\">ALTER<\/span> <span class=\"k\">DATABASE<\/span> <span class=\"n\">test<\/span> <span class=\"k\">OWNER<\/span> <span class=\"k\">TO<\/span> <span class=\"n\">test<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">ALTER<\/span> <span class=\"k\">DATABASE<\/span>\r\n<span class=\"n\">postgres<\/span><span class=\"o\">=#<\/span> <span class=\"c1\">--\u4f5c\u696d\u5b8c\u4e86<\/span>\r\n<span class=\"n\">postgres<\/span><span class=\"o\">=#<\/span> <span class=\"err\">\\<\/span><span class=\"n\">q<\/span>\r\n<\/code><\/pre>\n<h2>\u8fdb\u884c\u767b\u5f55\u786e\u8ba4\uff08\u5728\u672c\u5730\u670d\u52a1\u5668\u4e0a\uff09<\/h2>\n<pre class=\"post-pre\"><code><span class=\"c\"># \u4ee5\u4e0b\u306e192.168.1.2\u306f\u30b5\u30fc\u30d0\u30fc\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068<\/span>\r\n<span class=\"nv\">$ <\/span>\/usr\/pgsql-9.6\/bin\/psql <span class=\"nt\">-h<\/span> 192.168.1.2 <span class=\"nt\">-U<\/span> <span class=\"nb\">test\r\n<\/span>Password <span class=\"k\">for <\/span>user <span class=\"nb\">test<\/span>: \r\npsql <span class=\"o\">(<\/span>9.6.9<span class=\"o\">)<\/span>\r\nType <span class=\"s2\">\"help\"<\/span> <span class=\"k\">for <\/span>help.\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"n\">test<\/span><span class=\"o\">=&gt;<\/span> <span class=\"err\">\\<\/span><span class=\"n\">l<\/span>\r\n                                  <span class=\"n\">List<\/span> <span class=\"k\">of<\/span> <span class=\"n\">databases<\/span>\r\n   <span class=\"n\">Name<\/span>    <span class=\"o\">|<\/span>  <span class=\"k\">Owner<\/span>   <span class=\"o\">|<\/span> <span class=\"k\">Encoding<\/span> <span class=\"o\">|<\/span>   <span class=\"k\">Collate<\/span>   <span class=\"o\">|<\/span>    <span class=\"n\">Ctype<\/span>    <span class=\"o\">|<\/span>   <span class=\"k\">Access<\/span> <span class=\"k\">privileges<\/span>   \r\n<span class=\"c1\">-----------+----------+----------+-------------+-------------+-----------------------<\/span>\r\n <span class=\"n\">postgres<\/span>  <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span> <span class=\"o\">|<\/span> <span class=\"n\">UTF8<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">en_US<\/span><span class=\"p\">.<\/span><span class=\"n\">UTF<\/span><span class=\"o\">-<\/span><span class=\"mi\">8<\/span> <span class=\"o\">|<\/span> <span class=\"n\">en_US<\/span><span class=\"p\">.<\/span><span class=\"n\">UTF<\/span><span class=\"o\">-<\/span><span class=\"mi\">8<\/span> <span class=\"o\">|<\/span> \r\n <span class=\"n\">template0<\/span> <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span> <span class=\"o\">|<\/span> <span class=\"n\">UTF8<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">en_US<\/span><span class=\"p\">.<\/span><span class=\"n\">UTF<\/span><span class=\"o\">-<\/span><span class=\"mi\">8<\/span> <span class=\"o\">|<\/span> <span class=\"n\">en_US<\/span><span class=\"p\">.<\/span><span class=\"n\">UTF<\/span><span class=\"o\">-<\/span><span class=\"mi\">8<\/span> <span class=\"o\">|<\/span> <span class=\"o\">=<\/span><span class=\"k\">c<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgres<\/span>          <span class=\"o\">+<\/span>\r\n           <span class=\"o\">|<\/span>          <span class=\"o\">|<\/span>          <span class=\"o\">|<\/span>             <span class=\"o\">|<\/span>             <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span><span class=\"o\">=<\/span><span class=\"n\">CTc<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgres<\/span>\r\n <span class=\"n\">template1<\/span> <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span> <span class=\"o\">|<\/span> <span class=\"n\">UTF8<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">en_US<\/span><span class=\"p\">.<\/span><span class=\"n\">UTF<\/span><span class=\"o\">-<\/span><span class=\"mi\">8<\/span> <span class=\"o\">|<\/span> <span class=\"n\">en_US<\/span><span class=\"p\">.<\/span><span class=\"n\">UTF<\/span><span class=\"o\">-<\/span><span class=\"mi\">8<\/span> <span class=\"o\">|<\/span> <span class=\"o\">=<\/span><span class=\"k\">c<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgres<\/span>          <span class=\"o\">+<\/span>\r\n           <span class=\"o\">|<\/span>          <span class=\"o\">|<\/span>          <span class=\"o\">|<\/span>             <span class=\"o\">|<\/span>             <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span><span class=\"o\">=<\/span><span class=\"n\">CTc<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgres<\/span>\r\n <span class=\"n\">test<\/span>      <span class=\"o\">|<\/span> <span class=\"n\">test<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">UTF8<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">en_US<\/span><span class=\"p\">.<\/span><span class=\"n\">UTF<\/span><span class=\"o\">-<\/span><span class=\"mi\">8<\/span> <span class=\"o\">|<\/span> <span class=\"n\">en_US<\/span><span class=\"p\">.<\/span><span class=\"n\">UTF<\/span><span class=\"o\">-<\/span><span class=\"mi\">8<\/span> <span class=\"o\">|<\/span> \r\n<span class=\"p\">(<\/span><span class=\"mi\">4<\/span> <span class=\"k\">rows<\/span><span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<h1>\u6545\u969c\u6392\u67e5<\/h1>\n<h2>\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\u3002<\/h2>\n<p>\u8bf7\u6309\u7167\u6307\u793a\u6267\u884cjournalctl -xe\u547d\u4ee4\u3002<br \/>\n\u5982\u679c\u63d0\u793a&#8221;\/var\/lib\/pgsql\/9.6\/data\/&#8221;\u76ee\u5f55\u4e0d\u5b58\u5728\u6216\u4e3a\u7a7a\uff0c\u8bf7\u53c2\u9605&#8221;\u6267\u884c\u6570\u636e\u5e93\u521d\u59cb\u5316&#8221;\u4e00\u8282\u3002<\/p>\n<h1>\u6587\u732e\u5f15\u7528<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">yum\u3067PostgreSQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u307f\u3088\u3046<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">PostgreSQL\u3067\u30e6\u30fc\u30b6\u30fc\uff08\u30ed\u30fc\u30eb\uff09\u3092\u8ffd\u52a0\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">CentOS7\u3067\u30dd\u30fc\u30c8\u3092\u958b\u653e\u3059\u308b\u65b9\u6cd5<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">yum\u3000\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8: \/usr\/share\/doc\/postgresql96-9.6.9\/README.rpm-dist<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u76ee\u7684\u548c\u80cc\u666f h\u00e9 \u7531\u4e8e\u5b89\u88c5\u6b65\u9aa4\u5206\u6563\u5728\u5404\u5904\uff0c\u6211\u5e0c\u671b\u6709\u4e00\u4efd\u6574\u5408\u4e86\u7684\u5b89\u88c5\u624b\u518c\u3002 \u6b64\u6587\u4ef6\u6240\u6db5\u76d6\u7684\u4e3b\u9898 CentOS 7 [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-42037","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>\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6 - 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\/\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728centos\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5postgresql-9-6\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6\" \/>\n<meta property=\"og:description\" content=\"\u76ee\u7684\u548c\u80cc\u666f h\u00e9 \u7531\u4e8e\u5b89\u88c5\u6b65\u9aa4\u5206\u6563\u5728\u5404\u5904\uff0c\u6211\u5e0c\u671b\u6709\u4e00\u4efd\u6574\u5408\u4e86\u7684\u5b89\u88c5\u624b\u518c\u3002 \u6b64\u6587\u4ef6\u6240\u6db5\u76d6\u7684\u4e3b\u9898 CentOS 7 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728centos\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5postgresql-9-6\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-23T21:02:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T07:27:09+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u626c\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \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%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/\",\"name\":\"\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-08-23T21:02:04+00:00\",\"dateModified\":\"2024-05-04T07:27:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6 - 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\/\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728centos\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5postgresql-9-6\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6","og_description":"\u76ee\u7684\u548c\u80cc\u666f h\u00e9 \u7531\u4e8e\u5b89\u88c5\u6b65\u9aa4\u5206\u6563\u5728\u5404\u5904\uff0c\u6211\u5e0c\u671b\u6709\u4e00\u4efd\u6574\u5408\u4e86\u7684\u5b89\u88c5\u624b\u518c\u3002 \u6b64\u6587\u4ef6\u6240\u6db5\u76d6\u7684\u4e3b\u9898 CentOS 7 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728centos\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5postgresql-9-6\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-08-23T21:02:04+00:00","article_modified_time":"2024-05-04T07:27:09+00:00","author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/","name":"\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-08-23T21:02:04+00:00","dateModified":"2024-05-04T07:27:09+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u901a\u8fc7yum\u5de5\u5177\uff0c\u4f60\u53ef\u4ee5\u5728CentOS\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u5b89\u88c5PostgreSQL-9.6"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e9%80%9a%e8%bf%87yum%e5%b7%a5%e5%85%b7%ef%bc%8c%e4%bd%a0%e5%8f%af%e4%bb%a5%e5%9c%a8centos%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f%e4%b8%8a%e5%ae%89%e8%a3%85postgresql-9-6%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\/42037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=42037"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42037\/revisions"}],"predecessor-version":[{"id":99138,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42037\/revisions\/99138"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=42037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=42037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=42037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}