Postgres installation on Ubuntu

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


You can watch this video and this video for installation of postgres + pgadmin4