PostgreSQL Error Reference

Every error, explained

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

3827 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3672 of 3827 errors

57P05 ERROR

Idle Session Timeout — SQLSTATE 57P05

idle_session_timeout

The session was closed after exceeding idle_session_timeout.

Operator Intervention
58000 ERROR

failed to send signal to postmaster: the OS error — 58000

system_error

PostgreSQL error "failed to send signal to postmaster: the OS error" (SQLSTATE 58000, system_error): what it means, common causes, and how to fix it.

System Error (errors external to PostgreSQL itself)
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 ERROR

strxfrm(), in locale “…”, writes past the specified array length — 58000

system_error

PostgreSQL error "strxfrm(), in locale "…", writes past the specified array length" (SQLSTATE 58000, system_error): what it means, common causes, and how to fix it.

System Error (errors external to PostgreSQL itself)
58030 ERROR

Io Error — SQLSTATE 58030

io_error

An operating-system I/O error occurred.

System Error
58030 ERROR

could not read block N in file “…”: read only 0 of N bytes — 58030

io_error

PostgreSQL error "could not read block N in file "…": read only 0 of N bytes" (SQLSTATE 58030): 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
58030 ERROR

could not fsync file “…”: Input/output error — 58030

io_error

PostgreSQL error "could not fsync file "…": Input/output error" (SQLSTATE 58030): what it means, common causes, and how to fix it.

System Error
58030 PANIC

could not fsync file “…” — 58030

io_error

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

System Error
58P01 ERROR

Undefined File — SQLSTATE 58P01

undefined_file

SQLSTATE 58P01 (undefined_file): An operating-system level error occurred (I/O or missing file).

System Error
58P01 ERROR

could not open file “…”: No such file or directory — 58P01

undefined_file

PostgreSQL error "could not open file "…": No such file or directory" (SQLSTATE 58P01): what it means, common causes, and how to fix it.

System Error
58P01 ERROR

directory “…” does not exist — 58P01

undefined_file

PostgreSQL error "directory "…" does not exist" (SQLSTATE 58P01, undefined_file): what it means, common causes, and how to fix it.

System Error (errors external to PostgreSQL itself)
58P02 ERROR

Duplicate File — SQLSTATE 58P02

duplicate_file

SQLSTATE 58P02 (duplicate_file): An operating-system level error occurred (I/O or missing file).

System Error
58P02 ERROR

directory “…” exists but is not empty — 58P02

duplicate_file

PostgreSQL error "directory "…" exists but is not empty" (SQLSTATE 58P02, duplicate_file): what it means, common causes, and how to fix it.

System Error (errors external to PostgreSQL itself)
58P03 ERROR

File Name Too Long — SQLSTATE 58P03

file_name_too_long

SQLSTATE 58P03 (file_name_too_long): An operating-system level error occurred (I/O or missing file).

System Error
72000 ERROR

Snapshot Too Old — SQLSTATE 72000

snapshot_too_old

PostgreSQL error SQLSTATE 72000 (snapshot_too_old): exists in PG9.6–16, removed in PG17 when old_snapshot_threshold was dropped.

Snapshot Too Old
F0000 ERROR

thesaurus sample word “…” is a stop word (rule n) — F0000

config_file_error

PostgreSQL error "thesaurus sample word "…" is a stop word (rule n)" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 FATAL

client certificates can only be checked if a root certificate store… — F0000

config_file_error

PostgreSQL error "client certificates can only be checked if a root certificate store is available" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

syntax error in file “…” line N, near token “…” — F0000

config_file_error

PostgreSQL error "syntax error in file "…" line N, near token "…"" (SQLSTATE F0000): what it means, common causes, and how to fix it.

Configuration File Error
F0000 FATAL

recovery ended before configured recovery target was reached — F0000

config_file_error

PostgreSQL error "recovery ended before configured recovery target was reached" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

Config File Error — SQLSTATE F0000

config_file_error

SQLSTATE F0000 (config_file_error): A configuration file is invalid.

Configuration File Error
F0000 ERROR

could not open synonym file “…”: the OS error — F0000

config_file_error

PostgreSQL error "could not open synonym file "…": the OS error" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

could not open thesaurus file “…”: the OS error — F0000

config_file_error

PostgreSQL error "could not open thesaurus file "…": the OS error" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

unexpected end of line or lexeme — F0000

config_file_error

PostgreSQL error "unexpected end of line or lexeme" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error