Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pyDPC-0001kX-64 for pgsql-general@arkaria.postgresql.org; Sun, 14 May 2023 15:13:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pyDPA-0004UM-VA for pgsql-general@arkaria.postgresql.org; Sun, 14 May 2023 15:13:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pyDPA-0004UD-L3 for pgsql-general@lists.postgresql.org; Sun, 14 May 2023 15:13:00 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pyDP6-002IMh-RM for pgsql-general@lists.postgresql.org; Sun, 14 May 2023 15:12:59 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 2EA395C0165; Sun, 14 May 2023 11:12:55 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Sun, 14 May 2023 11:12:55 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm3; t= 1684077175; x=1684163575; bh=+F5FqU0GWIJzsD/yW8BdeT2yuSd6wkiOq6r FN8z9FGs=; b=F7SRE0ZQicul3OwmCDsozGx/q5i3yXxBTIrpBO1SE7BHzWUJ92y pTbgmLgVzcd7Vu/PpLLYusZxMGcnoZdQi/xTXHXAs4HlDVJULzn9eLFqVvP7v3mS +5/qvAD9LT9xqdwzNP62dJ2ugA8i7XAr7F0tuxJutj8quSEGFDKu/3uvPKYlTdcc HMWFW0f0mou2ENE/lqUn3Eon/XXYLkNr0lC9W0//rXOsaOVmUO0uyaTJXluVSdZH Pusjiwi2oo4wCiHMLgaINdE0T7myn++SAlDxrlmfq7jMTe4ofGai3Mj/7px32L2o VtPva88EV5yD1EjJ7Fpew5JyLJzrvQz4eZg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1684077175; x=1684163575; bh=+F5FqU0GWIJzsD/yW8BdeT2yuSd6wkiOq6r FN8z9FGs=; b=V1u1oVJZ/pSUEXPgS8+HnLqEzEewrA825n5aYpMasCkF/DcvuWr Vv2AyqnEQTXZih94Pvxzn80RcddxKEoqE4N6Bo6uXHJtWTfpw7/NqTphS3VG5IAr 8WzDz9h947FPflt1yna1vC+OXiGCijQcDIToRckh2qe4yvbNtAun7wVvEmeOEpnS 6i8/UmyT5ISXz8l7OlFfWNSwubuNY1/v/NBzndstjV7/LpMJq/x9QszBiQSggPUI TPFv8zXJD08AdxrZ50n6QZkL8S7QF5+N0r0Djgm3u3tEgd1ipSdjVrSgQBfKn9im cw7ha3ACbkUXKRQAxq1xSpcSAOJgiYDZ6KA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfeehhedgkeejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtfeejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhephfegveekfeelffdvgfdvfefftdeujeehheeuieff hfefiefhvdfhgfetgfdvuefgnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrgh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughr ihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 14 May 2023 11:12:54 -0400 (EDT) Message-ID: <390d91e2-762d-5a8e-97ac-a645dc0dc271@aklaver.com> Date: Sun, 14 May 2023 08:12:53 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.1 Subject: Re: PG_Cron - Error Message Connection failed Content-Language: en-US To: =?UTF-8?Q?FOUTE_K=2e_Jaur=c3=a8s?= Cc: Fabricio Pedroso Jorge , PostgreSQL General References: <3b9c9577-8ff8-92f3-4e9f-6600770b938c@aklaver.com> <6dc19634-8441-b14e-5bb7-4491011da8df@aklaver.com> From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/14/23 00:20, FOUTE K. Jaurès wrote: > > > Le sam. 13 mai 2023 à 15:59, Adrian Klaver > a écrit : > > On 5/13/23 00:54, FOUTE K. Jaurès wrote: > > > > > > > > >     In your original post in the image under the database column > it looks > >     like, to my old eyes, there is a list of database names. > > > >     Is that the case? > > > >     Copy and paste that content in your reply. > > > > > > Hello @Adrian Klaver > sorry for the > > delais. > > Copy of content of cron.job ? > > The text version of whatever was in the image in this post: > > > i'm using Ubuntu server 22.04 LTS with PostgreSQL 13 > I install pg_cron using the command: sudo apt-get -y install > postgresql-13-cron Not what was requested. In the post linked to here: https://www.postgresql.org/message-id/CAHQ1jffWF7Y8c1X7EK3JvbLJgw1GEcVk0uPa3%2B0CJo4h8PFHVw%40mail.gmail.com there was an image of the result of: SELECT cron.schedule( 'TEST','30 seconds', $$SELECT 1$$); Provide that result as text. > > > https://www.postgresql.org/message-id/CAHQ1jffWF7Y8c1X7EK3JvbLJgw1GEcVk0uPa3%2B0CJo4h8PFHVw%40mail.gmail.com > > Or at least what was in the database column. > > > -- > > Jaurès FOUTE > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > > > -- > Jaurès FOUTE -- Adrian Klaver adrian.klaver@aklaver.com