CentOS 5
Sponsored Link

Install phpPgAdmin
2015/01/15
 
Install phpPgAdmin to operate PostgreSQL on web browser from Clients. Web is required for it.
[1] Install phpPgAdmin.
[root@www ~]#
yum --enablerepo=epel -y install phpPgAdmin php-pgsql
 
# install from EPEL
[root@www ~]#
vi /etc/phpPgAdmin/config.inc.php
# line 18: add

$conf['servers'][0]['host'] = '
localhost
';
# line 94: add

$conf['owned_only'] =
true
;
[root@www ~]#
vi /var/lib/pgsql/data/pg_hba.conf
# line 70: add IP address you allow

host   all   all   127.0.0.1/32   ident sameuser
host   all   all   10.0.0.0/24   ident sameuser
[root@www ~]#
vi /etc/httpd/conf.d/phpPgAdmin.conf
# line 11: add IP address you allow

Allow from 127.0.0.1
10.0.0.0/24
[root@www ~]#
/etc/rc.d/init.d/httpd reload

Reloading httpd:   [ OK ]
[2] Access to the "http://(hostname or IP address名)/phpPgAdmin" and click "PostgreSQL" on the left menu.
[3] Autenticate a user and password which is in PostgreSQL.
[4] Just logined. You can operate PostgreSQL on here.
Matched Content
 
Tweet