postgresql permissions denied

Asked Jan 20 '21 at 16:22

Active Jan 20 '21 at 16:24

Viewed 68 times

I have just finished install postgres from the way that the postgresql website says for ubuntu20.04

when I run psql I get

psql: error: FATAL:  database "myusername" does not exist

when I run createdb I get

createdb: error: database creation failed: ERROR:  permission denied to create database

this is the one command that I have ran from looking online

sudo -u postgres createuser myusername

it seems to not have done anything though

edited Jan 20 '21 at 16:24

asked Jan 20 '21 at 16:22

INuke

Do you recieve any error or output when running `sudo -u postgres createuser myusername`? – Alvaro Artano Jan 20 '21 at 16:29
@AlvaroArtano I did not im pretty sure the user got created – INuke Jan 20 '21 at 16:47
try to do `sudo psql` – Alvaro Artano Jan 20 '21 at 16:48

0 Answers0