Re: PG_Cron - Error Message Connection failed

Le ven. 12 mai 2023 à 20:21, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> a
écrit :

> On 5/12/23 09:41, FOUTE K. Jaurès wrote:
> > Understand @Adrian Klaver <mailto:adrian(dot)klaver(at)aklaver(dot)com> .
> > the log show:
> > 2023-05-12 17:30:19.327 WAT [46190] LOG: cron job 8 starting: SELECT 1
> > 2023-05-12 17:30:19.339 WAT [46190] LOG: cron job 8 connection failed
>
> Well that did not go anywhere.
>
> 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 <adrian(dot)klaver(at)aklaver(dot)com> sorry for the delais.
Copy of content of cron.job ?

>
> >
> > Le ven. 12 mai 2023 à 17:23, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> > <mailto:adrian(dot)klaver(at)aklaver(dot)com>> a écrit :
> >
> > On 5/12/23 09:22, FOUTE K. Jaurès wrote:
> >
> > 1) Please do not top post. Use inline posting
> >
> > 2) Do not use images, copy and paste as text.
> >
> > > hello Fabricio,
> > >
> > > the listen_addresses is set to *
> > > the result of psql command line
> > > image.png
> > > The job on pg_cron
> > > image.png
> >
> > What does the Postgres log show when pg_cron is trying to make
> > connections?
> >
> >
> > --
> > 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