terminating autovacuum process due to administrator command

Symptoms

A statement failed with SQLSTATE 57P01 (admin_shutdown), reported at severity FATAL. This is a Operator Intervention condition: PostgreSQL emits the message terminating autovacuum process due to administrator command.

• The client receives SQLSTATE 57P01 (admin shutdown).
• The operation is rejected at FATAL level; the statement does not complete.

What the server log shows

FATAL:  terminating autovacuum process due to administrator command

Why PostgreSQL raises this

Class 57 (Operator Intervention) is raised when an administrator action or server lifecycle event interrupts the session — shutdown, cancellation, or a forced termination.

As described in PostgreSQL’s Section 19.6 Error Handling and Appendix A (PostgreSQL Error Codes), SQLSTATE 57P01 carries the condition name admin_shutdown in class Operator Intervention. (Paraphrased — see the linked reference for the exact wording.)

Common causes

• The administrator cancelled the query or terminated the backend.
• The server is shutting down or in recovery.
• A statement or idle-in-transaction timeout fired.

How to fix it

1. Retry once the server is available again.
2. Investigate why the backend was cancelled/terminated.
3. Tune the relevant timeout if cancellations are unintended.

Version applicability

This message is present in PostgreSQL 15, 16, 17, 18 and 19.

Related & next steps

• SQLSTATE 57P01 — Admin Shutdown (full reference)
• PostgreSQL error code index

Reference: PostgreSQL Section 19.6 Error Handling.