Install PostgreSQL with phpPgAdmin on Ubuntu 16.04


postgresql with phppgadmin on ubuntu

PostgreSQL is an object-relational database management system (ORDBMS) that is suited for large databases and has many advanced features. Its emphasis is on extensibility and standards-compliance. PostgreSQL can handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

It is available for many operating systems few of which are Linux, Solaris, FreeBSD and Microsoft Windows.

What happens if you want to manage the PostgreSQL databases from a graphical interface and not the command line?

You can use phpPgAdmin which is a is a web-based administration tool for PostgreSQL. It is perfect for users that don’t have experience in managing PostgreSQL from the command line. phpPgAdmin is the PostgreSQL equivalent of MySQL’s phpMyAdmin and provides a convenient way for users to create databases, create tables, alter tables and query their own data using industry-standard SQL.

So in today’s article, we will install PostgreSQL and phpPgAdmin on an Ubuntu 16.04 VPS.

REQUIREMENTS

We will be using our SSD 1 Linux VPS hosting plan for this tutorial.

LOG IN TO YOUR SERVER VIA SSH

# ssh root@server_ip

You can check whether you have the proper Ubuntu version installed on your server with the following command:

# lsb_release -a

You should get this output:

Distributor ID: Ubuntu
Description:    Ubuntu 16.04.1 LTS
Release:        16.04
Codename:       xenial

UPDATE THE SYSTEM

Make sure your server is fully up to date using:

# apt-get update && apt-get upgrade

Now install PostgreSQL and phpPgAdmin using the below command:

# apt-get install postgresql postgresql-contrib phppgadmin

This command will install all the necessary packages needed by PostgreSQL and phpPgAdmin such as Apache, PHP etc… so don’t worry if you don’t have Apache or PHP installed on your server.

Once the installation is completed, log into the ‘postgres‘ system account so you can access PostgreSQL. Type:

# su - postgres

Now you can access PostgreSQL using:

postgres@vps:~$ psql

Change your ‘postgres‘ role password to match your needs:

postgres=# \password postgres

Enter the new password when prompted.

Quit the psql command line:

postgres=# \q

Exit the postgres user:

postgres=# exit

CONFIGURE APACHE

In order to access phpPgAdmin via your browser, the Apache web server needs to be configured. Therefore open the phppgadmin.conf file:

# nano /etc/apache2/conf-available/phppgadmin.conf

Comment the ‘Require local‘ line by adding ‘#’ in front of the line. Then under that very line, add ‘Allow From all‘. Save and close the file. After editing the section should look like this:

# Only allow connections from localhost:
#Require local
Allow From all

Now tweak some settings for phpPgAdmin. Open the config.inc.php file:

# nano /etc/phppgadmin/config.inc.php

Locate the ‘$conf[‘extra_login_security’] = true;‘ and change the value from true to false so you can log in to phpPgAdmin as the postgres user.

Save and close the file.

Now restart PostgreSQL and Apache. Then enable them to start on boot. All of this can be done using the below 4 commands:

# systemctl restart postgresql

# systemctl restart apache2

# systemctl enable postgresql

# systemctl enable apache2

Now open your favorite web browser and access phpPgAdmin by navigating to http://your_server_IP/phppgadmin/. You will be welcomed by a page as shown in the image below:

phppgadmin

 

 

 

 

 

 

You can log in using the postgres user and the password you’ve configured previously. Now use this great tool to create and manage databases in PostgreSQL.

Of course you don’t have to do any of this if you use one of our Linux VPS Hosting services, in which case you can simply ask our expert Linux admins to install PostgreSQL and phpPgAdmin for you. They are available 24×7 and will take care of your request immediately.

PS. If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.

Tutorials
How to Install osCommerce on a Linux VPS
Tutorials
Set up a mail server with PostfixAdmin and MariaDB on CentOS 7
Tutorials
How to install Odoo 10 on Ubuntu 16.04 with Apache as a reverse proxy
  • Pablo

    PabloPablo

    Author Reply

    I have an error: Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Misc has a deprecated constructor in /usr/share/phppgadmin/classes/Misc.php on line 8

    :(


    • admin

      adminadmin

      Author Reply

      Could you please provide us with the output of the following commands:

      lsb_release -a
      php -v


  • Gabisto

    GabistoGabisto

    Author Reply

    *************@************:~$ lsb_release -a
    No LSB modules are available.
    Distributor ID: Debian
    Description: Debian GNU/Linux 8.8 (jessie)
    Release: 8.8
    Codename: jessie
    *************@************::~$ php -v
    PHP 7.1.6-2 (cli) (built: Jun 14 2017 05:31:31) ( NTS )
    Copyright (c) 1997-2017 The PHP Group
    Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies
    with Zend OPcache v7.1.6-2, Copyright (c) 1999-2017, by Zend Technologies


    • admin

      adminadmin

      Author Reply

      Most likely the Debian PhpPgAdmin package works only with PHP 5, you can try to install PhpPgAdmin from source.


 
Free Migration to RoseHosting. Award Winning Linux VPS Hosting with Fully Managed Support. Coupon RHBLOG50 for 50% offOrder Now
+