postgres psql

psql

By default installation postgres have default password that is default system password

/etc/init.d/postgresql status

service postgresql status

sudo -u postgres psql

CREATE USER panasimon with PASSWORD 'password';

create database panadb;

GRANT ALL PRIVILEGES ON DATABASE "panadb" to panasimon;

For changing the password 
 
sudo -u postgres psql postgres
 
\password <password>

\connect webaccount

SELECT * FROM frontend_projects;