Postgres Pro
Downloads
Home   >   mailing lists

Re: Scheduling pg_repack job with pg_cron - Mailing list pgsql-general

From Muhammad Imtiaz
Subject Re: Scheduling pg_repack job with pg_cron
Date
Msg-id CACW1Ly1PxOp_i30VLKBNLOius_ahXRx6RRoLVsHE5Rm1w+BUog@mail.gmail.com
Whole thread Raw
In response to Scheduling pg_repack job with pg_cron  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
List pgsql-general
Tree view
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();$$);





Muhammad Imtiaz
PostgreSQL Technical Support Lead / Pakistan R&D
Mobile: +923345072521


On Tue, Jul 30, 2024 at 1:58 PM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:
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

pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Scheduling pg_repack job with pg_cron
Next
From: Koen De Groote
Date:
Subject: Understanding conflicts on publications and subscriptions