On Thu, Mar 28, 2024 at 5:28 PM Lok P <loknath...@gmail.com> wrote:
> 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 ? > Permissions is the first possibility. Have you checked the RDS logs? >
