Install phppgadmin on linux

Introduction:
phpmyadmin provides an gui access for postgresql database. We can access database from command line also. But in order to do that, user must have knowledge of psql queries. So sometimes, we just want to start our project quickly without understanding psql queries in depth.

It runs at http://localhost/phppgadmin.

Steps:

1) Do an update and upgrade on your system

 sudo apt-get update && sudo apt-get upgrade

     or

sudo yum update && sudo yum upgrade

2) Install apache 2.4

sudo apt-get install apache2 apache2-doc apache2-utils

    or

sudo yum install apache2 apache2-doc apache2-utils

3) run apache server

sudo service apache2 start

     and check http://localhost

4) Install postgresql

sudo apt-get install postgresql postgresql-contrib phppgadmin

     or

sudo yum install postgresql postgresql-contrib phppgadmin

5) Configure postgres user

 sudo su
 su – postgres
 psql
 \password postgres
 ENTER YOUR PASSWORD

6)  Edit /etc/phppgadmin/config.inc.php file and
change value of
$conf[‘extra_login_security’] = true;
to
$conf[‘extra_login_security’] = false;

sudo vi /etc/phppgadmin/config.inc.php

7)

sudo cp /etc/apache2/conf.d/phppgadmin /etc/apache2/conf-enabled/phppgadmin.conf

8) Restart apache and start postgresql  

sudo service apache2 restart
sudo service postgresql start
 

You are Done!

Share on Google Plus

About Unknown

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.