https://help.ubuntu.com/community/PostgreSQL [3]

1. Installing server locally

$sudo apt-get install postgresql postgresql-contrib

2. Administration using GUI tool pgAdmin3

$sudo apt-get install pgadmin3

3. Basic server setup

$sudo -u postgres psql postgres

\password postgres

Give password when prompted. Then type Control+D or \q to exit the posgreSQL prompt.

4. Create database

sudo -u postgres createdb <database-name>

5.Using pgadmin3 GUI tool

$pgadmin3

You can watch this video [4] and this video for installation of postgres + pgadmin4 [5]