PostgreSQL Error Reference

Every error, explained

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

578 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 504 of 578 errors

55P04 ERROR

Unsafe New Enum Value Usage — SQLSTATE 55P04

unsafe_new_enum_value_usage

A newly added enum value cannot be used yet in the same transaction.

Object Not In Prerequisite State
57000 ERROR

Operator Intervention — SQLSTATE 57000

operator_intervention

SQLSTATE 57000 (operator_intervention): The statement or session was canceled or terminated by timeout, admin, or shutdown.

Operator Intervention
57014 ERROR

canceling statement due to user request — 57014

query_canceled

PostgreSQL error "canceling statement due to user request" (SQLSTATE 57014): what it means, common causes, and how to fix it.

Operator Intervention
57014 ERROR

canceling statement due to statement timeout — 57014

query_canceled

PostgreSQL error "canceling statement due to statement timeout" (SQLSTATE 57014): what it means, common causes, and how to fix it.

Operator Intervention
57014 ERROR

canceling autovacuum task — 57014

query_canceled

PostgreSQL error "canceling autovacuum task — 57014" (SQLSTATE 57014): what it means, common causes, and how to fix it.

Operator Intervention
57014 ERROR

Query Canceled — SQLSTATE 57014

query_canceled

The statement was canceled — by a timeout or an explicit cancel.

Operator Intervention
57014 ERROR

canceling statement due to conflict with recovery — 57014

query_canceled

PostgreSQL error "canceling statement due to conflict with recovery — 57014" (SQLSTATE 57014): what it means, common causes, and how to fix it.

Operator Intervention
57P01 FATAL

Admin Shutdown — SQLSTATE 57P01

admin_shutdown

The connection was terminated by an administrator command or server shutdown.

Operator Intervention
57P01 FATAL

terminating connection due to administrator command — 57P01

admin_shutdown

PostgreSQL error "terminating connection due to administrator command — 57P01" (SQLSTATE 57P01): what it means, common causes, and how to fix it.

Operator Intervention
57P01 FATAL

terminating connection due to administrator command — 57P01

admin_shutdown

PostgreSQL error "terminating connection due to administrator command" (SQLSTATE 57P01): what it means, common causes, and how to fix it.

Operator Intervention
57P02 FATAL

terminating connection because of crash of another server process — 57P02

crash_shutdown

PostgreSQL error "terminating connection because of crash of another server process" (SQLSTATE 57P02): what it means, common causes, and how to fix it.

Operator Intervention
57P02 PANIC

Crash Shutdown — SQLSTATE 57P02

crash_shutdown

SQLSTATE 57P02 (crash_shutdown): The statement or session was canceled or terminated by timeout, admin, or shutdown.

Operator Intervention
57P03 FATAL

the database system is shutting down — 57P03

cannot_connect_now

PostgreSQL error "the database system is shutting down" (SQLSTATE 57P03): what it means, common causes, and how to fix it.

Operator Intervention
57P03 WARNING

requested checkpoint not completed because recovery is still in progress — 57P03

cannot_connect_now

PostgreSQL error "requested checkpoint not completed because recovery is still in progress — 57P03" (SQLSTATE 57P03): what it means, common causes, and how to fix it.

Operator Intervention
57P03 FATAL

the database system is in recovery mode — 57P03

cannot_connect_now

PostgreSQL error "the database system is in recovery mode" (SQLSTATE 57P03): what it means, common causes, and how to fix it.

Operator Intervention
57P03 FATAL

the database system is starting up — 57P03

cannot_connect_now

PostgreSQL error "the database system is starting up — 57P03" (SQLSTATE 57P03): what it means, common causes, and how to fix it.

Operator Intervention
57P03 FATAL

the database system is starting up — 57P03

cannot_connect_now

PostgreSQL error "the database system is starting up" (SQLSTATE 57P03): what it means, common causes, and how to fix it.

Operator Intervention
57P03 ERROR

Cannot Connect Now — SQLSTATE 57P03

cannot_connect_now

The server is not yet ready to accept connections.

Operator Intervention
57P04 ERROR

Database Dropped — SQLSTATE 57P04

database_dropped

The connected database was dropped.

Operator Intervention
57P05 ERROR

Idle Session Timeout — SQLSTATE 57P05

idle_session_timeout

The session was closed after exceeding idle_session_timeout.

Operator Intervention
57P05 FATAL

terminating connection due to idle-session timeout — 57P05

idle_session_timeout

PostgreSQL error "terminating connection due to idle-session timeout — 57P05" (SQLSTATE 57P05): what it means, common causes, and how to fix it.

Operator Intervention
58000 ERROR

System Error — SQLSTATE 58000

system_error

SQLSTATE 58000 (system_error): An operating-system level error occurred (I/O or missing file).

System Error
58000 WARNING

archive command failed with exit code N — 58000

system_error

PostgreSQL error "archive command failed with exit code N — 58000" (SQLSTATE 58000): what it means, common causes, and how to fix it.

System Error
58030 ERROR

could not create file “…”: Permission denied — 58030

io_error

PostgreSQL error "could not create file "…": Permission denied" (SQLSTATE 58030): what it means, common causes, and how to fix it.

System Error