This gist lists the systemd units, timers, and scripts I am running to maintain my various services.
Data are backed up in an S3 compatible data store. To add a service using a database, just add the service name and database to the services.json
file.
The backup runs as the backup
user, which has read-only access to all databases. This is ensured by giving the appropriate role:
GRANT pg_read_all_data TO backup;