Le ven. 12 mai 2023 à 20:21, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> a écrit :
On 5/12/23 09:41, FOUTE K. Jaurès wrote:
> Understand @Adrian Klaver <mailto:adrian.klaver@xxxxxxxxxxx> .
> 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 sorry for the delais.
Copy of content of cron.job ?
>
> Le ven. 12 mai 2023 à 17:23, Adrian Klaver <adrian.klaver@xxxxxxxxxxx
> <mailto:adrian.klaver@xxxxxxxxxxx>> 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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
>
>
>
> --
> Jaurès FOUTE
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
Jaurès FOUTE