How To Install PostgreSQL on Ubuntu 16.04

September 17, 2016

How To Install PostgreSQL on Ubuntu 16.04

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.


Step 2. Installing PostgreSQL server.

PostgreSQL is available in the default repositories. So enter the following command from the Terminal to install it:


Step 3. Access PostgreSQL command prompt.

After installing PostgreSQL database server, by default it creates a user ‘postgres’ with role ‘postgres’. It also creates a system account with same name ‘postgres’. So to connect to postgres server, login to your system as user postgres and connect database:


Now you are logged in to PostgreSQL database server. To check login info use following command from database command prompt:


To disconnect from PostgreSQL database command prompt just type below command and press enter. It will return you back to Ubuntu command prompt:


Create new user and database:


Step 4. Configure Apache2 for phpPgAdmin.

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies, and hosting services. You need to configure apache for phpPgAdmin. Edit the file /etc/apache2/conf-available/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:

Step 5. Configure phpPgAdmin.

Next, edit the file /etc/phppgadmin/config.inc.php:


Now change the following option:


Now, we can restart Apache and phpPgAdmin so that the changes take place:


Step 6. Accessing phpPgAdmin.

phpPgAdmin will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/phppgadmin or http://server-ip/phppgadmin. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed PostgreSQL Server.