How to Install and configuration PostgreSQL on Ubuntu Linux

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

★★★Top Online Courses From ProgrammingKnowledge ★★★

★★★ Online Courses to learn ★★★

★★★ Follow ★★★

DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!

[simonvalenzuela]

Always there's an Indian guy who saves you ;)
Thank you very much brother. Cheers from Argentina.

[garethd]

You have some of the best, most comprehensive tutorials I've ever seen. On behalf of the engineers picking up new skills, thank you!

[akashverma]

I was doing it by studying so many articles, like digi ocean, stack and what not. But this video made my day!!! Very precise and helpful

[fxylxy]

This is a really good tutorial, everything I need to get up and running. Thanks.

[alexveillette]

This saved me in 2020 (Ubuntu 20.04 KDE). I could not do anything because I didn't have any users that was working properly. Thanks a lot.

[yltfy]

2:45 "At the time you watch this video, this version will be around 9.5 or 9.6" Well, I'm now watching this video and the version is 13 now!

[laurentfriob]

Love it, unlike what I've seen so far you explain, rather than describe, what you type and what it means & lead to. Much better way to learn from as far as I'm concerned. Thanks!

[futureman]

this is super helpful....got me up and running (even 4 years later in 2022)....thanks!!

[utkarshsrivastava]

Thank you so much for this detailed tutorial! I don't comment very often but this really helped me a lot

[GeorgeKer]

Excellent tutorial!
I really don't comment very often on tutorials, but you absolutely helped me.
I'm on MX Linux (debian based), the process is nearly identical.
Saved playlist for my library

[adityahansraj]

I h ave been having trouble for long with postgres setup in mu ubuntu OS, now finallyy !!! you halped !!! :) THANK YOU

[RonaldModesitt]

Excellent tutorial! Very easy to follow, concise and complete.

[bobcrunch]

Explains what the documentation doesn't tell you!!! Wonderful. Thank you!

[itamarribeiro]

This is gold for PostgreSQL beginners like me, thanks

[_vdgazer]

Worked like a charm, thanks for this awesome tutorial!

[dwabuluka]

After a while googling you have finally rescued me. Thank you

[juandiegogiltrujillo]

Thank you so much, you saved me to use PgAdmin in Ubuntu, I just knew managed it in Windows

[nicolahcm]

SO clear. Thank you. More like you are needed. Finally it is relieving to see someone who can explain..

[naveenchandrakumar]

Terrific. Everything worked on my linux-mint 17.2 (64 bit) spot on as said here. Thank you so much.

[Walking-tour-with-pavan]

Good presentation. Very clear overview on PSQL. Thankyou.