login to postgres with username and password code example
Example 1: how to connect postgres user password using command line
sudo -u postgres psql postgres
Example 2: how to connect postgres user password using command line
\password postgres
sudo -u postgres psql postgres
\password postgres