Scientific Linux 6
Sponsored Link

phpPgAdmin - Operate from Web browser2011/06/18

 
Install phpPgAdmin and operate PostgreSQL from Web browser. Web server is also required.
[1] Install and configure 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 88: change

$conf['extra_login_security'] =
false
;
# line 94: change

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

local
all
all
md5
# line 72: change and add the IP range you permit

local
all
all
127.0.0.1/32
md5

local
all
all
10.0.0.0/24
md5
# line 75: change

local
all
all
::1/128
md5
[root@www ~]#
vi /etc/httpd/conf.d/phpPgAdmin.conf
# line 11: add IP range you permit

Allow from 127.0.0.1
10.0.0.0/24
[root@www04 ~]#
/etc/rc.d/init.d/postgresql restart

Stopping postgresql service:
[ OK ]

Starting postgresql service:
[ OK ]

[root@www ~]#
/etc/rc.d/init.d/httpd reload

Reloading httpd:
[ OK ]

[2] Access to "http://(hostname or IP address)/phpPgAdmin/" and click "PostgreSQL" on the left.
[3] Authenticate with a user you added in PostgreSQL.
[4] Just logined. It's possible to operate PostgreSQL Database on here.
Matched Content