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 528 of 578 errors

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

Io Error — SQLSTATE 58030

io_error

An operating-system I/O error occurred.

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

Undefined File — SQLSTATE 58P01

undefined_file

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

System Error
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
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 — 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
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

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 ERROR

Config File Error — SQLSTATE F0000

config_file_error

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

Configuration File Error
F0000 ERROR

unrecognized configuration parameter “…” — F0000

config_file_error

PostgreSQL error "unrecognized configuration parameter … — F0000" (SQLSTATE F0000): what it means, common causes, and how to fix it.

Config File Error
F0001 ERROR

Lock File Exists — SQLSTATE F0001

lock_file_exists

SQLSTATE F0001 (lock_file_exists): A configuration file is invalid.

Configuration File Error
F0001 FATAL

lock file “…” already exists — F0001

lock_file_exists

PostgreSQL error "lock file "…" already exists" (SQLSTATE F0001): what it means, common causes, and how to fix it.

Configuration File Error
F0001 FATAL

lock file “postmaster.pid” already exists — F0001

lock_file_exists

PostgreSQL error "lock file "postmaster.pid" already exists — F0001" (SQLSTATE F0001): what it means, common causes, and how to fix it.

Config File Error
HV000 ERROR

Fdw Error — SQLSTATE HV000

fdw_error

SQLSTATE HV000 (fdw_error): A foreign data wrapper (SQL/MED) operation failed.

Foreign Data Wrapper Error (SQL/MED)
HV001 ERROR

Fdw Out Of Memory — SQLSTATE HV001

fdw_out_of_memory

SQLSTATE HV001 (fdw_out_of_memory): A foreign data wrapper (SQL/MED) operation failed.

Foreign Data Wrapper Error (SQL/MED)
HV002 ERROR

Fdw Dynamic Parameter Value Needed — SQLSTATE HV002

fdw_dynamic_parameter_value_needed

SQLSTATE HV002 (fdw_dynamic_parameter_value_needed): A foreign data wrapper (SQL/MED) operation failed.

Foreign Data Wrapper Error (SQL/MED)
HV004 ERROR

Fdw Invalid Data Type — SQLSTATE HV004

fdw_invalid_data_type

SQLSTATE HV004 (fdw_invalid_data_type): A foreign data wrapper (SQL/MED) operation failed.

Foreign Data Wrapper Error (SQL/MED)
HV005 ERROR

Fdw Column Name Not Found — SQLSTATE HV005

fdw_column_name_not_found

SQLSTATE HV005 (fdw_column_name_not_found): A foreign data wrapper (SQL/MED) operation failed.

Foreign Data Wrapper Error (SQL/MED)