How to Install PostgreSQL 9.6 on Ubuntu 16.04 LTS

How to Install PostgreSQL 9.6 on Ubuntu 16.04 LTS

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 2: Install PostgreSQL

Shell

1

2

3

4

$sudo apt-getupdate

$sudo apt-getupgrade

$sudo apt-getinstall postgresql postgresql-contrib libpq-dev pgadmin3

Step 3: 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: