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:…

Can I run a cron job as user Postgres?

Falco (Falco) October 4, 2019, 7:18pm 4

5 Likes

Topic		Replies	Views
How to add a job to cron/anacron when creating Docker container Self-hosting	9	2968	August 16, 2019
Cron in docker container (Cannot make/remove an entry for the specified session) Support	2	2016	May 23, 2020
Is it possible to login into the postgres database inside the docker image? Self-hosting	6	4639	January 26, 2023
Pups::ExecError: su postgres -c 'psql discourse -c "alter schema public owner to discourse;"' failed with return Self-hosting	29	1868	February 12, 2023
Error altering user password when building Postgres container Self-hosting	2	245	January 26, 2024