Create database & user postgres

create.md

To Create

$ sudo -u postgres psql
psql=# CREATE DATABASE campus_ambassador;
psql=# CREATE USER admin WITH ENCRYPTED PASSWORD 'admin123';
psql=# GRANT ALL PRIVILEGES ON DATABASE campus_ambassador TO admin;

To Drop

$ sudo -u postgres psql
psql=# SELECT pg_terminate_backend(pid)FROM pg_stat_activity WHERE datname = 'campus_ambassador';
psql=# DROP DATABASE campus_ambassador

upgrade user to super user

ALTER USER myuser WITH SUPERUSER;