MIME-Version: 1.0
References: <CAJCZko+-+OwyfKcQ91BJKoaTKuTbqeQ5A3mhw7QneiGhQRCFsQ@mail.gmail.com>
In-Reply-To: <CAJCZko+-+OwyfKcQ91BJKoaTKuTbqeQ5A3mhw7QneiGhQRCFsQ@mail.gmail.com>
From: Muhammad Imtiaz <imtiazpg712@gmail.com>
Date: Tue, 30 Jul 2024 16:22:17 +0500
Message-ID: <CACW1Ly1PxOp_i30VLKBNLOius_ahXRx6RRoLVsHE5Rm1w+BUog@mail.gmail.com>
Subject: Re: Scheduling pg_repack job with pg_cron
To: Durgamahesh Manne <maheshpostgres9@gmail.com>
Cc: pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007ecd40061e7531b5"
Archived-At: <https://www.postgresql.org/message-id/CACW1Ly1PxOp_i30VLKBNLOius_ahXRx6RRoLVsHE5Rm1w%2BBUog%40mail.gmail.com>
Precedence: bulk

--0000000000007ecd40061e7531b5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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*
*Email: imtiaz.m@bitnine.net <imtiaz.m@bitnine.net>*


On Tue, Jul 30, 2024 at 1:58=E2=80=AFPM 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
>

--0000000000007ecd40061e7531b5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><font face=3D"arial, sans-serif">Hi ,=C2=A0<br></font><div=
><pre><div class=3D"gmail-dark gmail-bg-gray-950 gmail-rounded-md gmail-bor=
der-[0.5px] gmail-border-token-border-medium"><div class=3D"gmail-overflow-=
y-auto gmail-p-4" dir=3D"ltr"><code class=3D"gmail-!whitespace-pre gmail-hl=
js gmail-language-sql"><font face=3D"arial, sans-serif">Yes, you can use it=
. Create a bash script containing the pg_repack command logic, then call th=
is bash script from a PL/pgSQL function. Finally, schedule this PL/pgSQL fu=
nction using pg_cron as follows.<br>SELECT cron.schedule(&#39;pg_repack_job=
&#39;, &#39;00 3 * * 1-5&#39;, $$SELECT repackfunc();$$);
</font>


<table width=3D"180px" style=3D"font-family:Arial,Helvetica,sans-serif;whit=
e-space:normal;text-align:center;border-width:1px 2px 1px 1px;border-style:=
solid;border-color:rgb(255,255,255) rgb(216,216,216) rgb(255,255,255) rgb(2=
55,255,255)"><tbody><tr align=3D"center"><td style=3D"border:1px solid rgb(=
255,255,255)"><img src=3D"https://ci3.googleusercontent.com/mail-sig/AIorK4=
yAA065PNs0wTn63OKufwEq-K0rorlKQ3zGggLzUsOI5cf2JvOBaG3rALen-RF0aigXFyuy850" =
width=3D"96" height=3D"36"><br></td></tr></tbody></table><p style=3D"font-f=
amily:Arial,Helvetica,sans-serif;white-space:normal;line-height:1.2;margin-=
top:6pt;margin-bottom:6pt"><b><span style=3D"font-family:Arial;background-c=
olor:transparent;vertical-align:baseline"><font color=3D"#3d85c6">Muhammad =
Imtiaz</font></span></b></p><p dir=3D"ltr" style=3D"font-family:Arial,Helve=
tica,sans-serif;white-space:normal;line-height:1.2;margin-top:6pt;margin-bo=
ttom:6pt"><font color=3D"#3d85c6"><b><span style=3D"font-family:Arial;backg=
round-color:transparent;vertical-align:baseline"><font size=3D"2">PostgreSQ=
L Technical Support Lead=C2=A0</font></span></b><b><span style=3D"font-fami=
ly:Arial;background-color:transparent;vertical-align:baseline"><font style=
=3D"font-size:13.3333px">/ Pakistan R&amp;D<br></font></span></b></font></p=
><div style=3D"font-family:Arial,Helvetica,sans-serif;white-space:normal"><=
b><font face=3D"arial, sans-serif" color=3D"#3d85c6">Mobile: +923345072521<=
/font></b></div><div style=3D"font-family:Arial,Helvetica,sans-serif;white-=
space:normal"><b><font face=3D"arial, sans-serif" color=3D"#3d85c6">Email:=
=C2=A0<a href=3D"mailto:imtiaz.m@bitnine.net" target=3D"_blank">imtiaz.m@bi=
tnine.net</a></font></b></div>


</code></div></div></pre><h3></h3></div></div><br><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jul 30, 2024 at 1:58=E2=80=
=AFPM Durgamahesh Manne &lt;<a href=3D"mailto:maheshpostgres9@gmail.com">ma=
heshpostgres9@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex"><div dir=3D"ltr">Hi<div>Respected Team</div><div><br=
></div><div>Is there any way to schedule a pg_repack job with pg_cron withi=
n the instance ?</div><div><br></div><div>If yes then please please let me =
know the best approach to schedule=C2=A0it with pg_cron within=C2=A0the ins=
tance.( not in bastion host)=C2=A0</div><div><br></div><div>your response i=
s=C2=A0highly valuable</div><div><br></div><div>Regards.</div><div>Durga Ma=
hesh</div></div>
</blockquote></div>

--0000000000007ecd40061e7531b5--