xxxxxxxxxx
//CHECK POSTGRES IS WORKING OR NOT
sudo systemctl status postgresql
//THIS WILL ACCEPT PORTS
sudo pg_isready
sudo su postgres
//NAVIGATE TO SQL TERMINAL / BASH
psql
//CREATE A NEW USER WITH PASSWORD
CREATE USER yourname WITH PASSWORD 'yourpassword';
xxxxxxxxxx
sudo su postgres
psql -U postgres
\password
Enter new password:
Enter it again:
postgres user is : postgres