Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at:Home»Databases»PostgreSQL»How to Install phpPgAdmin on CentOS & RHEL using Yum

    How to Install phpPgAdmin on CentOS & RHEL using Yum

    By RahulMay 15, 20132 Mins Read

    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.

    Advertisement

    This article will help you to install phpPgAdmin on CentOS and RedHat Systems. Before installing it make sure you have Apache and PostgreSQL installed on server. If you do not have them read our tutorials 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

    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

    phpPgAdmin postgesql admin
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    How to Install PostgreSQL and pgAdmin4 in Ubuntu 20.04

    How To Install PostgreSQL Server on CentOS 8

    How to Install PostgreSQL 11 on Debian 10 (Buster)

    View 3 Comments

    3 Comments

    1. JayH on July 30, 2014 6:42 pm

      Quick bit of info, if like me, you receive an error when following the exact steps – after the wget, you’ll see:
      [[email protected]]# 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:
      [[email protected]]# 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.

      Reply
      • Lucas Reis on November 12, 2014 1:53 am

        Hey bro, thank you. I worked for me, but I am having a problem to log in on phpPgAdmin. I created a new super user through terminal, but I cannot log in on phpPgAdmin. Can you help with this?

        Reply
    2. longuepine.info on January 31, 2014 6:22 pm

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

      Reply

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • tail Command in Linux with Examples
    • What is a Orphan Process in Unix/Linux
    • How To Display Warning Message to Unauthorized SSH Access
    • How to Set a Custom SSH Login Banner and MOTD
    • Understanding Reverse DNS: What it is and Why it Matters?
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.