PostgreSQL Error Reference

Every error, explained

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

1011 errors documentedFree diagnostics on every pageAll PG versions covered

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.

Insufficient Resources
53300 ERROR

Too Many Connections — SQLSTATE 53300

too_many_connections

The server reached its connection limit and rejected the new connection.

Insufficient Resources
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...

Insufficient Resources
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.

Insufficient Resources
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.

Insufficient Resources
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.

Insufficient Resources
53400 ERROR

Configuration Limit Exceeded — SQLSTATE 53400

configuration_limit_exceeded

A configured resource limit was exceeded.

Insufficient Resources
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.

Insufficient Resources
54000 ERROR

Program Limit Exceeded — SQLSTATE 54000

program_limit_exceeded

A hard internal program limit was exceeded.

Program Limit 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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
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.

Program Limit Exceeded
54001 ERROR

Statement Too Complex — SQLSTATE 54001

statement_too_complex

The statement is too complex to process.

Program Limit Exceeded
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.

Program Limit Exceeded