PostgreSQL Error Reference

Every error, explained

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

3864 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3576 of 3863 errors

55000 ERROR

replication slots can only be used if wal_level >= replica — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slots can only be used if wal_level >= replica" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

logical decoding requires wal_level >= logical — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical decoding requires wal_level >= logical" (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 query or manipulate replication origin when max_replication_… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot query or manipulate replication origin when max_replication_slots = 0" (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 convert table “…” to a view because it is not empty — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not convert table "…" to a view because it is not empty" (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 convert table “…” to a view because it has indexes — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not convert table "…" to a view because it has indexes" (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 convert table “…” to a view because it has child tables — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not convert table "…" to a view because it has child tables" (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 convert table “…” to a view because it has parent tables — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not convert table "…" to a view because it has parent tables" (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 convert table “…” to a view because it has row security e… — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not convert table "…" to a view because it has row security enabled" (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 convert table “…” to a view because it has row security p… — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not convert table "…" to a view because it has row security policies" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

pg_log_standby_snapshot() can only be used if wal_level >= replica — 55000

object_not_in_prerequisite_state

PostgreSQL error "pg_log_standby_snapshot() can only be used if wal_level >= replica" (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 copy invalidated replication slot “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot copy invalidated replication slot "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

lost connection to the logical replication apply worker — 55000

object_not_in_prerequisite_state

PostgreSQL error "lost connection to the logical replication apply worker" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

logical replication parallel apply worker exited due to error — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical replication parallel apply worker exited due to error" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

lost connection to the logical replication parallel apply worker — 55000

object_not_in_prerequisite_state

PostgreSQL error "lost connection to the logical replication parallel apply worker" (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 send data to shared-memory queue — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not send data to shared-memory queue" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

logical decoding on standby requires wal_level >= logical on the pr… — 55000

object_not_in_prerequisite_state

PostgreSQL error "logical decoding on standby requires wal_level >= logical on the primary" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

pg_log_standby_snapshot() can only be used if “wal_level” >= “replica” — 55000

object_not_in_prerequisite_state

PostgreSQL error "pg_log_standby_snapshot() can only be used if "wal_level" >= "replica"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

incremental backups cannot be taken unless WAL summarization is ena… — 55000

object_not_in_prerequisite_state

PostgreSQL error "incremental backups cannot be taken unless WAL summarization is enabled" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

must UPLOAD_MANIFEST before performing an incremental BASE_BACKUP — 55000

object_not_in_prerequisite_state

PostgreSQL error "must UPLOAD_MANIFEST before performing an incremental BASE_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

manifest contains no required WAL ranges — 55000

object_not_in_prerequisite_state

PostgreSQL error "manifest contains no required WAL ranges" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

timeline n found in manifest, but not in this server’s history — 55000

object_not_in_prerequisite_state

PostgreSQL error "timeline n found in manifest, but not in this server's history" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

manifest requires WAL from initial timeline n starting at n/n, but… — 55000

object_not_in_prerequisite_state

PostgreSQL error "manifest requires WAL from initial timeline n starting at n/n, but that timeline begins at n/n" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

manifest requires WAL from continuation timeline n starting at n/n,… — 55000

object_not_in_prerequisite_state

PostgreSQL error "manifest requires WAL from continuation timeline n starting at n/n, but that timeline begins at n/n" (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 summaries are required on timeline n from n/n to n/n, but the s… — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL summaries are required on timeline n from n/n to n/n, but the summaries for that timeline and LSN range are incomplete" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State