B93: Terminating walreceiver process due to administrator command

Category: Standby Server Events
SQLSTATE: 57P01 (Class 57 — Operator Intervention: admin_shutdown)
Urgency: low

Example Postgres Log Output:

FATAL: terminating walreceiver process due to administrator command

Explanation:

This log message indicates that streaming replication has been stopped.

You may see this when an operator / DBA calls pg_terminate_backend on the walreceiver process responsible for streaming replication, or Postgres decides that streaming replication should be stopped, e.g. during server shutdown.

Note that streaming replication will attempt to restart after the walreceiver was stopped, so this is commonly only useful to force a reconnect of the secondary to the primary.

Recommended Action:

No action needed, although if unexpected during regular operations it makes sense to verify that streaming was started up again by checking for B91 - Started streaming WAL from primary.

Learn More:

No additional resources available.


Download Free eBook: The Top 6 Postgres Log Events
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →