Re: Scheduling pg_repack job with pg_cron

Поиск
Список
Период
Сортировка
От Muhammad Imtiaz
Тема Re: Scheduling pg_repack job with pg_cron
Дата
Msg-id CACW1Ly1PxOp_i30VLKBNLOius_ahXRx6RRoLVsHE5Rm1w+BUog@mail.gmail.com
обсуждение исходный текст
Ответ на Scheduling pg_repack job with pg_cron  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления: