{"id":41926,"date":"2023-06-24T10:37:40","date_gmt":"2023-09-04T18:30:50","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/"},"modified":"2024-04-30T10:28:59","modified_gmt":"2024-04-30T02:28:59","slug":"%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/","title":{"rendered":"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL"},"content":{"rendered":"<h1>\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL<\/h1>\n<h2>\u7ae0\u7bc0\u76ee\u9304<\/h2>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u524d\u63d0\u6761\u4ef6<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>1. \u5b89\u88c5\u548c\u521d\u59cb\u8bbe\u7f6e<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>2. \u53d6\u6d88peer\u8ba4\u8bc1<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>3. \u4f7f\u7528psql\u8fdb\u884c\u8fde\u63a5<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>4. \u901a\u8fc7SSH\u7aef\u53e3\u8f6c\u53d1\u4ece\u5176\u4ed6\u8bbe\u5907\u8fde\u63a5<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>5. \u6253\u5f00\u9632\u706b\u5899\u4ee5\u4ece\u5176\u4ed6\u8bbe\u5907\u8fde\u63a5<\/ol>\n<h2>\u524d\u63d0 (Qian ti)<\/h2>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u4ee5\u4e0b\u306f\u3001VirtualBox\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305fCentOS7\u306e\u74b0\u5883\u3067\u78ba\u8a8d\u3057\u305f\u3082\u306e\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>\u5177\u4f53\u7684\u306b\u306f\u3001\u3053\u306e\u624b\u9806\u3067\u4f5c\u6210\u3057\u305f\u74b0\u5883\u4e0b\u3067\u884c\u3063\u305f\u3002<\/p>\n<h2>\u5b89\u88c5\u548c\u521d\u59cb\u8bbe\u7f6e<\/h2>\n<p>\u30b3\u30de\u30f3\u30c9\u306e\u53d6\u5f97<\/p>\n<p>\u516c\u5f0f\u306edownload\u30da\u30fc\u30b8\u306b\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148\u60c5\u5831\u3092\u5165\u529b\u3059\u308b\u3068\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30b3\u30de\u30f3\u30c9\u304c\u53d6\u5f97\u3067\u304d\u308b\u3002<\/p>\n<p>\u8a2d\u5b9a\u3057\u305f\u9805\u76ee\u306f\u4ee5\u4e0b<\/p>\n<p>Select Version: 9.6<br \/>\nSelect platform: CentOS 7<br \/>\nSelect architecture: x86_64<\/p>\n<p>\u53d6\u5f97\u3057\u305f\u30b3\u30de\u30f3\u30c9<\/p>\n<p># Install the repository RPM:<br \/>\nyum install https:\/\/download.postgresql.org\/pub\/repos\/yum\/9.6\/redhat\/rhel-7-x86_64\/pgdg-centos96-9.6-3.noarch.rpm<\/p>\n<p># Install the client packages:<br \/>\nyum install postgresql96<\/p>\n<p># Optionally install the server packages:<br \/>\nyum install postgresql96-server<\/p>\n<p># Optionally initialize the database and enable automatic start:<br \/>\n\/usr\/pgsql-9.6\/bin\/postgresql96-setup initdb<br \/>\nsystemctl enable postgresql-9.6<br \/>\nsystemctl start postgresql-9.6<\/p>\n<p>\u30b3\u30de\u30f3\u30c9\u306e\u5b9f\u884c<\/p>\n<p>\u4e0a\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u9806\u306b\u5b9f\u884c\u3059\u308b(\u9014\u4e2d\u3001\u306a\u306b\u304b\u805e\u304b\u308c\u305f\u3089Y\u3068\u7b54\u3048\u308b)<\/p>\n<p>postgresql-9.6 \u30b5\u30fc\u30d3\u30b9\u304c\u8d77\u52d5\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code>   # systemctl status postgresql-9.6\r\n   Active: active (running)\r\n<\/code><\/pre>\n<h2>\u89e3\u9664\u5bf9\u7b49\u8ba4\u8bc1<\/h2>\n<p>\u6982\u8981<\/p>\n<p>\u6700\u521d\u306fpeer\u8a8d\u8a3c\u306b\u306a\u3063\u3066\u3044\u308b\u3002<br \/>\nCentOS\u4e0a\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u7d44\u307f\u5408\u308f\u305b\u304c\u3001PostgreSQL\u4e0a\u306e\u30e6\u30fc\u30b6\u30fc\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u306a\u3044\u3068PostgreSQL\u306b\u63a5\u7d9a\u3067\u304d\u306a\u3044\u3002<br \/>\n\u4f7f\u3044\u3065\u3089\u3044\u306e\u3067\u3001\u666e\u901a\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u3059\u308c\u3070\u63a5\u7d9a\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n<p>\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u7de8\u96c6<\/p>\n<p>pg_hba.conf\u3092\u7de8\u96c6\u3059\u308b\u3002<br \/>\n\u30d5\u30a1\u30a4\u30eb\u306e\u5834\u6240\u3084\u8aac\u660e\u306f\u516c\u5f0f\u3092\u53c2\u7167\u3002<br \/>\nlocal\u63a5\u7d9a\u306epeer\u8a8d\u8a3c\u3092md5\u306b\u5909\u66f4\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code>   vi \/var\/lib\/pgsql\/9.6\/data\/pg_hba.conf\r\n\r\n   # \"local\" is for Unix domain socket connections only\r\n   local   all             all                                     peer\r\n   \u2193\r\n   # \"local\" is for Unix domain socket connections only\r\n   local   all             all                                     md5\r\n<\/code><\/pre>\n<p>postgres\u30e6\u30fc\u30b6\u30fc\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a<\/p>\n<p>\u5909\u66f4\u3092\u53cd\u6620\u3059\u308b\u524d\u306b\u3001postgres\u30e6\u30fc\u30b6\u30fc\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\u3002<br \/>\npostgres\u30e6\u30fc\u30b6\u30fc\u3067psql\u306b\u63a5\u7d9a\u3002<\/p>\n<p># su &#8211; postgres<br \/>\n$ psql -U postgres<\/p>\n<p>psql\u306b\u5165\u3063\u305f\u3089\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u5909\u66f4<\/p>\n<p>postgres=# \\password<br \/>\nEnter new password:<br \/>\nEnter it again:<br \/>\npostgres=# \\q<\/p>\n<p>$ exit<\/p>\n<p>\u30b5\u30fc\u30d3\u30b9\u3092\u518d\u8d77\u52d5\u3057\u3066\u3001pg_hba.conf\u306e\u8a2d\u5b9a\u3092\u53cd\u6620\u3055\u305b\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code>   # systemctl restart postgresql-9.6\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u30d1\u30b9\u30ef\u30fc\u30c9\u8a8d\u8a3c\u3067\u63a5\u7d9a\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b<\/ul>\n<pre class=\"post-pre\"><code>   # psql -U postgres\r\n   Password for user postgres:\r\n<\/code><\/pre>\n<h2>\u4f7f\u7528SSH\u7aef\u53e3\u8f6c\u53d1\u8fde\u63a5\u5230\u4ed6\u7684\u673a\u5668\u3002<\/h2>\n<ul class=\"post-ul\">listen\u3059\u308b\u30db\u30b9\u30c8\u306e\u8a2d\u5b9a<\/ul>\n<pre class=\"post-pre\"><code>   vi \/var\/lib\/pgsql\/9.6\/data\/postgresql.conf\r\n\r\n   <span class=\"c\"># listen_addresses = 'localhost'     # what IP address(es) to listen on;<\/span>\r\n   <span class=\"c\"># port = 5432                        # (change requires restart)<\/span>\r\n   \u2193\r\n   listen_addresses <span class=\"o\">=<\/span> <span class=\"s1\">'*'<\/span>     <span class=\"c\"># what IP address(es) to listen on;<\/span>\r\n   port <span class=\"o\">=<\/span> 5432                        <span class=\"c\"># (change requires restart)<\/span>\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u63a5\u7d9a\u3092\u8a31\u53ef\u3059\u308b\u30db\u30b9\u30c8\u306e\u8a2d\u5b9a<\/ul>\n<pre class=\"post-pre\"><code>   vi \/var\/lib\/pgsql\/9.6\/data\/postgresql.conf\r\n\r\n   <span class=\"c\"># TYPE  DATABASE        USER            ADDRESS                 METHOD<\/span>\r\n   <span class=\"c\"># IPv4 local connections:<\/span>\r\n   host    all             all             127.0.0.1\/32            ident\r\n   \u2193\r\n   <span class=\"c\"># IPv4 local connections:<\/span>\r\n   host    all             all             0.0.0.0\/0               md5\r\n<\/code><\/pre>\n<p>ssh\u30dd\u30fc\u30c8\u30d5\u30a9\u30ef\u30fc\u30c7\u30a3\u30f3\u30b0\u3092\u5229\u7528\u3057\u3066\u5225\u306e\u30de\u30b7\u30f3\u304b\u3089\u63a5\u7d9a<\/p>\n<p>\u30dd\u30fc\u30c8\u30d5\u30a9\u30ef\u30fc\u30c7\u30a3\u30f3\u30b0<\/p>\n<p>OpenSSH\u304c\u4f7f\u7528\u3067\u304d\u308b\u524d\u63d0<\/p>\n<p>ssh -N -L 15432:192.168.56.99:5432 root@192.168.56.99<\/p>\n<p>\u30dd\u30fc\u30c8\u30d5\u30a9\u30ef\u30fc\u30c7\u30a3\u30f3\u30b0\u3057\u305f\u30de\u30b7\u30f3\u304b\u3089\u63a5\u7d9a<\/p>\n<p>psql -U postgres -h localhost -p 15432<\/p>\n<h2>\u4ed6\u4ece\u673a\u5668\u8fde\u63a5 (\u6253\u5f00\u9632\u706b\u5899\u7684\u6d1e)<\/h2>\n<ul class=\"post-ul\">public\u30be\u30fc\u30f3\u306b\u6c38\u4e45\u7684\u306b\u767b\u9332\u3057\u3066\u3044\u308b\u30b5\u30fc\u30d3\u30b9\u306e\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code>   # firewall-cmd --zone=public --list-services --permanent\r\n   ssh dhcpv6-client\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u306b\u767b\u9332\u3067\u304d\u308b\u30b5\u30fc\u30d3\u30b9\u306e\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code>   # firewall-cmd --get-services\r\n\r\n   pop3 pop3s postgresql privoxy\r\n<\/code><\/pre>\n<ul class=\"post-ul\">PostgreSQL\u3092\u8ffd\u52a0<\/ul>\n<pre class=\"post-pre\"><code>   # firewall-cmd --add-service=postgresql --zone=public --permanent\r\n   success\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u30b5\u30fc\u30d3\u30b9\u304c\u767b\u9332\u3055\u308c\u305f\u3053\u3068\u3092\u78ba\u8a8d<\/ul>\n<pre class=\"post-pre\"><code>   # firewall-cmd --zone=public --list-services --permanent\r\n   ssh dhcpv6-client postgresql\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u3092\u518d\u8d77\u52d5<\/ul>\n<pre class=\"post-pre\"><code>   # systemctl restart firewalld\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u4ed6\u30de\u30b7\u30f3\u304b\u3089psql\u3067\u63a5\u7d9a\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\u3002<\/ul>\n<pre class=\"post-pre\"><code>   <span class=\"n\">psql<\/span> <span class=\"nt\">-U<\/span> <span class=\"nx\">postgres<\/span> <span class=\"nt\">-h<\/span> <span class=\"nx\">192.168.56.99<\/span> <span class=\"nt\">-p<\/span> <span class=\"nx\">5432<\/span>\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\u30dd\u30fc\u30c8\u3092\u5909\u66f4\u3057\u305f\u3044\u3068\u304d\u306f\/usr\/lib\/firewalld\/services\/postgresql.xml\u3092\u7de8\u96c6\u3057\u3066\u3001\u5225\u306e\u5834\u6240\u306b\u7f6e\u304f\u3002<\/ul>\n<pre class=\"post-pre\"><code>   cp \/usr\/lib\/firewalld\/services\/postgresql.xml \/etc\/firewalld\/services\/postgresql.xml\r\n   vi \/etc\/firewalld\/services\/postgresql.xml\r\n\r\n   &lt;?xml version=\"1.0\" encoding=\"utf-8\"?&gt;\r\n   &lt;service&gt;\r\n   &lt;short&gt;PostgreSQL&lt;\/short&gt;\r\n   &lt;description&gt;PostgreSQL Database Server&lt;\/description&gt;\r\n   &lt;port protocol=\"tcp\" port=\"5432\"\/&gt;\r\n   &lt;\/service&gt;\r\n   \u2193\r\n   &lt;?xml version=\"1.0\" encoding=\"utf-8\"?&gt;\r\n   &lt;service&gt;\r\n   &lt;short&gt;PostgreSQL&lt;\/short&gt;\r\n   &lt;description&gt;PostgreSQL Database Server&lt;\/description&gt;\r\n   &lt;port protocol=\"tcp\" port=\"&lt;\u5909\u66f4\u5f8c\u306e\u30dd\u30fc\u30c8\u756a\u53f7&gt;\"\/&gt;\r\n   &lt;\/service&gt;\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL \u7ae0\u7bc0\u76ee\u9304 \u524d\u63d0\u6761\u4ef6 &nbsp; 1. \u5b89\u88c5\u548c\u521d\u59cb\u8bbe\u7f6e &#038;nb [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41926","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>\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL - 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\u4e0a\u5b89\u88c5\u548c\u914d\u7f6epostgresql\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL\" \/>\n<meta property=\"og:description\" content=\"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL \u7ae0\u7bc0\u76ee\u9304 \u524d\u63d0\u6761\u4ef6 &nbsp; 1. \u5b89\u88c5\u548c\u521d\u59cb\u8bbe\u7f6e &amp;nb [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728centos\u4e0a\u5b89\u88c5\u548c\u914d\u7f6epostgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-04T18:30:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T02:28:59+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u5b87\" \/>\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, \u5b87\" \/>\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\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/\",\"name\":\"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-09-04T18:30:50+00:00\",\"dateModified\":\"2024-04-30T02:28:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL\"}]},{\"@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\/1a6ecd3d914d22a5ac32791ffc1fbd8e\",\"name\":\"\u6e05, \u5b87\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u5b87\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL - 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\u4e0a\u5b89\u88c5\u548c\u914d\u7f6epostgresql\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL","og_description":"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL \u7ae0\u7bc0\u76ee\u9304 \u524d\u63d0\u6761\u4ef6 &nbsp; 1. \u5b89\u88c5\u548c\u521d\u59cb\u8bbe\u7f6e &nb [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728centos\u4e0a\u5b89\u88c5\u548c\u914d\u7f6epostgresql\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-09-04T18:30:50+00:00","article_modified_time":"2024-04-30T02:28:59+00:00","author":"\u6e05, \u5b87","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u5b87","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/","name":"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-09-04T18:30:50+00:00","dateModified":"2024-04-30T02:28:59+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5728CentOS\u4e0a\u5b89\u88c5\u548c\u914d\u7f6ePostgreSQL"}]},{"@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\/1a6ecd3d914d22a5ac32791ffc1fbd8e","name":"\u6e05, \u5b87","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","caption":"\u6e05, \u5b87"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8centos%e4%b8%8a%e5%ae%89%e8%a3%85%e5%92%8c%e9%85%8d%e7%bd%aepostgresql\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41926","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41926"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41926\/revisions"}],"predecessor-version":[{"id":91363,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41926\/revisions\/91363"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}