{"id":1201,"date":"2014-08-21T21:51:02","date_gmt":"2014-08-21T19:51:02","guid":{"rendered":"http:\/\/blog.rabahi.net\/?page_id=1201"},"modified":"2014-08-21T21:51:52","modified_gmt":"2014-08-21T19:51:52","slug":"postgres","status":"publish","type":"page","link":"https:\/\/blog.rabahi.net\/?page_id=1201","title":{"rendered":"Postgres"},"content":{"rendered":"

Installation<\/h1>\n
  1. #!\/bin\/bash<\/span><\/div><\/li>
  2.  <\/div><\/li>
  3. echo<\/span> "install postgresql server"<\/span><\/div><\/li>
  4. yum<\/span> -y<\/span> install<\/span> postgresql-server phpPgAdmin<\/div><\/li>
  5.  <\/div><\/li>
  6. echo<\/span> "initialize database"<\/span><\/div><\/li>
  7. postgresql-setup initdb<\/div><\/li>
  8. sudo<\/span> -u<\/span> postgres createuser root<\/div><\/li>
  9. sudo<\/span> -u<\/span> postgres createdb mydatabase<\/div><\/li>
  10.  <\/div><\/li>
  11. echo<\/span> "activate postgresql at startup"<\/span><\/div><\/li>
  12. systemctl enable<\/span> postgresql.service<\/div><\/li>
  13.  <\/div><\/li>
  14. echo<\/span> "start the server"<\/span><\/div><\/li>
  15. systemctl start postgresql.service<\/div><\/li>
  16.  <\/div><\/li>
  17. echo<\/span> "Note: by default only local users can access to phpPgAdmin."<\/span><\/div><\/li>
  18. echo<\/span> "Let's update the file \/etc\/httpd\/conf.d\/phpPgAdmin.conf and allow everyone."<\/span><\/div><\/li>
  19. sed<\/span> -i<\/span> "s\/\\(Deny\\s*from\\s*All\\)\/#\\1\/i"<\/span> \/<\/span>etc\/<\/span>httpd\/<\/span>conf.d\/<\/span>phpPgAdmin.conf<\/div><\/li>
  20. sed<\/span> -i<\/span> "s\/\\(Allow\\s*from\\s*127.0.0.1\\)\/#\\1\/i"<\/span> \/<\/span>etc\/<\/span>httpd\/<\/span>conf.d\/<\/span>phpPgAdmin.conf<\/div><\/li>
  21. sed<\/span> -i<\/span> "s\/\\(Allow\\s*from\\s*::1\\)\/#\\1\/i"<\/span> \/<\/span>etc\/<\/span>httpd\/<\/span>conf.d\/<\/span>phpPgAdmin.conf<\/div><\/li>
  22.  <\/div><\/li>
  23. echo<\/span> "Now reload httpd"<\/span><\/div><\/li>
  24. systemctl reload httpd.service<\/div><\/li>
  25.  <\/div><\/li><\/ol><\/pre>\n","protected":false},"excerpt":{"rendered":"
    Installation<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1203,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1201","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/1201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1201"}],"version-history":[{"count":1,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/1201\/revisions"}],"predecessor-version":[{"id":1202,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/1201\/revisions\/1202"}],"up":[{"embeddable":true,"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=\/wp\/v2\/pages\/1203"}],"wp:attachment":[{"href":"https:\/\/blog.rabahi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}