Fixing error - psql: FATAL: role “postgres” does not exist

fix-error-fatal-role-postgres-does-not-exist.md

Corrigindo o erro psql: FATAL: role “postgres” does not exist

1 - Instalar o postgresql

brew install postgresql

2 - Startar o postgresql

brew services start postgresql

Ao rodar o comando para acessar o postgresql:

psql -U postgres

E o erro for disparado: "psql: FATAL: role “postgres” does not exist"

Para corrigir:

/usr/local/Cellar/postgresql/<version>/bin/createuser -s postgres

ou

/usr/local/opt/postgres/bin/createuser -s postgres

Dessa forma é criado o usuário postgresql e você poderá ter acesso.

Thanks

Hi there. I spent a few hours trying to figure out what to do, your solution is the only one that has worked!

I am glad to help @kim-cchbc and @isuvorov1 =D

great. So simple so usefull!

it works perfectly!!!

This is a very good solution!!!

zsh: no such file or directory: /usr/local/opt/postgres/bin/createuser

Hey, I try and received the same error:

@ameer8f26 and @peteraramaldes It is located here:
/opt/homebrew/opt/postgresql@16/bin/createuser

@ameer8f26 and @peteraramaldes It is located here: /opt/homebrew/opt/postgresql@16/bin/createuser

yeah its working! thanks

Thank you!=)

Muito bom. Obrigado, me ajudou.

You saved my life :)

help me please, idk how to fix

thank youuuu

/usr/local/opt/postgresql@11/bin/createuser -s postgres try this
@mer4lf

For newer homebrew versions:

/opt/homebrew/opt/postgresql@16/bin/createuser -s postgres