{"id":41835,"date":"2023-07-05T11:04:36","date_gmt":"2023-07-28T17:59:40","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/"},"modified":"2024-04-30T12:05:08","modified_gmt":"2024-04-30T04:05:08","slug":"%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/","title":{"rendered":"\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8"},"content":{"rendered":"<h1>\u9996\u5148<\/h1>\n<p>\u5728\u901a\u8fc7&#8221;\u6700\u4f4e\u9650\u7684\u5b89\u88c5&#8221;\u65b9\u5f0f\u5b89\u88c5\u7684CentOS-8.1.1911-x86_64\u73af\u5883\u4e2d\uff0c\u6211\u4eec\u5c06\u4ece\u6e90\u4ee3\u7801\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684PostgreSQL12.x\u3002<\/p>\n<h1>\u6574\u4e2a\u64cd\u4f5c\u7cfb\u7edf\u7684\u66f4\u65b0<\/h1>\n<pre class=\"post-pre\"><code>dnf <span class=\"nt\">-y<\/span> update\r\n<\/code><\/pre>\n<h1>\u5b89\u88c5\u5fc5\u8981\u7684\u8f6f\u4ef6<\/h1>\n<pre class=\"post-pre\"><code>dnf <span class=\"nt\">-y<\/span> <span class=\"nb\">install <\/span>gcc gcc-c++ make wget <span class=\"nb\">tar <\/span>zlib-devel readline-devel\r\n<\/code><\/pre>\n<h1>\u5b89\u88c5PostgreSQL<\/h1>\n<p>\u8bf7\u4ee5root\u6743\u9650\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n<h2>\u521b\u5efa\u7528\u6237<\/h2>\n<p>\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a &#8220;postgres&#8221; \u7684\u7528\u6237\uff0c\u7528\u4e8e\u7f16\u8bd1\u548c\u6267\u884c PostgreSQL\u3002<\/p>\n<pre class=\"post-pre\"><code>useradd postgres\r\npasswd postgres\r\n<\/code><\/pre>\n<h2>\u4e0b\u8f7d\u6e90\u4ee3\u7801\u3002<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nb\">cd<\/span> \/usr\/local\/src\/\r\nwget https:\/\/ftp.postgresql.org\/pub\/source\/v12.2\/postgresql-12.2.tar.gz\r\n<\/code><\/pre>\n<h2>\u8fdb\u884c<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nb\">tar <\/span>xzf postgresql-12.2.tar.gz\r\n<\/code><\/pre>\n<h2>\u66f4\u6362\u6240\u6709\u8005<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nb\">chown<\/span> <span class=\"nt\">-R<\/span> postgres \/usr\/local\/src\/postgresql-12.2\r\n<\/code><\/pre>\n<h1>\u521b\u5efa\u5b89\u88c5\u76ee\u5f55\uff08\u540c\u65f6\u8bbe\u5b9a\u6240\u6709\u8005\uff09<\/h1>\n<pre class=\"post-pre\"><code><span class=\"nb\">mkdir<\/span> \/usr\/local\/pgsql12.2\r\n<span class=\"nb\">chown <\/span>postgres \/usr\/local\/pgsql12.2\r\n<\/code><\/pre>\n<h2>\u521b\u5efa\u7b26\u53f7\u94fe\u63a5<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nb\">ln<\/span> <span class=\"nt\">-s<\/span> \/usr\/local\/pgsql12.2 \/usr\/local\/pgsql\r\n<\/code><\/pre>\n<p>\u89e3\u9664\u65b9\u6cd5\u5728\u8fd9\u91cc\u3002<br \/>\n\u89e3\u9664\u65b9\u6cd5\u8bf7\u53c2\u8003\u8fd9\u91cc\u3002<br \/>\n\u8bf7\u70b9\u51fb\u8fd9\u91cc\u67e5\u770b\u89e3\u9664\u65b9\u6cd5\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nb\">unlink<\/span> \/usr\/local\/pgsql\r\n<\/code><\/pre>\n<h2>\u5207\u6362\u7528\u6237\u5e76\u79fb\u52a8\u76ee\u5f55\u3002<\/h2>\n<pre class=\"post-pre\"><code>su - postgres\r\n<span class=\"nb\">cd<\/span> \/usr\/local\/src\/postgresql-12.2\r\n<\/code><\/pre>\n<h2>\u521b\u5efaMakefile<\/h2>\n<p>\u6211\u6b63\u5728\u6307\u5b9a\u5b89\u88c5\u8def\u5f84\u3002<\/p>\n<pre class=\"post-pre\"><code>.\/configure <span class=\"nt\">--prefix<\/span><span class=\"o\">=<\/span>\/usr\/local\/pgsql\r\n<\/code><\/pre>\n<h2>\u7f16\u8bd1\u548c\u5b89\u88c5<\/h2>\n<pre class=\"post-pre\"><code>make\r\nmake <span class=\"nb\">install<\/span>\r\n<\/code><\/pre>\n<h2>\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf<\/h2>\n<pre class=\"post-pre\"><code>vi ~\/.bash_profile\r\n<\/code><\/pre>\n<p>\u5c06\u4ee5\u4e0b\u5185\u5bb9\u5199\u5728\u5e95\u90e8\u5e76\u4fdd\u5b58\u3002<\/p>\n<pre class=\"post-pre\"><code>export PATH=\"$PATH\":\/usr\/local\/pgsql\/bin \r\nexport POSTGRES_HOME=\/usr\/local\/pgsql \r\nexport PGLIB=$POSTGRES_HOME\/lib \r\nexport PGDATA=$POSTGRES_HOME\/data \r\nexport MANPATH=\"$MANPATH\":$POSTGRES_HOME\/man \r\nexport LD_LIBRARY_PATH=\"$LD_LIBRARY_PATH\":\"$PGLIB\"\r\n<\/code><\/pre>\n<h2>\u73af\u5883\u53d8\u91cf\u7684\u5e94\u7528<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nb\">.<\/span> ~\/.bash_profile\r\n<\/code><\/pre>\n<h2>\u5c06\u6570\u636e\u5e93\u8fdb\u884c\u521d\u59cb\u5316<\/h2>\n<pre class=\"post-pre\"><code>initdb <span class=\"nt\">--no-locale<\/span>\r\n<\/code><\/pre>\n<h2>\u7f16\u8f91\u8bbe\u7f6e\u6587\u4ef6<\/h2>\n<h3>postgresql.conf \u662f PostgreSQL \u6570\u636e\u5e93\u7684\u914d\u7f6e\u6587\u4ef6\u3002<\/h3>\n<pre class=\"post-pre\"><code>vi \/usr\/local\/pgsql\/data\/postgresql.conf\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>\u30ea\u30e2\u30fc\u30c8\u30a2\u30af\u30bb\u30b9\u53ef\u80fd\u306b\u3059\u308b\u3002\r\n#listen_addresses = 'localhost'\r\n\u2193\r\nlisten_addresses = '*'\r\n\r\n\u660e\u793a\u7684\u306b\u30dd\u30fc\u30c8\u3092\u6307\u5b9a\u3059\u308b\u3002\r\n#port = 5432\r\n\u2193\r\nport = 5432\r\n\r\n\u30ed\u30b0\u3092\u6709\u52b9\u306b\u3059\u308b\u3002\r\n#logging_collector = off\r\n\u2193\r\nlogging_collector = on\r\n\r\n\u30ed\u30b0\u306e\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u5909\u66f4\u3059\u308b\u3002\r\n#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'\r\n\u2193\r\nlog_filename = 'postgresql-%d.log'\r\n\r\n#log_line_prefix = ''\r\n\u2193\r\nlog_line_prefix = '%t [%p] '\r\n<\/code><\/pre>\n<h3>pg_hba.conf\u53ef\u4ee5\u8fdb\u884c\u91cd\u5199\u4e3a\uff1a\u6c47\u7f16.hba\u914d\u7f6e\u6587\u4ef6\u3002<\/h3>\n<pre class=\"post-pre\"><code>vi \/usr\/local\/pgsql\/data\/pg_hba.conf\r\n<\/code><\/pre>\n<p>\u8bf7\u6307\u5b9alisten_addresses\u7684\u8303\u56f4\u3002<br \/>\n\u4ee5\u4e0b\u662f\u4e00\u4e2a\u793a\u4f8b\uff0c\u8bf7\u6839\u636e\u60a8\u7684\u73af\u5883\u8fdb\u884c\u76f8\u5e94\u8c03\u6574\u3002<\/p>\n<pre class=\"post-pre\"><code>host    all             all             127.0.0.1\/32            trust\r\n\u2193\r\nhost    all             all             192.168.1.0\/24          trust\r\n<\/code><\/pre>\n<h2>\u542f\u52a8<\/h2>\n<pre class=\"post-pre\"><code>pg_ctl start <span class=\"nt\">-w<\/span>\r\n<\/code><\/pre>\n<h2>\u521b\u5efaDB\u7ba1\u7406\u7528\u6237<\/h2>\n<pre class=\"post-pre\"><code>createuser <span class=\"nt\">-s<\/span> <span class=\"nt\">-d<\/span> <span class=\"nt\">-r<\/span> <span class=\"nt\">-P<\/span> pgsa\r\n<\/code><\/pre>\n<h2>\u786e\u8ba4\u521b\u5efa\u7684\u7528\u6237<\/h2>\n<pre class=\"post-pre\"><code>psql <span class=\"nt\">-U<\/span> postgres\r\n<span class=\"se\">\\d<\/span>u\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>[postgres@localhost postgresql-12.2]$ psql -U postgres\r\npsql (12.2)\r\nType \"help\" for help.\r\n\r\npostgres=# \\du\r\n                                   List of roles\r\n Role name |                         Attributes                         | Member of\r\n-----------+------------------------------------------------------------+-----------\r\n pgsa      | Superuser, Create role, Create DB                          | {}\r\n postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}\r\n<\/code><\/pre>\n<p>\u7528&#8221;\u7ed3\u675f&#8221;\u6765\u8868\u793a\u7ed3\u675f<\/p>\n<h1>\u9632\u706b\u5899\u7684\u8bbe\u7f6e<\/h1>\n<p>\u8bf7\u4ee5 root \u6743\u9650\u8fdb\u884c\u8bbe\u7f6e\u3002<\/p>\n<pre class=\"post-pre\"><code>su -\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>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\nsystemctl restart firewalld\r\n<\/code><\/pre>\n<h1>SELinux\u7684\u914d\u7f6e<\/h1>\n<pre class=\"post-pre\"><code>setsebool <span class=\"nt\">-P<\/span> postgresql_can_rsync on\r\nsetsebool <span class=\"nt\">-P<\/span> postgresql_selinux_transmit_client_label on\r\nsetsebool <span class=\"nt\">-P<\/span> selinuxuser_postgresql_connect_enabled on\r\n<\/code><\/pre>\n<p>\u786e\u8ba4<\/p>\n<pre class=\"post-pre\"><code>getsebool <span class=\"nt\">-a<\/span> | <span class=\"nb\">grep <\/span>postgresql\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>postgresql_can_rsync <span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> on\r\npostgresql_selinux_transmit_client_label <span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> on\r\npostgresql_selinux_unconfined_dbadm <span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> on\r\npostgresql_selinux_users_ddl <span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> on\r\nselinuxuser_postgresql_connect_enabled <span class=\"nt\">--<\/span><span class=\"o\">&gt;<\/span> on\r\n<\/code><\/pre>\n<h1>\u81ea\u52a8\u542f\u52a8\u8bbe\u7f6e<\/h1>\n<p>\u521b\u5efa\u670d\u52a1\u5b9a\u4e49\u6587\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code>vi \/usr\/lib\/systemd\/system\/postgresql.service\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code># It's not recommended to modify this file in-place, because it will be\r\n# overwritten during package upgrades.  If you want to customize, the\r\n# best way is to create a file \"\/etc\/systemd\/system\/postgresql.service\",\r\n# containing\r\n#   .include \/lib\/systemd\/system\/postgresql.service\r\n#   ...make your changes here...\r\n# For more info about custom unit files, see\r\n# http:\/\/fedoraproject.org\/wiki\/Systemd#How_do_I_customize_a_unit_file.2F_add_a_custom_unit_file.3F\r\n\r\n# For example, if you want to change the server's port number to 5433,\r\n# create a file named \"\/etc\/systemd\/system\/postgresql.service\" containing:\r\n#   .include \/lib\/systemd\/system\/postgresql.service\r\n#   [Service]\r\n#   Environment=PGPORT=5433\r\n# This will override the setting appearing below.\r\n\r\n# Note: changing PGPORT or PGDATA will typically require adjusting SELinux\r\n# configuration as well; see \/usr\/share\/doc\/postgresql-*\/README.rpm-dist.\r\n\r\n# Note: do not use a PGDATA pathname containing spaces, or you will\r\n# break postgresql-setup.\r\n\r\n# Note: in F-17 and beyond, \/usr\/lib\/... is recommended in the .include line\r\n# though \/lib\/... will still work.\r\n\r\n[Unit]\r\nDescription=PostgreSQL database server\r\nAfter=network.target\r\n\r\n[Service]\r\nType=forking\r\n\r\nUser=postgres\r\nGroup=postgres\r\n\r\n# Port number for server to listen on\r\nEnvironment=PGPORT=5432\r\n\r\n# Location of database directory\r\nEnvironment=PGDATA=\/usr\/local\/pgsql\/data\r\n\r\n# Where to send early-startup messages from the server (before the logging\r\n# options of postgresql.conf take effect)\r\n# This is normally controlled by the global default set by systemd\r\n# StandardOutput=syslog\r\n\r\n# Disable OOM kill on the postmaster\r\nOOMScoreAdjust=-1000\r\n\r\n#ExecStartPre=\/usr\/local\/pgsql\/bin\/postgresql-check-db-dir ${PGDATA} &lt;=\u3053\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u306f\u5b58\u5728\u3057\u306a\u3044\u306e\u3067\u30b3\u30e1\u30f3\u30c8\r\nExecStart=\/usr\/local\/pgsql\/bin\/pg_ctl start -D ${PGDATA} -s -o \"-p ${PGPORT}\" -w -t 300\r\nExecStop=\/usr\/local\/pgsql\/bin\/pg_ctl stop -D ${PGDATA} -s -m fast\r\nExecReload=\/usr\/local\/pgsql\/bin\/pg_ctl reload -D ${PGDATA} -s\r\n\r\n# Give a reasonable amount of time for the server to start up\/shut down\r\nTimeoutSec=300\r\n\r\n[Install]\r\nWantedBy=multi-user.target\r\n<\/code><\/pre>\n<h2>\u81ea\u52a8\u542f\u52a8\u6267\u884c<\/h2>\n<pre class=\"post-pre\"><code>systemctl daemon-reload\r\nsystemctl <span class=\"nb\">enable <\/span>postgresql\r\n<\/code><\/pre>\n<h1>\u786e\u8ba4\u884c\u52a8<\/h1>\n<pre class=\"post-pre\"><code>systemctl status postgresql\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>\u25cf postgresql.service - PostgreSQL database server\r\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql.service; enabled; vendor preset: disabled)\r\n   Active: active (running) since Sat 2020-05-09 07:45:17 EDT; 28s ago\r\n  Process: 1103 ExecStart=\/usr\/local\/pgsql\/bin\/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, sta&gt;\r\n Main PID: 1144 (postgres)\r\n    Tasks: 8 (limit: 23922)\r\n   Memory: 19.9M\r\n   CGroup: \/system.slice\/postgresql.service\r\n           \u251c\u25001144 \/usr\/local\/pgsql12.2\/bin\/postgres -D \/usr\/local\/pgsql\/data -p 5432\r\n           \u251c\u25001422 postgres: logger\r\n           \u251c\u25001483 postgres: checkpointer\r\n           \u251c\u25001484 postgres: background writer\r\n           \u251c\u25001485 postgres: walwriter\r\n           \u251c\u25001486 postgres: autovacuum launcher\r\n           \u251c\u25001487 postgres: stats collector\r\n           \u2514\u25001488 postgres: logical replication launcher\r\n<\/code><\/pre>\n<h1>\u5c55\u793a\/\u5c55\u89c8<\/h1>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148 \u5728\u901a\u8fc7&#8221;\u6700\u4f4e\u9650\u7684\u5b89\u88c5&#8221;\u65b9\u5f0f\u5b89\u88c5\u7684CentOS-8.1.1911-x86_64\u73af\u5883 [&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-41835","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>\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8 - 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\/\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684-postgresql-12-x-\u5230-cent-os-8\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u5728\u901a\u8fc7&#8221;\u6700\u4f4e\u9650\u7684\u5b89\u88c5&#8221;\u65b9\u5f0f\u5b89\u88c5\u7684CentOS-8.1.1911-x86_64\u73af\u5883 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684-postgresql-12-x-\u5230-cent-os-8\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T17:59:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T04:05:08+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\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/\",\"name\":\"\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-07-28T17:59:40+00:00\",\"dateModified\":\"2024-04-30T04:05:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8\"}]},{\"@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\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8 - 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\/\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684-postgresql-12-x-\u5230-cent-os-8\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8","og_description":"\u9996\u5148 \u5728\u901a\u8fc7&#8221;\u6700\u4f4e\u9650\u7684\u5b89\u88c5&#8221;\u65b9\u5f0f\u5b89\u88c5\u7684CentOS-8.1.1911-x86_64\u73af\u5883 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684-postgresql-12-x-\u5230-cent-os-8\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-07-28T17:59:40+00:00","article_modified_time":"2024-04-30T04:05:08+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\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/","name":"\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-07-28T17:59:40+00:00","dateModified":"2024-04-30T04:05:08+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4ece\u6e90\u4ee3\u7801\u4e2d\u5b89\u88c5\u6700\u65b0\u7248\u672c\u7684 PostgreSQL 12.x \u5230 Cent OS 8"}]},{"@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\/%e4%bb%8e%e6%ba%90%e4%bb%a3%e7%a0%81%e4%b8%ad%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88%e6%9c%ac%e7%9a%84-postgresql-12-x-%e5%88%b0-cent-os-8%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\/41835","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=41835"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41835\/revisions"}],"predecessor-version":[{"id":91807,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41835\/revisions\/91807"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}