Postgres Pro
Downloads
Home   >   mailing lists

[MASSMAIL]Cron not running - Mailing list pgsql-general

From Lok P
Subject [MASSMAIL]Cron not running
Date
Msg-id CAKna9VY8nbwczgD3A22wrxWmnv-0PFWP3t681zt3Fgxp237PsQ@mail.gmail.com
Whole thread Raw
Responses Re: Cron not running
List pgsql-general
Tree view
Hello All,
In RDS postgres(version 15.4), we have scheduled partition maintenance through pg_partman and it's scheduled through pg_cron as below. The same script has been executed in dev and test environments, and we are seeing the cron job is scheduled in both environments because we see one record in table cron.job.

But we are not seeing any entries in cron.job_run_details for the test database and also partitions are not getting created/dropped as we have expected on the test database. So it means it's not running in one of the databases. Wondering why it is so, if we are missing anything? How to debug this issue ,find the cause if it's failing internally for some reason and fix it ?

select partman.create_parent(
   p_parent_table := 'TAB1',
   p_control := 'part_col',
   p_type := 'native',
   p_interval := '1 day',
   p_premake := 5,
   p_start_partition => '2024-02-01 00:00:00'
);

update partman.part_config set infinite_time_partitions = 'true' , retention = '1 months', retention_keep_table='true', retention_keep_index='true'
where parent_table = 'TAB1';

SELECT cron.schedule('@daily',partman.run_maintenance());

Regards
Lok

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Grants and privileges issue
Next
From: sud
Date:
Subject: Re: Grants and privileges issue