{"id":365,"date":"2018-12-02T19:31:01","date_gmt":"2018-12-02T11:31:01","guid":{"rendered":"https:\/\/blog.yunvisit.com\/?p=365"},"modified":"2018-12-15T13:01:43","modified_gmt":"2018-12-15T05:01:43","slug":"centos-%e5%ae%89%e8%a3%85-postgresql11","status":"publish","type":"post","link":"https:\/\/blog.yunvisit.com\/?p=365","title":{"rendered":"CentOS \u5b89\u88c5 PostgreSQL11"},"content":{"rendered":"<h2>\u4e00\u3001\u5b89\u88c5<\/h2>\n<p>\u4e0b\u8f7d\u9875\u9762:<a href=\"https:\/\/www.postgresql.org\/download\/linux\/redhat\/\" target=\"_blank\"  rel=\"nofollow\" >https:\/\/www.postgresql.org\/download\/linux\/redhat\/<\/a><br \/>\n\u9009\u62e9\u6240\u9700\u7248\u672c\uff0c\u5b89\u88c5\u547d\u4ee4\u5df2\u7ecf\u81ea\u52a8\u751f\u6210\u76f4\u63a5\u7167\u7740\u590d\u5236\u7c98\u8d34\u5373\u53ef<\/p>\n<p><img loading=\"lazy\" class=\"alignnone wp-image-366\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL01-300x169.png\" alt=\"\" width=\"827\" height=\"466\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL01-300x169.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL01-768x432.png 768w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL01-1024x576.png 1024w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL01.png 1574w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nyum install https:\/\/download.postgresql.org\/pub\/repos\/yum\/11\/redhat\/rhel-7-x86_64\/pgdg-centos11-11-2.noarch.rpm\r\nyum install postgresql11\r\nyum install postgresql11-server\r\n\/usr\/pgsql-11\/bin\/postgresql-11-setup initdb<\/textarea><\/pre>\n<\/div>\n<p>\u5230\u8fd9\u91cc\u5982\u56fe\u6240\u793a\u5c31\u662f\u5b89\u88c5\u6210\u529f\u7684<br \/>\n<img loading=\"lazy\" class=\"alignnone wp-image-367\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL02-300x189.png\" alt=\"\" width=\"546\" height=\"344\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL02-300x189.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL02.png 675w\" sizes=\"(max-width: 546px) 100vw, 546px\" \/><\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nsystemctl enable postgresql-11 #\u8bbe\u7f6e\u5f00\u673a\u542f\u52a8\r\nsystemctl start postgresql-11 #\u542f\u52a8\u670d\u52a1<\/textarea><\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n<h2>\u4e8c\u3001 \u521d\u59cb\u5316\u6570\u636e\u5e93<\/h2>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nsu - postgres\r\npsql -U postgres\r\nALTER USER postgres with encrypted password 'yourpassword';\r\n\\q #\u9000\u51fa\u6570\u636e\u5e93\u547d\u4ee4\u884c\r\nexit #\u9000\u51fabash<\/textarea><\/pre>\n<\/div>\n<p><img loading=\"lazy\" class=\"alignnone wp-image-368\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL03-300x93.png\" alt=\"\" width=\"603\" height=\"187\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL03-300x93.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL03.png 637w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/p>\n<p>\u4ee5\u4e0a\u5c31\u662f\u5b89\u88c5\u914d\u7f6e\u7684\u5168\u8fc7\u7a0b\uff0c\u5982\u9700<span style=\"color: #ff0000;\">\u5f00\u542f\u5916\u7f51\u8bbf\u95ee<\/span>\u9700\u8981\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u548c\u9632\u706b\u5899\u653e\u884c<\/p>\n<p>\u2460\u9632\u706b\u5899\u653e\u884c\u7aef\u53e3<br \/>\nfirewall\uff1a<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nfirewall-cmd --zone=public --add-port=5432\/tcp --permanent\r\nfirewall-cmd --reload\r\nfirewall-cmd --list-ports<\/textarea><\/pre>\n<\/div>\n<p>iptables:<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\niptables -A INPUT -p tcp --dport 5432 -j ACCEPT\r\nservice iptables save\r\nservice iptables reload<\/textarea><\/pre>\n<\/div>\n<p>\u2461\u914d\u7f6e\u6587\u4ef6\u4fee\u6539<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nvi \/var\/lib\/pgsql\/11\/data\/postgresql.conf<\/textarea><\/pre>\n<\/div>\n<p>\u5c06<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nlisten_addresses = 'localhost'<\/textarea><\/pre>\n<\/div>\n<p>\u6539\u6210<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nlisten_addresses = '*'<\/textarea><\/pre>\n<\/div>\n<p>\u524d\u9762\u7684 # \u52a1\u5fc5\u53bb\u6389<\/p>\n<p><img loading=\"lazy\" class=\"alignnone wp-image-369\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL04-300x138.png\" alt=\"\" width=\"556\" height=\"256\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL04-300x138.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL04-768x354.png 768w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL04.png 845w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/p>\n<p>\u901a\u8baf\u8bbe\u7f6e<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nvi \/var\/lib\/pgsql\/11\/data\/pg_hba.conf<\/textarea><\/pre>\n<\/div>\n<p>\u62c9\u5230\u6700\u4e0b\u9762\uff0c\u6539\u6210\u8fd9\u6837\u5b50<\/p>\n<p><img loading=\"lazy\" class=\"alignnone wp-image-370\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL05-300x189.png\" alt=\"\" width=\"713\" height=\"450\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL05-300x189.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL05.png 658w\" sizes=\"(max-width: 713px) 100vw, 713px\" \/><\/p>\n<p>\u7136\u540e\u91cd\u542fpostgreSQL<\/p>\n<div class=\"my-syntax-highlighter\">\n<pre><textarea id=\"mshighlighter\" class=\"mshighlighter\" language=\"shell\" name=\"mshighlighter\" >\r\nsystemctl restart postgresql-11<\/textarea><\/pre>\n<\/div>\n<p>\u2462\u5916\u7f51\u9a8c\u8bc1<br \/>\n\u5982\u679c\u662f\u4e91\u670d\u52a1\u5668\u6ce8\u610f<span style=\"color: #ff0000;\">\u5b89\u5168\u7ec4<\/span>\u4e00\u7c7b\u7684\u8bbe\u7f6e\u8fdb\u884c5432\u7aef\u53e3TCP\u534f\u8bae\u653e\u884c\uff01<\/p>\n<p><img loading=\"lazy\" class=\"alignnone wp-image-371\" src=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL06-300x162.png\" alt=\"\" width=\"694\" height=\"375\" srcset=\"https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL06-300x162.png 300w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL06-768x415.png 768w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL06-1024x553.png 1024w, https:\/\/blog.yunvisit.com\/wp-content\/uploads\/2018\/12\/PostgreSQL06.png 1344w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u5b89\u88c5 \u4e0b\u8f7d\u9875\u9762:https:\/\/www.postgresql.org\/download\/linux\/redhat\/ \u9009\u62e9\u6240\u9700\u7248 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":372,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[44,45],"_links":{"self":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts\/365"}],"collection":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=365"}],"version-history":[{"count":0,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/posts\/365\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=\/wp\/v2\/media\/372"}],"wp:attachment":[{"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.yunvisit.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}