Install and setup POSTGRESQL DB in ubuntu

1) Install POSTGRESQL 

sudo apt update

sudo apt install -y postgresql postgresql-contrib

2) Verify it is working

sudo systemctl status postgresql

3) setup DB

sudo -u postgres psql

4) CREATE USER user_name WITH PASSWORD 'password';

CREATE DATABASE name_db OWNER user_name;

GRANT ALL PRIVILEGES ON DATABASE name_db TO user_name;

\q