I have a number of queries that need to run each night. I thought that I could do the following:
cd /var/discourse
./launcher enter app
su postgres
crontab -e
... add my tasks and save ...
but, I get an error:
postgres@EN-Discourse-Forums-app:~$ crontab -e
crontab: installing new crontab
crontab: crontabs/postgres: rename: Operation not permitted
crontab: edits left in /tmp/crontab.7kGYwA/crontab
Potentially, yes, but this doesn’t let others who may need to change the behavior of these queries and our servers use something they understand. It is very common to use CRON to run queries.