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

F0000 ERROR

thesaurus sample word “…” isn’t recognized by subdictionary (rule n) — F0000

config_file_error

PostgreSQL error "thesaurus sample word "…" isn't recognized by subdictionary (rule n)" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

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

config_file_error

PostgreSQL error "thesaurus substitute 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 ERROR

thesaurus substitute word “…” isn’t recognized by subdictionary (ru… — F0000

config_file_error

PostgreSQL error "thesaurus substitute word "…" isn't recognized by subdictionary (rule n)" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

thesaurus substitute phrase is empty (rule n) — F0000

config_file_error

PostgreSQL error "thesaurus substitute phrase is empty (rule n)" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid affix flag “…” — F0000

config_file_error

PostgreSQL error "invalid affix flag "…"" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

affix flag “…” is out of range — F0000

config_file_error

PostgreSQL error "affix flag "…" is out of range" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid character in affix flag “…” — F0000

config_file_error

PostgreSQL error "invalid character in affix flag "…"" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid affix flag “…” with “long” flag value — F0000

config_file_error

PostgreSQL error "invalid affix flag "…" with "long" flag value" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

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

config_file_error

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

Configuration File Error
F0000 ERROR

invalid affix alias “…” — F0000

config_file_error

PostgreSQL error "invalid affix alias "…"" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

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

config_file_error

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

Configuration File Error
F0000 ERROR

Ispell dictionary supports only “default”, “long”, and “num” flag v… — F0000

config_file_error

PostgreSQL error "Ispell dictionary supports only "default", "long", and "num" flag values" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

invalid number of flag vector aliases — F0000

config_file_error

PostgreSQL error "invalid number of flag vector aliases" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

number of aliases exceeds specified number n — F0000

config_file_error

PostgreSQL error "number of aliases exceeds specified number n" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

affix file contains both old-style and new-style commands — F0000

config_file_error

PostgreSQL error "affix file contains both old-style and new-style commands" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

could not open stop-word file “…”: the OS error — F0000

config_file_error

PostgreSQL error "could not open stop-word 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 parse contents of file “…” — F0000

config_file_error

PostgreSQL error "could not parse contents of file "…"" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

Configuration File Error
F0000 ERROR

configuration file “…” contains errors — F0000

config_file_error

PostgreSQL error "configuration file "…" contains errors" (SQLSTATE F0000, config_file_error): what it means, common causes, and how to fix it.

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 “…” is empty — F0001

lock_file_exists

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

Configuration File Error
F0001 FATAL

pre-existing shared memory block (key n, ID n) is still in use — F0001

lock_file_exists

PostgreSQL error "pre-existing shared memory block (key n, ID n) is still in use" (SQLSTATE F0001, lock_file_exists): 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