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

The more “Discourse-way” of doing that would be creating a plugin with the queries as scheduled jobs. Check this example: app/jobs/scheduled/patreon_sync_patrons_to_groups.rb main # frozen_string_literal: true module ::Jobs class PatreonSyncPatronsToGroups < ::Jobs::Schedul…

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.

能否以用户 Postgres 运行 cron 作业？

支持安装

Falco (Falco) 2019 年10 月 4 日 19:18 4

Did you read How to add a job to cron/anacron when creating Docker container ?

话题		回复	浏览量
How to add a job to cron/anacron when creating Docker container Self-hosting	9	2990	2019 年8 月 16 日
Cron in docker container (Cannot make/remove an entry for the specified session) Support	2	2025	2020 年5 月 23 日
Is it possible to login into the postgres database inside the docker image? Self-hosting	6	4645	2023 年1 月 26 日
Pups::ExecError: su postgres -c 'psql discourse -c "alter schema public owner to discourse;"' failed with return Self-hosting	29	1927	2023 年2 月 12 日
Error altering user password when building Postgres container Self-hosting	2	254	2024 年1 月 26 日

能否以用户 Postgres 运行 cron 作业？

相关话题