Re: PG_Cron - Error Message Connection failed

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: FOUTE K(dot) Jaurès <jauresfoute(at)gmail(dot)com>
Cc: Fabricio Pedroso Jorge <fpjbito(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PG_Cron - Error Message Connection failed
Date: 2023-05-14 15:12:53
Message-ID: 390d91e2-762d-5a8e-97ac-a645dc0dc271@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 5/14/23 00:20, FOUTE K. Jaurès wrote:
>
>
> Le sam. 13 mai 2023 à 15:59, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> 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 <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> 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 <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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>
> --
> Jaurès FOUTE

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sandeep Kumar Jakkaraju 2023-05-14 15:14:30 Re: stop
Previous Message Adrian Klaver 2023-05-14 15:08:36 Re: stop