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 3624 of 3908 errors

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
55000 ERROR

cannot set option “…” for a subscription that does not have a slot… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot set option "…" for a subscription that does not have a slot name" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

column “…” of relation “…” is not a generated column — 55000

object_not_in_prerequisite_state

PostgreSQL error "column "…" of relation "…" is not a generated column" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

replication slots can only be used if “…” > 0 — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slots can only be used if "…" > 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

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

replication slots can only be synchronized to a standby server — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slots can only be synchronized to a standby server" (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_active_repl… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot query or manipulate replication origin when "max_active_replication_origins" is 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

exiting from slot synchronization because same name slot “…” alread… — 55000

object_not_in_prerequisite_state

PostgreSQL error "exiting from slot synchronization because same name slot "…" already exists on the standby" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

replication slot synchronization will stop because promotion is tri… — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slot synchronization will stop because promotion is triggered" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

replication slot synchronization will not start because promotion w… — 55000

object_not_in_prerequisite_state

PostgreSQL error "replication slot synchronization will not start because promotion was triggered" (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 synchronize replication slots concurrently — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot synchronize replication slots 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

cannot set option “…” for enabled subscription — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot set option "…" for enabled subscription" (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 inherited constraint “…” on relation “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot alter inherited constraint "…" on relation "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State