failed to start worker for pg_auto_failover health checks in "prod_db"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Postgres log reports "LOG: failed to start worker for pg_auto_failover health checks in "prod_db""

Environment

Product Version: 10.15

Resolution

This can be caused if the parameter "max_worker_processes" is set too low.
The setting can be changed by editing the postgresql.conf file for the database.

For details on the parameter see Background Worker Processes and max_worker_processes