Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sWbfZ-00GC6c-2C for pgsql-in-general@arkaria.postgresql.org; Wed, 24 Jul 2024 13:04:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sWbfX-004gbq-Fx for pgsql-in-general@arkaria.postgresql.org; Wed, 24 Jul 2024 13:04:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sWbfX-004gbb-8j for pgsql-in-general@lists.postgresql.org; Wed, 24 Jul 2024 13:04:35 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sWbfU-001Cha-Ij for pgsql-in-general@postgresql.org; Wed, 24 Jul 2024 13:04:34 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-52efdf02d13so6388173e87.2 for ; Wed, 24 Jul 2024 06:04:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721826271; x=1722431071; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=OyoAcR4IKGS8Gchyr/sB6ib9PJFaia6ESbVSmSdiwao=; b=Q03F0127pd8t0aQjMSzJsSbMhdb4j20giwWaSqCHhZ09aUNQTZFUCwODDJvHbBEOwV pSblRTb2KKsm8Wbx54iQrsvhHa6ORqV6bRnj0zMYNnWg6rJ1ktMdXh9SnMGsVTGKGT7q QXODOxEQQZkDMRgV6tjZNszW/nrX01Icy8ztImnhZUcozjihjloc/TGeipgTQy96MlKe dbBksRQpRUG/MntCKMCw6Cj6PBV4zXcxLYpAQEkJaYUBaz3THv0Pk+r6tL6tplVH906T CquoUa4bGzEM0ZNqquJKotf97QusORFG6K7E72c+hJtXWoq647eEVJ6gsBSeGM/bomFQ t15A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721826271; x=1722431071; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=OyoAcR4IKGS8Gchyr/sB6ib9PJFaia6ESbVSmSdiwao=; b=xR/fCSEqU0+oWt9NF9C8IlU8brKBIcOd3+D33eMOYsLChMReWctM4v/TNqYJTkgdRb Ag9saWCLGssYTRhMp0JzBf/NrDubWKbLXNSTECUgCxODNVan6cz8K/TcV0MMKghMpRnc N1D2oK0UNP5UzLGNii5vXzXyVzhGtAx5NrW3tbU4L5gfHKsuhssd87YjfABDBUo1+ij4 /iAQgYYQa7PmtcuLI1gxzqv/4wltmWbknhKpG2977JuGBJKGuq6hL/m2rrS/NZ7c6W67 GJ1e+steWPTmaYdIPdk4RDjfqYJ79QXrT7eJcgXLjdga/RIQoK78bVbZttWgZoHGmvAT eOPA== X-Forwarded-Encrypted: i=1; AJvYcCUYQdc1r1QwRkIoMuhD+0GEBu2iagTRLWKItbUdyvboMXA5+PIxeatlSo1nGAwnhgekF0FdGy1C4p73A7RvTnUZUxwt41068tMOUo0Vi+jg X-Gm-Message-State: AOJu0YzE6RCBw3p3jZcX3YqXsWrFi/ZnvKCH5a+RSuBjqNz4om/aQ2a7 12kGyleHQxb1wq6gUD707K3obFmF2Vk3jZnlK43f2fSDjeh5O73giJjL94dKYxM1sQeUtZiFaPY GIQhSHjeAiM8bo1VRo1/YXWuZ1JWc+PVC X-Google-Smtp-Source: AGHT+IGYYdF+3r0aJopRRPnlR1eBIyaMqxGddNvlfqfrVbPyYU3n3ef81GwEPNGt8uD+czf0af5xaOKw4IoXYphU2vQ= X-Received: by 2002:a05:6512:1388:b0:52e:716a:1898 with SMTP id 2adb3069b0e04-52fcdaa8eb3mr2526780e87.58.1721826270361; Wed, 24 Jul 2024 06:04:30 -0700 (PDT) MIME-Version: 1.0 From: Durgamahesh Manne Date: Wed, 24 Jul 2024 18:35:46 +0530 Message-ID: Subject: pg_repack job scheduling with pg_cron To: pgsql-general@lists.postgresql.org, pgsql-in-general@postgresql.org Content-Type: multipart/alternative; boundary="00000000000035c1df061dfdeba5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000035c1df061dfdeba5 Content-Type: text/plain; charset="UTF-8" Hi Respected Team I have tried to setup pg_repack job with pg_cron but i could not implement it properly Is there any way to schedule pg_repack job with pg_cron ? 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 --00000000000035c1df061dfdeba5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi
Respected Team

I have trie= d to setup pg_repack job with pg_cron but i could not implement it properly=

Is there any way to schedule pg_repack job with p= g_cron ?

If yes then please please let me know the= best approach to schedule=C2=A0it with pg_cron within=C2=A0the instance.( = not in bastion host)=C2=A0

your response is=C2=A0h= ighly valuable

Regards.
Durga Mahesh

--00000000000035c1df061dfdeba5--