How do I fix the "Database Does Not Exist" error when connecting to PostgreSQL?

A Database Does Not Exist error like the following occurs when you try to connect to a database doesn’t exist in your specified cluster or to the wrong cluster:

psql: FATAL:  database "defaultdb" does not exist

If you are getting this error, first verify that you are using the correct hostname to connect by following How to Connect to PostgreSQL Database Clusters. Then, verify that you’ve created the database in your cluster of choice by following How to Manage PostgreSQL Users and Databases in a Database Cluster.

Related Topics

How do I fix the "Could Not Translate Hostname to Address" error when connecting to PostgreSQL?

Verify the hostname and check your local machine for DNS resolution issues.

How do I fix the pgvector "could not open extension control file" error?

Use the command CREATE EXTENSION vector; instead of pgvector.

How do I fix the pg_dumpall "permission denied for table pg_authid" error?

Add the –no-role-passwords flag to the pg_dumpall command.