Answers for "import sql postgres postgres ERROR: role "user" does not exist"

psql: error: FATAL: role "postgres" does not exist

createuser -U postgres -s YOURUSERNAME
createdb YOURUSERNAME

Posted by: Guest on January-09-2021

role "postgres" does not exist

template1=# CREATE USER username WITH PASSWORD 'user_password';
template1=# GRANT ALL PRIVILEGES ON DATABASE "user_database" to username;

Posted by: Guest on June-04-2021

Code answers related to "import sql postgres postgres ERROR: role "user" does not exist"