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

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 ERROR

could not read block N in file “…” — 58030

io_error

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

System Error
58030 PANIC

could not write block N in file “…” — 58030

io_error

PostgreSQL error "could not write block N in file … — 58030" (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
58P03 ERROR

file name too long — 58P03

duplicate_file

PostgreSQL error "file name too long — 58P03" (SQLSTATE 58P03): what it means, common causes, and how to fix it.

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

snapshot too old — 72000

snapshot_too_old

PostgreSQL error "snapshot too old — 72000" (SQLSTATE 72000): what it means, common causes, and how to fix it.

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

unexpected end of line — F0000

config_file_error

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

Configuration File Error
F0000 ERROR

too many lexemes in thesaurus entry — F0000

config_file_error

PostgreSQL error "too many lexemes in thesaurus entry" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error