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 1qoH8E-000itx-Ev for pgsql-admin@arkaria.postgresql.org; Thu, 05 Oct 2023 05:42:43 +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 1qoH8C-0095Uo-CJ for pgsql-admin@arkaria.postgresql.org; Thu, 05 Oct 2023 05:42:41 +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 1qoH8B-0095T5-K4 for pgsql-admin@lists.postgresql.org; Thu, 05 Oct 2023 05:42:40 +0000 Received: from sonic310-12.consmr.mail.ir2.yahoo.com ([77.238.177.33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qoH89-00062q-PY for pgsql-admin@lists.postgresql.org; Thu, 05 Oct 2023 05:42:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1696484554; bh=z6ybPXg6Q3xtqgNp6Tr9r6IFojAQBD/WamvlVDaha/g=; h=Date:Subject:To:References:From:In-Reply-To:From:Subject:Reply-To; b=XNUGIF8GYiDp9awVlF0LH/foBy3+5cpzt2nJsSMasoiFPzdG8eCuZAkkAIhG2gPGuD6MNQVQoHQoPE9xPXG2Spq3BsW3UOfAuiRARLaOwscpx4dQj1k2SdEElyKU9SHhFNMb/aHLrHUEhcvweJzJLdpFgQjDcVm3IRNrHBRE9/R7HuQ8YY12MuU715gm8SUUWATcOSYw1ECtqcJlA+aDVNxpkgDxoFjAS3WjEfTWRBo8DrALkJcw4Kqz9Rpm3jcQQuPB5sshjciR7FcdnQif9TaeP28bmzI6WCu2EOuGFQF0jHBFy8GJS5HOoaRHzWziaUuIi2RjUbkKmy0nwcHa+Q== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1696484554; bh=OcSj8MHh5EIvFphTSEeO+7Yb/WvHbb02o++WY0t7Qyc=; h=X-Sonic-MF:Date:Subject:To:From:From:Subject; b=kJu6G1v2PWGLWDiIsj6rC+xJg3ui5egvHbEjWJDVL1cscVZKv5EApvAelgrZuO8uGymFDmUX6VAGcwbE6FJD7PNpGEWWMms4pZC8Nq+Zye1u2AoeKBR4WPHJ5tUq9juyONZ5pFOW9cwS7G3omfLlMey+pIPxJbr34WfnrfCONOlkifMB6kVeFig09OGtrPylgGQ8hgunBXCEAKLWVa3aJ0dq6cpkm253NFeTwv/1OUrAVeUM0d+lcxbaGVFBNFeoly5sQbEACJcQKyniOfwA7xCOCPbprEsqRDxNM6dNq5d03VUwB091x3cCbPjAv+gLwVuwC3Nf5O5WVBHISTRLzg== X-YMail-OSG: efZZ5kkVM1mI4wiFrK1vouXlV7H8B7jJI66zZFn6TEtVBySNJ988JFQmMT1Xh3t dJqYxuiDXNX_h.HmIrYiOqU.7Ve3rx6YC07Ffepj3f.786t2J_v4eu9Ol7cnARw50zU5Z_6ilkJn pB13xpqiEua03hnX_MCd9KXfm30gkewIOUxuVPzU_BSPdwxxE1PHt_QDZlKKMrJZKeHZ6zryJkge iFqe4w3hOCFLMZ9AiZng8m2DmkRUs1vHbozZcjTEntij9trPlF1bAW4AjO.8VHCPvrVu_bU8Qqsv UZ3xnKifqa0bfhh4IbcLY_ipHRWohzYSxhrQoK7NiQUcriCxB3PCEJwBRDeaSgfcLWg3SeL3hjK8 qVnl7bzPFMCk1tLOZExgBjhvXrc4Sh_TtV_mgCV89qEC9vPCjQIJmX946.5T6rQlxhe0vrc2RdRC K_tXCiYovqzC.PDSYbgxZJKtO660fgknCcDpHRfKDGcZRXmgEh0p6xTsozf7_m5XQFKtT1nmeiQB GYosriiuTo6cEZlVT7gvtSud.eBmmuDE4.TWQlPoFaO4989lIJ5P0BAsoEMvnhMlm7cP37HD4GpU 4BpC8lgRKKv.R.uquCE1L2U.Df2pmCxzjTISQBzfpsl0Gyc2xqoW7usN9k4OtsPHQ6khRAHMjGl4 84vzzKnIiAX0S9wfWd12lLqXmzyP.CHY.3KXrZLQ9mq7LWSPccZPdpRunrrVVgsqkTYBsqb9d5wx r_FHVFTRr2hKzaHRLOoG0TV9u75zluEfO7DxYB06UQ8MTlDyZpX0vPj0nLaPmf1Lk.kd8X_z3aTo THAlzThi8SNLipgRTytKzxbFLfopI32LUh8L0pBNbVQZjSJlkk8_zh3if.x3Fpzp3n5h2Mj6ezyV 8cs1ycQ4jxghWS5g1QLCMobl37GRwHluyOmwq8waX5PArLYP2lFeJlAd_navzBXZeKThvNd_4gyN BFirxgtdQkXkcVdxXVVN12wN8w0n9Eawvqb5SsLMjDPkXNmjBEEiAzaiRjqtpwCKYslI1lXpJHMQ cyMYp99WWNVugeJ2s59RPDrHv6jAjiYBsRnMP6f.bzZwZpNKs.Kb06Jlu8BxrWM4jzuiqANE.jVZ YzUE_xQvmztbEO2ydIt3VlTllmYB.9m_Dh9SQNjo949ed.mjfvx2C0qFZss0gCqdx_B_LDNVWTmG 8cyVkXCgmFqJ5LXyok2N5z_BjDqm2nBgg3sCuVCXrmGIo7EXfdtttE.nQJ._7YCdfvxTe6f74Ja. Iqeqp1_SvBa8UO_G7KOU.FyELkQTp2wr6U0rJAZDH3KDukJOm57qJ.Ga8Y4ENIwQ5npdCFV6qzxG yinRcHD1vTxtSwHONLtzV_PRvjVwyn6ca_DyeUAegh_qpV7Fx.fNDasE13Qiy8fccjovACJKc8aX .yK3CFlqb6St3oURo4EzEAaYV6imJMThe_.anPwQxs0mQHoafv6.LTzGq1.jSjGKPTPebEm.MIZA hWwPBh8.KMEueZaqHdK6gOCzChKYx_Vj5ZGz5m1wcn5JMFjPY4Pjv2tgVKqmgnip3zCsEJu22i6F .URyGONY8R0S.gqUgdqdD7L70EaYPp5h2e4zXinqOtu3Bo8_OTOAw_uV1ef5v8YPlwpPsSXz4Pt. uQuzWZGGfVlZooNVmZwjTGmILk_E5TvViazBokscopf4s7nAUeYhOa9NbjOGUvT3Z5rFSzVhEIlL ROKlPtYa3Y5IZX_PBixgCLBrie_6y710GVz1zhQrVKT5pKI9kxk__5rwqt8cq9ZcZLV3X4LH0aE6 ML9bCClNAVBlb040tS159GFSzJFP0R3DUtDBTVi6NTsOsXZnG97fZYeOAMRfooAq03.jLR9kzyZU zpG_Qwexrz6AJTU3gywMSJfOjMAF02bMxel7jYonFA9OgVg8fKedu5qTQTIVeakq1SL_BGAfAlwy axbZN74ZLa2C_OEe_pTn_X9wIo3yffcWJ2o0NM7YR_M_1_4VYaAVLo9a1cEvge_69ipX4ZOJQ1hd v_DP8ZhsANA471Fh6ECCy7.jVVZgzw4D3k.ArGcrVUnrOPJu3pjjV02Mi96auc5OLxW.oavTp7LL 2s.lmEP5u6FwcMKUU4B16xO1swtZ5g7w5TRdX7hGrZddrgdGdFGPv21n1XdqNKl6YNF_EjTAaARI q60Hu90OZ0zI3kKf27YbGpnXRRc2BqiowOA9ANjVurlhbF3eS10YNpidi0Eem X-Sonic-MF: X-Sonic-ID: 8a1b805c-4809-40aa-8a05-a70cde3bfd29 Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.ir2.yahoo.com with HTTP; Thu, 5 Oct 2023 05:42:34 +0000 Received: by hermes--production-ir2-788446cff9-z79jl (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID 70acd25a6aa5520c9bafa99a6b60c7eb; Thu, 05 Oct 2023 05:42:30 +0000 (UTC) Content-Type: multipart/alternative; boundary="------------oueKxxIMCxvHKZT17GqwA1D8" Message-ID: <57ab4200-e8e8-4cb3-aaf3-f7a7f02ffcd4@yahoo.com> Date: Thu, 5 Oct 2023 07:42:29 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Pg_cron not working To: pgsql-admin@lists.postgresql.org References: <3uz7ukefhsf3fho4q33adsczgdi4tzfuwhecgdooxtwrohufkh@e77ufwbtxadx> From: Marian Wendt In-Reply-To: X-Mailer: WebService/1.1.21797 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Content-Length: 3678 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------oueKxxIMCxvHKZT17GqwA1D8 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit > There is already an entry for > all all MD5. > On top of that , how do I add trust ? > > On Thu, 21 Sept 2023, 15:55 Erik Wienhold, wrote: > > On 2023-09-21 13:52 +0530, Rajesh Kumar wrote: > > I have installed pg_cron but the schedule seems not to be working. > > How did you install it?  What have you configured so far? > > > Anybody knows, how to configure pg_hba.conf for pg_cron to work? > > The readme says you may have to enable trust authentication [1] > and the > pg_hba.conf docs [2] have examples for that. > > [1] > https://github.com/citusdata/pg_cron#ensuring-pg_cron-can-start-jobs > [2] https://www.postgresql.org/docs/current/auth-pg-hba-conf.html > > -- > Erik > The answer is in link number two ([2]) in Eric's email. -- regards, marian wendt --------------oueKxxIMCxvHKZT17GqwA1D8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
There is already an entry for 
all all MD5. 
On top of that , how do I add trust ?

On Thu, 21 Sept 2023, 15:55 Erik Wienhold, <ewie@ewie.name> wrote:
On 2023-09-21 13:52 +0530, Rajesh Kumar wrote:
> I have installed pg_cron but the schedule seems not to be working.

How did you install it?  What have you configured so far?

> Anybody knows, how to configure pg_hba.conf for pg_cron to work?

The readme says you may have to enable trust authentication [1] and the
pg_hba.conf docs [2] have examples for that.

[1] https://github.com/citusdata/pg_cron#ensuring-pg_cron-can-start-jobs
[2] https://www.postgresql.org/docs/current/auth-pg-hba-conf.html

--
Erik

The answer is in link number two ([2]) in Eric's email.

--
regards, marian wendt
--------------oueKxxIMCxvHKZT17GqwA1D8--