PostgreSQL: How to Install PostgreSQL 9.6 on Ubuntu 16.04?

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

 

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
 
I am going to share few steps to install PostgreSQL 9.6 on Ubuntu 16.04.

First, check the version of Ubuntu:

You need to add the latest PostgreSQL repository for the latest version, otherwise It will install old version. This is for trusty version.
Update and Install PostgreSQL 9.6:
Default postgres super user and postgres database is created. You need to set a password for the postgres super user.
If service is not started, you can start the PostgreSQL service.
Connect PostgreSQL server using postgres user:
Create a sample database:
Connect to that database:
Create a sample table:
Exit to database session:
Exit to PostgreSQL server: