Questions tagged [pg-cron]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
204 views

Restart master in physical replication

I have 2 servers involving master-slave replication (physical replication). I see the replication using select * from pg_replication_slots; there is a record saying : user : rep_user` application : ...
padjee's user avatar
  • 147
3 votes
1 answer
2k 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,...
Tom's user avatar
  • 357
0 votes
0 answers
546 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 ...
ennth's user avatar
  • 121
0 votes
1 answer
937 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 ...
ennth's user avatar
  • 121
0 votes
1 answer
2k 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 ...
ennth's user avatar
  • 121
0 votes
1 answer
186 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" ...
ennth's user avatar
  • 121
1 vote
2 answers
3k 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, ...
Oto Shavadze's user avatar