HV00N — fdw_unable_to_establish_connection
HV00N — fdw_unable_to_establish_connection
At a glance
HV00N is the SQL/MED condition for an FDW unable to establish its connection. No direct 18.6 core/contrib HV00N report group was resolved. Do not use the condition name to choose between DNS, authentication, TLS, network, or remote-server causes.
| Field | Value |
|---|---|
| SQLSTATE | HV00N |
| Condition | fdw_unable_to_establish_connection |
| Status | active |
| Known present by | 9.1.0 |
| Locked snapshots | 9.1.24, 9.2.24, 9.3.25, 9.4.26, 9.5.25, 9.6.24, 10.23, 11.22, 12.22, 13.23, 14.24, 15.19, 16.15, 17.11, 18.6, 19beta3 |
| Macros | ERRCODE_FDW_UNABLE_TO_ESTABLISH_CONNECTION |
| Aliases | — |
Meaning
The condition name describes a wrapper connection-setup boundary. postgres_fdw and dblink have their own concrete connection and libpq paths, but the 18.6 paths in this batch use other SQLSTATEs; they are not evidence for HV00N.
Messages and diagnostics
No fixed core message is confirmed. Preserve wrapper/driver version, foreign server and user mapping, connection parameters (excluding secrets), local and remote logs, and whether authentication or transport was reached.
Diagnosis
Locate the wrapper’s connection function and classify the first failing layer: name resolution, socket/TLS, authentication, protocol negotiation, or remote admission. Compare the wrapper’s SQLSTATE with any driver or remote code; they can differ.
Response
Correct the identified endpoint, credentials, network/TLS configuration, or server admission rule, then establish a fresh connection using the wrapper’s API. For writes, do not replay an operation until logs show whether a prior connection reached the remote command stage.
Versions
The code is in locked definitions from 9.1.0 through 18.6 and 19 Beta 3; available pre-9 definitions do not contain it. Exact implementation introduction is unknown.
Related
HV001 is a confirmed allocation path; HV00L concerns execution creation after setup; 08006 is a broader connection failure class.
Sources
errcodes.txt— definition, SHA-2566e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.fdwapi.h— callback boundary.- Structured evidence — bounded source scan.