Install phpPgAdmin on CentOS & RHEL

Share It!

phpPgAdmin is web-based client written in php for accessing and managing PostgreSQL databases, it is very similar in look of phpMyAdmin. phpPgAdmin will let you add, remove and manage databases, tables, and entries; run specific SQL queries, backup the database, search and import record, and much more. If you have a work experience on phpMyAdmin, you wont take much time in finding the way to work with.
Install phpPgAdmin

See Also:

  • Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5
  • Install PostgreSQL 9.5 on Ubuntu 15.10, 14.04 & 12.04
  • This article will help you to install phpPgAdmin on CentOS and RedHat Systems.

    Step #1 Add PostgreSQL Repository

    First install postgres repository in your system, use following command to install repository:

    For CentOS/RHEL 7
    # rpm -Uvh
    For CentOS/RHEL 6 64 Bit
    # rpm -Uvh
    For CentOS/RHEL 5 64 bit
    # rpm -Uvh
    For CentOS/RHEL 6 32 Bit
    # rpm -Uvh
    For CentOS/RHEL 5 32 bit
    # rpm -Uvh

    Step #2 Install phpPgAdmin

    Install phpPgAdmin using yum following command.

    # yum install phpPgAdmin

    Step #3 Configure phpPgAdmin

    By default you can access phpPgAdmin from localhost only. If you want to make it accessible from remote computers also then edit phpPgAdmin configuration and update like below.

    # vim /etc/httpd/conf.d/phpPgAdmin.conf
    Alias /phpPgAdmin /usr/share/phpPgAdmin
    <Directory /usr/share/phpPgAdmin>
       order allow,deny
       deny from all
       allow from
       Require all granted
    <Location /phpPgAdmin>
        <IfModule mod_authz_core.c>
            # Apache 2.4
            Require local
    	Require all granted
        <IfModule !mod_authz_core.c>
            # Apache 2.2
            Order allow,deny
            deny from all
            Allow from
            Allow from ::1
    	Require all granted

    Step #4 Restart Apache Service

    Restart Apache service to reload new settings.

    For CentOS/RHEL 7
    # systemctl restart httpd
    For CentOS/RHEL 6/5
    # service httpd restart

    Step #5 Access phpPgAdmin

    Now you can access phpPgAdmin in browser using following url. 


    Enjoy it!

    Leave a Reply

    Your email address will not be published.