Hi ,
Yes, you can use it. Create a bash script containing the pg_repack
command logic, then call this bash script from a PL/pgSQL function.
Finally, schedule this PL/pgSQL function using pg_cron as follows.
SELECT cron.schedule('pg_repack_job', '00 3 * * 1-5', $$SELECT repackfunc();$$);
*Muhamma
Hi
Respected Team
Is there any way to schedule a pg_repack job with pg_cron within the
instance ?
If yes then please please let me know the best approach to schedule it with
pg_cron within the instance.( not in bastion host)
your response is highly valuable
Regards.
Durga Mahesh
