Questions tagged [pg-cron]
The pg-cron tag has no usage guidance.
7
questions
0
votes
0
answers
22
views
Pg Cron and cron expression
I have a trigger that is executing an insert by pgcron, but I have a problem, I am not able to make the insert work with the following cron expression:
*/30 8-22 * * *
I tested it with this ...
0
votes
1
answer
248
views
Use pg_cron to run VACUUM on multiple tables
Reading the pg_cron documentation I saw that the examples only execute a command when scheduling a task.
In a StackOverflow post I saw that a user tried to run multiple VACUUM when scheduling the task,...
0
votes
0
answers
215
views
Schedule Postgres pg_cron jobs to trigger by something other than Cron expression
I have some pg_cron jobs that run at night time. They basically run some plpgsql Procedures and trigger based off CRON expressions.
The problem is that some of my JOBS are dependent on the jobs that ...
0
votes
1
answer
169
views
How to deal with 'failed' pg_cron jobs (postgres)
I have some Jobs (postgres plpgsql procedures) that I am scheduling using pg_cron library/extension and cron expressions.
I have some scripts that have failed and thus logged the 'failed' status ...
0
votes
1
answer
463
views
Runnig pg_cron jobs on different database and non-public schema says "No procedure matches the given name and argument types"
I'm running pg_cron jobs that of course runs from the default postgres db.
I have some functions/procedures that I created in another database called test, and have ran assigned these pg_cron jobs to ...
0
votes
1
answer
39
views
Deleting records from two-child tables in parallel (concurrently)
I have a postgres database where I am using the pg_cron extension to automatically perform some database "maintenance" at night time - Specifically, my database has some "offers" ...
1
vote
2
answers
974
views
"connection failed" error for pg_cron extension
Installed pg_cron and scheduled job, though there is connection error because job is not done and cron.job_run_details table shows connection failed error message.
As doc says:
Important: Internally, ...