Home » Centos/RHEL » How to install phpPgAdmin using Yum

How to install phpPgAdmin using Yum

phpPgAdmin is a web-based administration tool written in PHP to dealing with PosgreSQL Database. It is best choice of PostgreSQL Database administrator, Developer, and hosting services.
phpPgAdmin is available only in PostgreSQL RPM repository. If you didn’t add PostgreSQL repository, you should add EPEL repository. In this article we will discuss how to install phpPgAdmin using yum.

http://www.linuxpcfix.com/install-postgresql-database-centos7-rhel7
Enable PostgreSQL Yum Repository.
Centos7/RHEL7

[root@linuxpcfix ~]# rpm -Uvh https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-2.noarch.rpm

Centos6/RHEL6

[root@linuxpcfix ~]# rpm -Uvh https://yum.postgresql.org/10/redhat/rhel-6-x86_64/pgdg-redhat10-10-2.noarch.rpm.

Install phpPgAdmin and Apache webserver

[root@linuxpcfix ~]# yum install phpPgAdmin httpd

As phpPgAdmin by default enable restrict access (Only from localhost) not allowed from remote computers access, So to make it accessible from remote system edit /etc/httpd/conf.d/phpPgAdmin.conf and make necessary changes like below.

Alias /phpPgAdmin /usr/share/phpPgAdmin

<Directory /usr/share/phpPgAdmin>

   order deny,allow

   deny from all

   allow from 192.168.1.0/24

</Directory>

Now restart apache web server using following command.

[root@linuxpcfix ~]# systemctl restart httpd.service

Finally you can access phpPgAdmin type the following url in your web browser.

http://host.linuxpcfix.com/phpPgAdmin

If you are able to browse above URL without any issue that means you have installed successfully on your server that’s it.
If have not install Postgresql database on your server than read our previous post to install Postgresql.

About

I am founder and webmaster of www.linuxpcfix.com and working as a Sr. Linux Administrator (Expertise on Linux/Unix & Cloud Server) and have been in the industry from last 7 years.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Time limit is exhausted. Please reload the CAPTCHA.

Categorized Tag Cloud