How to Install and configuration PostgreSQL on Ubuntu Linux - Learn Online

POSTGRESQL is an open-source, full-featured relational database.PostgreSQL is the most advanced open source relational database, MySQL did not have triggers, PostgreSQL did.
In this tutorial we will see How to Install PostgreSQL 9.6 on Ubuntu 16.04 LTS. The same procedure can be used for installing PostgreSQL 9.6 on Ubuntu 14.04 LTS.

Step 1: Install PostgreSQL

$ sudo apt-get update
$ sudo apt-get install postgresql postgresql-contrib

Step 2: Connecting to PostgreSQL

Ather the installation of PostgreSQL a user account called postgres created that is associated with the default Postgres role. In order log into to use Postgres account, we nee to give following command:

$ sudo su - postgres
$ psql


  1. service postgresql status
    9.3/main (port 5432): down

    how to make the server running

  2. why do you ask us for commenting while you never reply any of it !
    even if someone is asking about the content of the video!

  3. obileye oladotun1 March 2017 at 15:44

    Thanks pk your videos has really helped me. Pls I need a tutorial on how to create a cbt application in c#

  4. Thanks for the video, can you also do a video how to configure PostgreSQL with HA Pairs or 3-4 Node Cluster ?

  5. Tech and Programming1 March 2017 at 15:44

    Great tutorial :)

  6. You should pronounce Postgresql as " Post-GRES-que-ell " and not like "Post-grei-SQL".

  7. Angry KoalaBear1 March 2017 at 15:44

    Great video! Such a good content!


Note: only a member of this blog may post a comment.