Re: PG_Cron - Error Message Connection failed

On 5/12/23 09:41, FOUTE K. Jaurès wrote:
> Understand @Adrian Klaver <mailto:adrian.klaver@aklaver.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.

> 
> Le ven. 12 mai 2023 à 17:23, Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 
> 
> -- 
> Jaurès FOUTE

-- 
Adrian Klaver
adrian.klaver@aklaver.com