Re: PG_Cron - Error Message Connection failed - Mailing list pgsql-general

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

jobid |  schedule  | command  | nodename  | nodeport |                  database                  | username | active | jobname
-------+------------+----------+-----------+----------+--------------------------------------------+----------+--------+---------
     8 | 30 seconds | SELECT 1 | localhost |     5692 | databasename | postgres | t      | TEST

>
>
>     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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
> --
> Jaurès FOUTE

--
Adrian Klaver
adrian.klaver@aklaver.com