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.

هل يمكنني تشغيل مهمة cron كمستخدم Postgres؟

الدعم تثبيت

Falco (Falco) 4 أكتوبر 2019، 7:18م 4

هل قرأت 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	3012	16 أغسطس 2019
Cron in docker container (Cannot make/remove an entry for the specified session) Support	2	2039	23 مايو 2020
Is it possible to login into the postgres database inside the docker image? Self-hosting	6	4656	26 يناير 2023
Pups::ExecError: su postgres -c 'psql discourse -c "alter schema public owner to discourse;"' failed with return Self-hosting	29	1999	12 فبراير 2023
Error altering user password when building Postgres container Self-hosting	2	270	26 يناير 2024

هل يمكنني تشغيل مهمة cron كمستخدم Postgres؟

الموضوعات ذات الصلة