role does not exist PostgreSQL Origin: Data OSI layer 7 · Application Last updated 13 Oct 2026

FATAL: role "x" does not exist

PostgreSQL has no login role with that name.

Exact message you may see role does not exist
Seen on: PostgreSQL

Meaning

psql defaults to your OS username as the role. Fresh installs only have postgres; Homebrew installs create a role named after your macOS user.

Common causes

  • Connecting without -U (defaults to OS user)
  • Role never created
  • Docker image created a different POSTGRES_USER

⚡ Quick fix

  1. Connect as an existing role: psql -U postgres
  2. Create the role: CREATE ROLE app LOGIN PASSWORD '…'
  3. Check docker env POSTGRES_USER

Detailed fix by platform

PostgreSQL

  1. sudo -u postgres createuser --interactive --pwprompt app

How to diagnose

  1. Role — Which name?
  2. Roles — \du lists?

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1045 — MySQL ERROR 1045 (28000): Access denied for user (MySQL)10451130 — MySQL ERROR 1130 (HY000): Host 'x' is not allowed to connect to this MySQL server (MySQL)11301698 — MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost' (MySQL)169818456 — SQL Server: Login failed for user 'x'. (Error 18456) (SQL)1845628P01 — PostgreSQL: FATAL: password authentication failed for user (PostgreSQL)28P01caching_sha2_password — Authentication plugin 'caching_sha2_password' cannot be loaded (MySQL)caching_sha2_passwordORA-01017 — ORA-01017: invalid username/password; logon denied (SQL)ORA-01017role does…

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.