3D000 🐘 PostgreSQL

FATAL: database "x" does not exist

The connection names a database that isn’t on that server.

Seen on: PostgreSQL

Meaning

Not created yet, typo/case mismatch (PostgreSQL folds unquoted names to lowercase), or connecting with the username as the default database name.

Common causes

  • Database never created
  • Case mismatch ("MyApp" created with quotes)
  • psql defaulting to a database named after the user
  • Wrong server/environment

⚡ Quick fix

  1. createdb dbname
  2. Check \l in psql
  3. Specify the database explicitly: psql -d postgres

Detailed fix by platform

PostgreSQL

  1. sudo -u postgres createdb -O app appdb

How to diagnose

  1. Name — Exact name/case?
  2. Server — Right host?

🧠 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.