How to install PostgreSQL and phpPgAdmin on Ubuntu 15.10, Ubuntu 15.04 and Ubuntu 14.04

PostgreSQL  is powerful high-performance object-relational database management system. This tutorial is going to show you to install PostgreSQL on Ubuntu system. Also, I will show you how to install phpPgAdmin, a web based front end for PostgreSQL database. This tutorial is applicable to most recent Ubuntu version including Ubuntu 15.10, Ubuntu 15.04 and also Ubuntu 14.04 LTS.

Steps to install PostgreSQL, phpPgAdmin and Apache2 on Ubuntu

Open Terminal and paste this command

sudo apt-get install postgresql postgresql-contrib phppgadmin


install postgresql on ubuntu

Next we need to configure PostgreSQL user. Type the following command on Terminal

sudo su
su – postgres

Now enter postgresql prompt



dhani@dhani-ubuntu:~$ sudo su
root@dhani-ubuntu:/home/dhani# su – postgres
postgres@dhani-ubuntu:~$ psql
psql (9.4.4)
Type “help” for help.

Now change the password for postgres user

\password postgres

Enter your new password twice.

Type \quit to exit.

At this point we’re successfully install and configure postgresql server. Now we need to configure some other things.

Configure Apache

cd /etc/apache2/conf-available/
sudo nano phppgadmin.conf

Comment out the line #Require local by adding a # in front of the line and add below the line allow from all so that you can access from your browser.

edit phppgadmin

Configure phpPgAdmin

cd /etc/phppgadmin/
sudo nano

Find the line $conf[‘extra_login_security’] = true; and change the value to false so you can login to phpPgAdmin with user postgres. Change the value to false.

configure phppgadmin

Restart postgres and Apache

sudo systemctl restart postgresql
sudo systemctl restart apache2

Now open web browser and type the following address


phppgadmin on ubuntu

install phppgadmin on ubuntu


Leave a Reply

Your email address will not be published. Required fields are marked *