Questions tagged [pg-cron]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
user avatar
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,...
user avatar
  • 285
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 ...
user avatar
  • 111
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 ...
user avatar
  • 111
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 ...
user avatar
  • 111
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" ...
user avatar
  • 111
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, ...
user avatar