Re: PG_Cron - Error Message Connection failed

Try checking the view cron.job, column "nodename", if it's set to
"localhost", change it (via an UPDATE) to the address defined in
"listen_address" parameter and see if this works.

Em sex., 12 de mai. de 2023 às 17:00, FOUTE K. Jaurès <jauresfoute(at)gmail(dot)com>
escreveu:

> Hello everyone,
>
> Can someone help me to understand this issue. I installed and configured
> pg_cron on the server and I was able to connect without providing a
> password using psql command line.
> But when i schedule a job, like this: SELECT cron.schedule( 'TEST','30
> seconds', $$SELECT 1$$);
> the result show
> [image: image.png]
>
> Any help is welcome
>
> --
> Jaurès FOUTE
>

--
*Fabrício Pedroso Jorge.*
Database Architect / Database Engineer

*LinkedIn Profile*
http://br.linkedin.com/in/fabriciojorge

*Contacts:*
+ 353 085 8221706
fpjbito(at)gmail(dot)com