• Home
  • Ubuntu 18.04
    • Whats New?
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install Git
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us
TecAdmin
Menu
  • Home
  • Ubuntu 18.04
    • Whats New?
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install Git
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us

How To Install phpPgAdmin on Ubuntu 16.04 and 14.04 LTS

Written by Rahul, Updated on July 24, 2017

phpPgAdmin is an web interface for accessing and managing PostgreSQL databases in a very easy way. We can easily create new databases, tables in the database, users, stored procedures etc. Also, we can execute PL/pgSQL and other stored procedures. It also provides an option for database backup and restores from the web interface.

This article will help you to install phpPgAdmin web interface to manage PostgreSQL server on Ubuntu Systems. We are assuming that you already have installed PostgreSQL in your Ubuntu system, If not first install it using another article Install PostgreSQL on Ubuntu first.

Step 1 – Install Prerequisites

PhpPgAdmin required PHP and Apache2 must be installed on your system. Also, you will need php-pgsql libraries installed on the system. If you don’t have PHP installed, Use tutorial Install PHP7 or Install PHP5 on system. After installing PHP and Apache install the PHP module for postgresql.

$ sudo apt-get update
$ sudo apt-get install php-pgsql   # Use package name as per php verison 

Step 2 – Install phpPgAdmin

We are assuming here that you already have PostgreSQL server running on your Ubuntu system. If not install it first. Now phpPgAdmin packages are also available under default Ubuntu repositories. Use the following command to install phpPgAdmin.

$ sudo apt-get install phppgadmin

Step 3 – Configure PostgreSQL

Now, you may need to make some changes in your PostgreSQL server to access via phpPgAdmin. First this to access PostgreSQL on all interfaces, update the following settings under postgresql.conf file.

$ sud vi /var/lib/pgsql/data/postgresql.conf

listen_addresses = '*' 

After this enable PostgreSQL auth from remote hosts edit pg_hba.conf configuration file and add the last line showing below.

$ sudo vi /var/lib/pgsql/data/pg_hba.conf
#### Default settings  
local   all         postgres                          ident
local   all         all                               ident
host    all         all         127.0.0.1/32          ident
host    all         all         ::1/128               ident
#### Add extra configuration   
host    all         all         192.168.1.0/24          md5 

Step 4 – Configure phpPgAdmin

Now, your PostgreSQL server is ready for accessing with phpPgAdmin. You may face some issue with the login on phpPgAdmin. To fix this disable the extra login security of phpPgAdmin.

$ sudo vi /var/www/html/phpPgAdmin/conf/config.inc.php

Set extra_login_security value to false.

$conf['extra_login_security'] = false;

Step 5 – Access phpPgAdmin

Now phpPgAdmin is available to access from localhost only. To access from local system just type below url in your favorite browser.

http://localhost/phppgadmin

phpPgAdmin Login Screen

Step 6 – Secure phpPgAdmin

Now if you want to access phpPgAdmin web interface from the remote system like your local LAN or remote public network server. We need to make little changes in PostgreSQL Apache configuration file. To do it edit file

$ sudo nano /etc/apache2/conf-enabled/phppgadmin.conf

Now comment the Require local line and add other lines in configuration file to allow specific ip ranges.

#Require local
order deny,allow
deny from all
allow from 127.0.0.0/255.0.0.0 ::1/128
allow from 192.168.1.0/24

Save you file and restart Apache service using the following command.

$ sudo service apache2 reload

Share it!
Share on Facebook
Share on Twitter
Share on LinkedIn
Share on Reddit
Share on Tumblr
Share on Whatsapp
Rahul
Rahul
Connect on Facebook Connect on Twitter

I, Rahul Kumar am the founder and chief editor of TecAdmin.net. I am a Red Hat Certified Engineer (RHCE) and working as an IT professional since 2009..

5 Comments

  1. Avatar Nial Reply
    May 17, 2017 at 2:12 pm

    what is username and password for phppgadmin?

    • Rahul Rahul K. Reply
      July 24, 2017 at 4:19 am

      Use PostgreSQL username and password for the login.

  2. Avatar Sidhi Reply
    January 11, 2017 at 4:41 pm

    When I try to : sudo nano /etc/apache2/conf.d/phppgadmin
    got this error message :
    [ Error writing /etc/apache2/conf.d/phppgadmin: No such file or directory ]
    What should I do ?

  3. Avatar kkkk Reply
    September 17, 2016 at 11:16 am

    good but how to login now?

  4. Avatar DevCH Reply
    May 20, 2016 at 4:03 pm

    y con que login entro?

Leave a Reply Cancel reply

Popular Posts

  • How To Install Python 3.9 on Ubuntu 20.04 5
  • How to Install Python 3.9 on CentOS/RHEL 7 & Fedora 32/31 0
  • How To Install VNC Server on Ubuntu 20.04 1
  • How To Install NVM on macOS with Homebrew 0
  • (Solved) apt-add-repository command not found – Ubuntu & Debian 0
© 2013-2020 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy