PostgreSQL Error Reference

Every error, explained

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

3910 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 48 of 3910 errors

08006 ERROR

SSL connection has been closed unexpectedly — 08006

connection_failure

PostgreSQL error "SSL connection has been closed unexpectedly" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not receive data from server: Connection timed out — 08006

connection_failure

PostgreSQL error "could not receive data from server: Connection timed out" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

connection to server at “…”, port … failed — 08006

connection_failure

PostgreSQL error "connection to server at "…", port … failed" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not connect to server: Connection refused — 08006

connection_failure

PostgreSQL error "could not connect to server: Connection refused" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

server closed the connection unexpectedly — 08006

connection_failure

PostgreSQL error "server closed the connection unexpectedly" (SQLSTATE 08006): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not connect to publisher when attempting to drop replication… — 08006

connection_failure

PostgreSQL error "could not connect to publisher when attempting to drop replication slot "…": …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

unexpected EOF on client connection with an open transaction — 08006

connection_failure

PostgreSQL error "unexpected EOF on client connection with an open transaction" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not drop replication slot “…” on publisher: … — 08006

connection_failure

PostgreSQL error "could not drop replication slot "…" on publisher: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not receive list of replicated tables from the publisher: … — 08006

connection_failure

PostgreSQL error "could not receive list of replicated tables from the publisher: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

terminating walreceiver due to timeout — 08006

connection_failure

PostgreSQL error "terminating walreceiver due to timeout" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not send end-of-streaming message to primary: … — 08006

connection_failure

PostgreSQL error "could not send end-of-streaming message to primary: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

error while shutting down streaming COPY: … — 08006

connection_failure

PostgreSQL error "error while shutting down streaming COPY: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not receive data from WAL stream: … — 08006

connection_failure

PostgreSQL error "could not receive data from WAL stream: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not send data to WAL stream: … — 08006

connection_failure

PostgreSQL error "could not send data to WAL stream: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not fetch table info for table “…” from publisher: … — 08006

connection_failure

PostgreSQL error "could not fetch table info for table "…" from publisher: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not fetch column list info for table “…” from publisher: … — 08006

connection_failure

PostgreSQL error "could not fetch column list info for table "…" from publisher: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not start initial contents copy for table “…”: … — 08006

connection_failure

PostgreSQL error "could not start initial contents copy for table "…": …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

table copy could not start transaction on publisher: … — 08006

connection_failure

PostgreSQL error "table copy could not start transaction on publisher: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

table copy could not finish transaction on publisher: … — 08006

connection_failure

PostgreSQL error "table copy could not finish transaction on publisher: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

terminating logical replication worker due to timeout — 08006

connection_failure

PostgreSQL error "terminating logical replication worker due to timeout" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 FATAL

connection to client lost — 08006

connection_failure

PostgreSQL error "connection to client lost" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not connect to the publisher: … — 08006

connection_failure

PostgreSQL error "could not connect to the publisher: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

could not connect to the primary server: … — 08006

connection_failure

PostgreSQL error "could not connect to the primary server: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception
08006 ERROR

subscription “…” could not connect to the publisher: … — 08006

connection_failure

PostgreSQL error "subscription "…" could not connect to the publisher: …" (SQLSTATE 08006, connection_failure): what it means, common causes, and how to fix it.

Connection Exception