install phpPgAdmin

yum install httpd php

設定 vim /etc/httpd/conf/httpd.conf
DirectoryIndex後面加入index.php

安裝phpPgAdmin

• yum安裝
  

  yum install phpPgAdmin
  會將相關的apache php等套件一同安裝
  使用yum安裝完後在/var/www/html並沒有發現phpPgAdmin的資料夾
  主要分成兩個部分
  主程式：/usr/share/phpPgAdmin
  設定檔：/etc/phpPgAdmin/config.inc.php
  網址：127.0.0.1/phpPgAdmin就可以連到，系統會自動設好
  

• 手動下載安裝：
  

  下載網站：http://phppgadmin.sourceforge.net/doku.php?id=download
  下載完後解開到/var/www/html下即可
  設定檔：phpPgAdmin/conf/config.inc.php
  網址：127.0.0.1/phpPgAdmin就可以連到
  

設定config.inc.php

vim /etc/phpPgAdmin/config.inc.php

$conf['servers'][0]['host'] = 'localhost';

// Only show owned databases?
// Note: This will simply hide other databases in the list - this does
// not in any way prevent your users from seeing other database by
// other means. (e.g. Run 'SELECT * FROM pg_database' in the SQL area.)
$conf['owned_only'] = true;

// If extra login security is true, then logins via phpPgAdmin with no
// password or certain usernames (pgsql, postgres, root, administrator)
// will be denied. Only set this false once you have read the FAQ and
// understand how to change PostgreSQL's pg_hba.conf to enable
// passworded local connections.
$conf['extra_login_security'] = false;

設定vim /etc/httpd/conf.d/phpPgAdmin.conf

刪除Allow from 127.0.0.1

增加allow from all

重啟httpd

設定SELinux讓網頁可以連接資料庫

setsebool -P httpd_can_network_connect_db=1

更新 記錄時間 觀察 重製