{"id":87,"date":"2023-09-18T12:34:10","date_gmt":"2023-09-18T04:34:10","guid":{"rendered":"http:\/\/blog.yiyilearning.com\/?p=87"},"modified":"2023-09-18T15:48:12","modified_gmt":"2023-09-18T07:48:12","slug":"postgresql%e8%ae%be%e7%bd%ae%e8%bf%9c%e7%a8%8b%e8%ae%bf%e9%97%ae","status":"publish","type":"post","link":"https:\/\/airlive.online\/index.php\/2023\/09\/18\/postgresql%e8%ae%be%e7%bd%ae%e8%bf%9c%e7%a8%8b%e8%ae%bf%e9%97%ae\/","title":{"rendered":"postgreSQL\u8bbe\u7f6e\u8fdc\u7a0b\u8bbf\u95ee"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code><strong>listen_addresses = '*'  \n# IPv4 local connections:\n#host all all 127.0.0.1\/32 trust\n\nhost all all 0.0.0.0\/0 md5<\/strong><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Last login: Thu Sep 14 21:49:43 2023 from 127.0.0.1<br>[root@ecm-24d4 ~]# find \/ -name &#8220;postgresql.conf&#8221;<br>\/www\/server\/pgsql\/data\/postgresql.conf<br>[root@ecm-24d4 ~]# vim \/www\/server\/pgsql\/data\/postgresql.conf<br>listen_addresses = &#8216;*&#8217;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"790\" height=\"547\" src=\"\/wp-content\/uploads\/2023\/09\/image-8.png\" alt=\"\" class=\"wp-image-244\" srcset=\"\/wp-content\/uploads\/2023\/09\/image-8.png 790w, \/wp-content\/uploads\/2023\/09\/image-8-300x208.png 300w, \/wp-content\/uploads\/2023\/09\/image-8-768x532.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"446\" src=\"\/wp-content\/uploads\/2023\/09\/image-9.png\" alt=\"\" class=\"wp-image-245\" srcset=\"\/wp-content\/uploads\/2023\/09\/image-9.png 652w, \/wp-content\/uploads\/2023\/09\/image-9-300x205.png 300w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Last login: Thu Sep 14 21:49:43 2023 from 127.0.0.1[root@ecm-24d4 ~]# find \/ -name &#8220;postgresql.conf&#8221;\/www\/server\/pgsql\/data\/postgresql.conf[root@ecm-24d4 ~]# vim \/www\/server\/pgsql\/data\/postgresql.conflisten_addresses = &#8216;*&#8217;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-87","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/posts\/87","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/comments?post=87"}],"version-history":[{"count":5,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/posts\/87\/revisions"}],"predecessor-version":[{"id":246,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/posts\/87\/revisions\/246"}],"wp:attachment":[{"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/media?parent=87"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/categories?post=87"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/tags?post=87"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}