How to Install and configuration PostgreSQL on Ubuntu Linux

sudo apt-get update

sudo apt-get install postgresql postgresql-contrib

ls /etc/postgresql/12/main/

service postgresql

service postgresql status

sudo su postgres

postgres@LinusBenedictTorvalds:/home/sundaradmin$ psql

see the database

postgres=#\l

see the users

postgres=#\du

Change the postgres user password

postgres=# ALTER USER postgres WITH PASSWORD 'root123' ;

create a user

CREATE USER user_1 WITH PASSWORD 'root123' ;

give superuser rights to user_1

ALTER USER user_1 WITH SUPERUSER;

delete a user

DROP USER user_2;