Postgres stopped running, is there a way I can get alerts if this happens?

Then you would need to check postgres logs to find out why it crashes.

Hello there,

The best place to start is to check the server logs. This can shed more light on why the service was stopped.

You can create a simple script to check if Postgresql is running and if not to start the service.

#!/bin/bash

# Check if MySQL is running
sudo systemctl status postgresql.service > /dev/null 2>&1

# Restart the MySQL service if it's not running.
if [ $? != 0 ]; then
    sudo systemctl start postgresql.service
fi

Regards