Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 864 of 1011 errors
53200
ERROR
not enough shared memory for data structure “…” (…d bytes requested) — 53200
out_of_memory
PostgreSQL error "not enough shared memory for data structure "…" (…d bytes requested)" (SQLSTATE 53200, out_of_memory): what it means, common causes, and how to fix it.
53300
ERROR
Too Many Connections — SQLSTATE 53300
too_many_connections
The server reached its connection limit and rejected the new connection.
53300
FATAL
remaining connection slots are reserved for non-replication superuser connections — 53300
too_many_connections
PostgreSQL error "remaining connection slots are reserved for non-replication superuser connections" (SQLSTATE 53300): what it means, common causes, and...
53300
FATAL
sorry, too many clients already — 53300
too_many_connections
PostgreSQL error "sorry, too many clients already" (SQLSTATE 53300): what it means, common causes, and how to fix it.
53300
FATAL
too many connections for role “…” — 53300
too_many_connections
PostgreSQL error "too many connections for role "…"" (SQLSTATE 53300): what it means, common causes, and how to fix it.
53300
FATAL
too many connections for database “…” — 53300
too_many_connections
PostgreSQL error "too many connections for database "…"" (SQLSTATE 53300): what it means, common causes, and how to fix it.
53400
ERROR
Configuration Limit Exceeded — SQLSTATE 53400
configuration_limit_exceeded
A configured resource limit was exceeded.
53400
ERROR
temporary file size exceeds temp_file_limit (N kB) — 53400
configuration_limit_exceeded
PostgreSQL error "temporary file size exceeds temp_file_limit (N kB)" (SQLSTATE 53400): what it means, common causes, and how to fix it.
54000
ERROR
Program Limit Exceeded — SQLSTATE 54000
program_limit_exceeded
A hard internal program limit was exceeded.
54000
ERROR
index row size N exceeds maximum N for index “…” — 54000
program_limit_exceeded
PostgreSQL error "index row size N exceeds maximum N for index "…"" (SQLSTATE 54000): what it means, common causes, and how to fix it.
54000
ERROR
row is too big: size N, maximum size N — 54000
program_limit_exceeded
PostgreSQL error "row is too big: size N, maximum size N" (SQLSTATE 54000): what it means, common causes, and how to fix it.
54000
ERROR
target lists can have at most N entries — 54000
program_limit_exceeded
PostgreSQL error "target lists can have at most N entries" (SQLSTATE 54000): what it means, common causes, and how to fix it.
54000
ERROR
cannot extend file “…” beyond n blocks — 54000
program_limit_exceeded
PostgreSQL error "cannot extend file "…" beyond n blocks" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
ERROR
invalid message size …u in shared memory queue — 54000
program_limit_exceeded
PostgreSQL error "invalid message size …u in shared memory queue" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
ERROR
cannot send a message of size …u via shared memory queue — 54000
program_limit_exceeded
PostgreSQL error "cannot send a message of size …u via shared memory queue" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
FATAL
out of on_shmem_exit slots — 54000
program_limit_exceeded
PostgreSQL error "out of on_shmem_exit slots" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
FATAL
out of before_shmem_exit slots — 54000
program_limit_exceeded
PostgreSQL error "out of before_shmem_exit slots" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
FATAL
out of on_proc_exit slots — 54000
program_limit_exceeded
PostgreSQL error "out of on_proc_exit slots" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
ERROR
cannot extend relation … beyond n blocks — 54000
program_limit_exceeded
PostgreSQL error "cannot extend relation … beyond n blocks" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
ERROR
could not find free replication origin ID — 54000
program_limit_exceeded
PostgreSQL error "could not find free replication origin ID" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
FATAL
database connection requirement not indicated during registration — 54000
program_limit_exceeded
PostgreSQL error "database connection requirement not indicated during registration" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54000
ERROR
joins can have at most n columns — 54000
program_limit_exceeded
PostgreSQL error "joins can have at most n columns" (SQLSTATE 54000, program_limit_exceeded): what it means, common causes, and how to fix it.
54001
ERROR
Statement Too Complex — SQLSTATE 54001
statement_too_complex
The statement is too complex to process.
54001
ERROR
stack depth limit exceeded — 54001
statement_too_complex
PostgreSQL error "stack depth limit exceeded" (SQLSTATE 54001): what it means, common causes, and how to fix it.