How to Install phpPgAdmin on CentOS using Yum

phpPgAdmin is web based client written in php for accessing and managing PostgreSQL databases. It provides very efficient way to work with databases on PostgreSQL like, create database, table, alter database, export/import database etc.

This article will you to install phpPgAdmin on CentOS/RedHat System. It required Apache and PostgreSQL to be installed on server. If you do not have them read our turtorials to how to install them.

Installing PostgreSQL on CentOS, RHEL and Fedora
Installing Apache MySQL PHP on CentOS and RHEL

Step 1: Add PostgreSQL repository in System.

First step is to install postgres repository in your system, Download repository rpm using one of below urls.

CentOS/RHEL 5, 32-Bit:
# wget http://yum.postgresql.org/9.1/redhat/rhel-5-i386/pgdg-centos91-9.1-4.noarch.rpm

CentOS/RHEL 6, 32-Bit:
# wget http://yum.postgresql.org/9.1/redhat/rhel-6-i386/pgdg-centos91-9.1-4.noarch.rpm

CentOS/RHEL 5, 64-Bit:
# wget http://yum.postgresql.org/9.1/redhat/rhel-5.0-x86_64//pgdg-centos91-9.1-4.noarch.rpm

CentOS/RHEL 6, 64-Bit:
# wget http://yum.postgresql.org/9.1/redhat/rhel-6.3-x86_64/pgdg-centos91-9.1-4.noarch.rpm
Step 2: Install phpPgAdmin using Yum

Install phpPgAdmin package using yum command line tool.

# yum install phpPgAdmin
Step 3: Configure phpPgAdmin to Access Remotly.

phpPgAdmin bye default all allowed to access from localhost only. If you want to make it accessible from remote computers edit /etc/httpd/conf.d/phpPgAdmin.conf and update configure 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>
Step 4: Restart Apache Service

Restart apache service to reload new settings.

# service httpd restart
Step 5: Access phpPgAdmin on Browser.

Now you can access phpPgAdmin in browser using following url. Change 192.168.1.100 with your server ip.


http://192.168.1.100/phpPgAdmin/

phpPgAdmin-Home

Rahul

Founder of TecAdmin.net. I love to work with Linux and other open source application. Also I like to share knowledge with my friends and other Linux users. Follow me on Twitter, Add me on Google+ or Like Facebook page.

5 Comments

  1. Wonderful post! We will be linking to this great article on our site.
    Keep up the good writing.

  2. Quick bit of info, if like me, you receive an error when following the exact steps – after the wget, you’ll see:
    [root@mymachine]# yum install phpPgAdmin
    Loaded plugins: fastestmirror, security
    Loading mirror speeds from cached hostfile
    * base: mirrors.usinternet.com
    * extras: mirror.team-cymru.org
    * updates: mirrors-pa.sioru.com
    Setting up Install Process
    No package phpPgAdmin available.
    Error: Nothing to do

    Do this instead:
    [root@mymachine]# yum install pgdg-centos91-9.1-4.noarch.rpm

    THEN you can yum install the package name… It’s just that the rpm needed to be installed for the repo before continuing.

Leave a Reply