Questions tagged [pg-cron]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
51 views

Query timeout inside a cron job

I'm running a cron job using pg_cron. The job is running some cleanup queries, that occasionally takes longer to complete. When that happens, the job fails on statement timeout of 2 min which is the ...
arik alon's user avatar
3 votes
2 answers
228 views

pg_cron: "policy ... for table ... already exists" error while restore postgres database from dump

I'm trying to restore postgresql database from dump on fresh new server. Source database uses pgcron extension, target server have pgcron extension installed. This is how I create dumps on "...
AntonioK's user avatar
  • 133
0 votes
0 answers
415 views

pg_cron jobs are not being executed

We have installed pg_cron extension on PostgreSQL 13 database. postgresql.conf file: shared_preload_libraries = 'pg_cron' cron.database_name = 'pg_cron_db_name' Also we enabled trust authentication ...
Lesya Klachko's user avatar
0 votes
0 answers
352 views

Executing remote procedures on a schedule using pg_cron

I need help figuring out how to execute remote procedures via db_link using pg_cron. Below is the code for creating a db_link, adding a procedure call to pg_cron, and checking that the procedure is ...
Yuriy Tigiev's user avatar
0 votes
0 answers
228 views

pg_cron is dramatically faster than running the same query manually

I have a simple table with 75 million rows (and roughly 47 million unique ref_ids) CREATE TABLE tbl ( id serial NOT NULL PRIMARY KEY, ref_id text NOT NULL, ts timestamp NOT NULL ); And I ...
perennial_'s user avatar
2 votes
1 answer
956 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
  • 177
1 vote
1 answer
657 views

pg_cron timezone issue, unable to run at specified time

Unable to run at proper timezone. I want to run two things bash scripts Stored procedure For both case I found it runs at the wrong time. Instead of 1 AM and 3 AM pg_cron runs at a different time. ...
Sheikh Wasiu Al Hasib's user avatar
3 votes
2 answers
4k 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
  • 428
0 votes
0 answers
768 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 ...
XxaemaethxX's user avatar
0 votes
1 answer
2k 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 ...
XxaemaethxX's user avatar
0 votes
1 answer
4k 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 ...
XxaemaethxX's user avatar
0 votes
1 answer
228 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" ...
XxaemaethxX's user avatar
1 vote
2 answers
6k 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