Install PostgreSQL on Ubuntu 20.04

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. Source https://www.postgresql.org/

Install

Run commands :

sudo su
apt update
apt install -y postgresql postgresql-contrib

Access Database PostgreSQL

run commands :

sudo -i -u postgres
psql

for exit from PostgreSQL console, run :

q

Create New User

Make sure you not in PostgreSQL console and run :

sudo -i -u postgres
createuser your_username

Add Role to User

You can add roles to your user with commands :

sudo -i -u postgres # or user that has role/permission for adding new roles
psql
ALTER ROLE nama_user WITH role_you_want_to_add;

Available roles :

1. BYPASSRLS
2. CREATEROLE
3. LOGIN
4. NOCREATEROLE
5. NOREPLICATION
6. RENAME TO
7. SET
8. CONNECTION LIMIT
9. ENCRYPTED PASSWORD
10. NOBYPASSRLS
11. NOINHERIT
12. NOSUPERUSER
13. REPLICATION
14. SUPERUSER
15. CREATEDB
16. INHERIT
17. NOCREATEDB
18. NOLOGIN
19. PASSWORD
20. RESET
21. VALID UNTIL