phpPgadmin Installation

[1] Install and configure phpPgAdmin
[root@www ~]# yum –enablerepo=epel -y install phpPgAdmin php-pgsql # install from EPEL
[root@www ~]# vi /etc/phpPgAdmin/
# 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
# line 72: change and add the IP range you permit
# line 75: change
[root@www ~]# vi /etc/httpd/conf.d/phpPgAdmin.conf
# line 11: add IP range you permit
Allow from
[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.


Share your thoughts with us!!!

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s