PostgreSQL 9.5 : Install phpPgAdmin2017/09/25

	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 35: change

$conf['servers'][0]['pg_dump_path'] = '

/opt/rh/rh-postgresql95/root/usr/bin/pg_dump

';
$conf['servers'][0]['pg_dumpall_path'] = '

/opt/rh/rh-postgresql95/root/usr/bin/pg_dumpall

# line 88: change to false if you allow to login with priviledged user like postgres, root

$conf['extra_login_security'] =

false

;

# line 94: change

$conf['owned_only'] =

true

;

[root@dlp ~]#

vi /var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_hba.conf

# line 82: change like follows and 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

Allow from 127.0.0.1

10.0.0.0/24

[root@dlp ~]#

/etc/rc.d/init.d/rh-postgresql95-postgresql restart

[root@dlp ~]#

/etc/rc.d/init.d/httpd restart

[4]	If SELinux is enabled, change boolean setting.

[root@dlp ~]#

setsebool -P httpd_can_network_connect_db on

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

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

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

Matched Content