PostgreSQL : Install phpPgAdmin

PostgreSQL : Install phpPgAdmin 2015/07/23

	Install phpPgAdmin to operate PostgreSQL on web browser from Client hosts.
[1]	Install and start Apache httpd, refer to here.
[2]	Install PHP, refer to here.
[3]	Install phpPgAdmin.

# install from EPEL [root@dlp ~]#  yum --enablerepo=epel -y install phpPgAdmin php-pgsql [root@dlp ~]#  vi /etc/phpPgAdmin/config.inc.php # line 18: add $conf['servers'][0]['host'] = ' localhost '; # line 93: change to false if you allow to login with priviledged user like postgres, root $conf['extra_login_security'] =  false ; # line 99: change $conf['owned_only'] =  true ; [root@dlp ~]#  vi /var/lib/pgsql/data/pg_hba.conf # line 82: change like follows & add access permission host all all 127.0.0.1/32 md5 host all all 10.0.0.0/24 md5 host all all ::1/128 md5 [root@dlp ~]#  vi /etc/httpd/conf.d/phpPgAdmin.conf # line 11: add access permission Require local Require ip 10.0.0.0/24 [root@dlp ~]#  systemctl restart postgresql httpd

[4]	Access to the "http://(hostname or IP address)/phpPgAdmin/" and click "PostgreSQL" on the left menu.

[5]	Autenticate a user and password which is in PostgreSQL.

[6]	Just logined. You can operate PostgreSQL on here.