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/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
localallallmd5
# line 72: change and add the IP range you permit
hostallall127.0.0.1/32md5
hostallall10.0.0.0/24md5
# line 75: change
localallall::1/128md5
[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.

Advertisements

Share your thoughts with us!!!

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s