How to test database cluster automatic failover and high availability

Hi @trarbr @trefore,

There is no option to test automatic failover to a standby node manually from your end.

All managed database clusters have automated failover, meaning they automatically detect and replace degraded or failing nodes. In order for the failover to happen, The database cluster will have primary and standby nodes.

The standby nodes maintain a copy of the primary node. In the event of a failure, The standby node is immediately promoted to primary and begins serving requests while a replacement standby node is provisioned in the background.

For more information on high availability: https://www.digitalocean.com/docs/databases/#high-availability

You can add standby nodes during cluster creation as well as to an existing database cluster.

The below link has information on how to add a standby node

https://www.digitalocean.com/docs/databases/postgresql/how-to/add-standby-nodes/

Regards, Rajkishore