psql: FATAL: role "ubuntu" does not exist code example
Example 1: psql: error: FATAL: role "postgres" does not exist
createuser -U postgres -s YOURUSERNAME
createdb YOURUSERNAME
Example 2: role "postgres" does not exist
template1=# CREATE USER username WITH PASSWORD 'user_password';
template1=# GRANT ALL PRIVILEGES ON DATABASE "user_database" to username;