How to configure local mail delivery

I have a separate server which hosts my database. Each night, a cron script is run to dump the databases contents and rsynced the backups to another server. The backup script will log the backup in /var/log, but also send a mail. Most of the time I’m using ssmtp to use my ISP SMTP server as a relay. However my database server most of th [...]