Re: PG_Cron - Error Message Connection failed

Le dim. 14 mai 2023 à 16:12, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> a
écrit :

> 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.
>
> jobid | schedule | command | nodename | nodeport |
database | username | active | jobname
-------+------------+----------+-----------+----------+--------------------------------------------+----------+--------+---------
8 | 30 seconds | SELECT 1 | localhost | 5692 | databasename |
postgres | t | TEST
(1 row)

>
> >
> >
> >
> 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
>
>

--
Jaurès FOUTE