PostgreSQL Error Reference

Every error, explained

SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.

3908 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3456 of 3908 errors

55000 FATAL

data directory “…” has invalid permissions — 55000

object_not_in_prerequisite_state

PostgreSQL error "data directory "…" has invalid permissions" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

record “…” is not assigned yet — 55000

object_not_in_prerequisite_state

PostgreSQL error "record "…" is not assigned yet" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

recovery is in progress — 55000

object_not_in_prerequisite_state

PostgreSQL error "recovery is in progress" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

could not get commit timestamp data — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not get commit timestamp data" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

parallel worker failed to initialize — 55000

object_not_in_prerequisite_state

PostgreSQL error "parallel worker failed to initialize" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

prepared transactions are disabled — 55000

object_not_in_prerequisite_state

PostgreSQL error "prepared transactions are disabled" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

WAL ends before end of online backup — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL ends before end of online backup" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

WAL level not sufficient for making an online backup — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL level not sufficient for making an online backup" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

the standby was promoted during online backup — 55000

object_not_in_prerequisite_state

PostgreSQL error "the standby was promoted during online backup" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

backup is not in progress — 55000

object_not_in_prerequisite_state

PostgreSQL error "backup is not in progress" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

WAL level not sufficient for creating a restore point — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL level not sufficient for creating a restore point" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

standby promotion is ongoing — 55000

object_not_in_prerequisite_state

PostgreSQL error "standby promotion is ongoing" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot use invalid database “…” as template — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot use invalid database "…" as template" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

some relations of database “…” are already in tablespace “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "some relations of database "…" are already in tablespace "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

cannot alter invalid database “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot alter invalid database "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot refresh materialized view “…” concurrently — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot refresh materialized view "…" concurrently" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

ALTER SUBSCRIPTION with refresh is not allowed for disabled subscri… — 55000

object_not_in_prerequisite_state

PostgreSQL error "ALTER SUBSCRIPTION with refresh is not allowed for disabled subscriptions" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot alter partition “…” with an incomplete detach — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot alter partition "…" with an incomplete detach" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

partition “…” already pending detach in partitioned table “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "partition "…" already pending detach in partitioned table "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot update view “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot update view "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot delete from view “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot delete from view "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot update table “…” because it does not have a replica identity… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot update table "…" because it does not have a replica identity and publishes updates" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot delete from table “…” because it does not have a replica ide… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot delete from table "…" because it does not have a replica identity and publishes deletes" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

postmaster became multithreaded during startup — 55000

object_not_in_prerequisite_state

PostgreSQL error "postmaster became multithreaded during startup" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State